web Interface freezing issue

[erkanerturk]

Hi

i have previously opened a topic: https://support.nagios.com/forum/viewto ... 16&t=61944
but we could not get a resolution. Now that threrad is locked, so i wanted to open this one witha new info.

when I see web UI freeze, i have noticed the mysql waiting locks..there are approx more than 30 such line in the output

show processlist;

OUTPUT:
command: query
time: 90 (there are values ranging from 33 to 200)
state: waiting for table metadata lock
info: Insert INTO xi_auditlog (log_time,source....) VALUES ...

i think this causes we freeze problem.. can you help us to solve this?

thanks

[gsmith]

Hi

Please follow this document:
https://assets.nagios.com/downloads/nag ... tabase.pdf

After performing the repair check to see if the waiting for locks is reduced.

Thanks

[erkanerturk]

Hi

I have done the repair and seen no error mesages on the screen. just fixing indexes messages..
by the way when i look at the tables, i see the following .. is that normal?

Code: Select all

MariaDB [(none)]> select table_name, data_length/(1024*1024) as "table size in MB",index_length from information_schema.TABLES where table_schema IN ('nagios','nagiosql','nagiosxi') order by data_length;
+--------------------------------------------+------------------+--------------+
| table_name                                 | table size in MB | index_length |
+--------------------------------------------+------------------+--------------+
...
| nagios_hoststatus                          |           0.5958 |       387072 |
| tbl_lnkServiceToServicetemplate            |           1.2813 |            0 |
| tbl_variabledefinition                     |           1.2813 |            0 |
| xi_cmp_nagiosbpi_backups                   |           1.5156 |            0 |
| tbl_service                                |           1.5156 |            0 |
| nagios_services                            |           1.9645 |       461824 |
| nagios_servicechecks                       |           2.0697 |       431104 |
| xi_usermeta                                |           2.5156 |       376832 |
| nagios_objects                             |           3.8170 |      3118080 |
| nagios_servicestatus                       |           5.1932 |      2281472 |
| nagios_flappinghistory                     |           9.5493 |      1572864 |
| nagios_commenthistory                      |          23.5465 |      2270208 |
| nagios_notifications                       |         150.3767 |     42685440 |
| nagios_contactnotifications                |         170.6334 |    255421440 |
| nagios_contactnotificationmethods          |         192.5094 |    208958464 |
| xi_events                                  |         415.9063 |    312901632 |
| nagios_statehistory                        |         417.4070 |    157355008 |
| nagios_logentries                          |        2544.8456 |   1338273792 |
| xi_auditlog                                |        2868.5000 |    881983488 |
| xi_meta                                    |       13352.9688 |            0 |
+--------------------------------------------+------------------+--------------+
175 rows in set (0.27 sec)

[gsmith]

Hi,

Did the freezing issue get solved or is it still happening?

What from the mysql query are you concerned about, anything specific?

Thanks