CPU high Centos6 to rhel 8.3 , Nagios 5.7.5 to v5.8.3
Posted: Tue Apr 13, 2021 10:24 pm
Hi Support
Recenly we upgrade the nagiosxi from v5.4 to 5.7.5 (inplace upgrade) without issue. We are facing very high cpu utilization. after we migrate the xi5.7.5 centos6 to xi 5.8.3 rhel 8.
https://support.nagios.com/forum/viewto ... 16&t=61539
The have a similar situation with the above thread link .
1. Are notifications be sent
Notification Disabled.
2. Can the customer access the GUI and perform necessary operations?
Yes and no, web portal are very slow and cannot load full page.
3. Are all the system components up and running, green status?
Most of them are green, except dbmaint is taking hours to complete.
4.Does the CPU load go down at night? How many users are logged into the system?
Nope. 1 to 2 user.
Mysql log:
# tail -n 100 /var/log/mysql/mysqld.log
2021-04-14T01:39:38.395924Z 0 [Warning] [MY-010909] [Server] /usr/libexec/mysqld: Forcing close of thread 243 user: 'nagiosql'.
2021-04-14T01:39:38.519682Z 0 [Warning] [MY-010909] [Server] /usr/libexec/mysqld: Forcing close of thread 139 user: 'ndoutils'.
2021-04-14T01:39:38.568320Z 0 [Warning] [MY-010909] [Server] /usr/libexec/mysqld: Forcing close of thread 43 user: 'nagiosql'.
2021-04-14T01:39:39.111731Z 0 [Warning] [MY-010909] [Server] /usr/libexec/mysqld: Forcing close of thread 899 user: 'ndoutils'.
2021-04-14T01:39:40.045625Z 0 [Warning] [MY-010909] [Server] /usr/libexec/mysqld: Forcing close of thread 115 user: 'nagiosql'.
2021-04-14T01:39:40.429216Z 0 [Warning] [MY-010909] [Server] /usr/libexec/mysqld: Forcing close of thread 891 user: 'ndoutils'.
2021-04-14T01:39:40.982079Z 0 [Warning] [MY-010909] [Server] /usr/libexec/mysqld: Forcing close of thread 643 user: 'nagiosql'.
2021-04-14T01:39:41.121380Z 0 [Warning] [MY-010909] [Server] /usr/libexec/mysqld: Forcing close of thread 907 user: 'ndoutils'.
2021-04-14T01:39:41.224968Z 0 [Warning] [MY-010909] [Server] /usr/libexec/mysqld: Forcing close of thread 324 user: 'nagiosql'.
2021-04-14T01:39:41.560309Z 0 [Warning] [MY-010909] [Server] /usr/libexec/mysqld: Forcing close of thread 436 user: 'nagiosql'.
2021-04-14T01:39:42.968554Z 0 [Warning] [MY-010909] [Server] /usr/libexec/mysqld: Forcing close of thread 364 user: 'nagiosxi'.
2021-04-14T01:39:43.259287Z 0 [Warning] [MY-010909] [Server] /usr/libexec/mysqld: Forcing close of thread 420 user: 'nagiosxi'.
2021-04-14T01:39:44.423939Z 0 [Warning] [MY-010909] [Server] /usr/libexec/mysqld: Forcing close of thread 236 user: 'ndoutils'.
2021-04-14T01:39:46.698100Z 0 [Warning] [MY-010909] [Server] /usr/libexec/mysqld: Forcing close of thread 204 user: 'nagiosql'.
2021-04-14T01:39:46.714709Z 0 [Warning] [MY-010909] [Server] /usr/libexec/mysqld: Forcing close of thread 484 user: 'nagiosql'.
2021-04-14T01:39:46.729611Z 0 [Warning] [MY-010909] [Server] /usr/libexec/mysqld: Forcing close of thread 492 user: 'ndoutils'.
2021-04-14T01:39:46.872632Z 0 [Warning] [MY-010909] [Server] /usr/libexec/mysqld: Forcing close of thread 252 user: 'ndoutils'.
2021-04-14T01:39:46.896342Z 0 [Warning] [MY-010909] [Server] /usr/libexec/mysqld: Forcing close of thread 892 user: 'nagiosql'.
2021-04-14T01:39:47.616820Z 0 [Warning] [MY-010909] [Server] /usr/libexec/mysqld: Forcing close of thread 900 user: 'nagiosql'.
2021-04-14T01:39:47.625300Z 0 [Warning] [MY-010909] [Server] /usr/libexec/mysqld: Forcing close of thread 172 user: 'nagiosql'.
2021-04-14T01:39:47.842410Z 0 [Warning] [MY-010909] [Server] /usr/libexec/mysqld: Forcing close of thread 300 user: 'nagiosxi'.
2021-04-14T01:39:47.852004Z 0 [Warning] [MY-010909] [Server] /usr/libexec/mysqld: Forcing close of thread 44 user: 'nagiosxi'.
2021-04-14T01:39:47.863852Z 0 [Warning] [MY-010909] [Server] /usr/libexec/mysqld: Forcing close of thread 116 user: 'nagiosxi'.
2021-04-14T01:39:47.893712Z 0 [Warning] [MY-010909] [Server] /usr/libexec/mysqld: Forcing close of thread 908 user: 'ndoutils'.
2021-04-14T01:39:47.918546Z 0 [Warning] [MY-010909] [Server] /usr/libexec/mysqld: Forcing close of thread 909 user: 'nagiosql'.
2021-04-14T01:39:48.080116Z 0 [Warning] [MY-010909] [Server] /usr/libexec/mysqld: Forcing close of thread 365 user: 'ndoutils'.
2021-04-14T01:39:48.093046Z 0 [Warning] [MY-010909] [Server] /usr/libexec/mysqld: Forcing close of thread 237 user: 'nagiosql'.
2021-04-14T01:39:48.124020Z 0 [Warning] [MY-010909] [Server] /usr/libexec/mysqld: Forcing close of thread 493 user: 'nagiosql'.
2021-04-14T01:39:48.124134Z 0 [Warning] [MY-010909] [Server] /usr/libexec/mysqld: Forcing close of thread 485 user: 'ndoutils'.
2021-04-14T01:39:48.159927Z 0 [Warning] [MY-010909] [Server] /usr/libexec/mysqld: Forcing close of thread 301 user: 'ndoutils'.
2021-04-14T01:39:48.197646Z 0 [Warning] [MY-010909] [Server] /usr/libexec/mysqld: Forcing close of thread 421 user: 'ndoutils'.
2021-04-14T01:39:48.198699Z 0 [Warning] [MY-010909] [Server] /usr/libexec/mysqld: Forcing close of thread 117 user: 'ndoutils'.
2021-04-14T01:39:48.212678Z 0 [Warning] [MY-010909] [Server] /usr/libexec/mysqld: Forcing close of thread 173 user: 'ndoutils'.
2021-04-14T01:39:48.855767Z 0 [Warning] [MY-010909] [Server] /usr/libexec/mysqld: Forcing close of thread 901 user: 'nagiosql'.
2021-04-14T01:39:48.868042Z 0 [Warning] [MY-010909] [Server] /usr/libexec/mysqld: Forcing close of thread 45 user: 'ndoutils'.
2021-04-14T01:39:49.020574Z 0 [Warning] [MY-010909] [Server] /usr/libexec/mysqld: Forcing close of thread 253 user: 'nagiosql'.
2021-04-14T01:39:50.724620Z 0 [Warning] [MY-010909] [Server] /usr/libexec/mysqld: Forcing close of thread 853 user: 'nagiosql'.
2021-04-14T01:39:50.730529Z 0 [Warning] [MY-010909] [Server] /usr/libexec/mysqld: Forcing close of thread 302 user: 'nagiosql'.
2021-04-14T01:39:50.730648Z 0 [Warning] [MY-010909] [Server] /usr/libexec/mysqld: Forcing close of thread 910 user: 'nagiosql'.
2021-04-14T01:39:51.613150Z 0 [Warning] [MY-010909] [Server] /usr/libexec/mysqld: Forcing close of thread 374 user: 'nagiosxi'.
2021-04-14T01:39:52.004033Z 0 [Warning] [MY-010909] [Server] /usr/libexec/mysqld: Forcing close of thread 422 user: 'nagiosxi'.
2021-04-14T01:39:52.020086Z 0 [Warning] [MY-010909] [Server] /usr/libexec/mysqld: Forcing close of thread 550 user: 'ndoutils'.
2021-04-14T01:39:52.023028Z 0 [Warning] [MY-010909] [Server] /usr/libexec/mysqld: Forcing close of thread 174 user: 'nagiosql'.
2021-04-14T01:39:54.709517Z 0 [Warning] [MY-010909] [Server] /usr/libexec/mysqld: Forcing close of thread 478 user: 'nagiosxi'.
2021-04-14T01:39:54.720840Z 0 [Warning] [MY-010909] [Server] /usr/libexec/mysqld: Forcing close of thread 166 user: 'nagiosxi'.
2021-04-14T01:39:56.301241Z 0 [Warning] [MY-010909] [Server] /usr/libexec/mysqld: Forcing close of thread 238 user: 'nagiosxi'.
2021-04-14T01:39:58.048980Z 0 [Warning] [MY-010909] [Server] /usr/libexec/mysqld: Forcing close of thread 190 user: 'nagiosxi'.
2021-04-14T01:39:58.059581Z 0 [Warning] [MY-010909] [Server] /usr/libexec/mysqld: Forcing close of thread 486 user: 'nagiosql'.
2021-04-14T01:39:58.068800Z 0 [Warning] [MY-010909] [Server] /usr/libexec/mysqld: Forcing close of thread 366 user: 'nagiosql'.
2021-04-14T01:39:58.104825Z 0 [Warning] [MY-010909] [Server] /usr/libexec/mysqld: Forcing close of thread 254 user: 'nagiosxi'.
2021-04-14T01:40:01.286031Z 0 [Warning] [MY-010909] [Server] /usr/libexec/mysqld: Forcing close of thread 46 user: 'nagiosql'.
2021-04-14T01:40:01.286435Z 0 [Warning] [MY-010909] [Server] /usr/libexec/mysqld: Forcing close of thread 118 user: 'nagiosxi'.
2021-04-14T01:40:05.005359Z 0 [Warning] [MY-010909] [Server] /usr/libexec/mysqld: Forcing close of thread 319 user: 'nagiosxi'.
2021-04-14T01:40:05.016997Z 0 [Warning] [MY-010909] [Server] /usr/libexec/mysqld: Forcing close of thread 303 user: 'nagiosxi'.
2021-04-14T01:40:05.019378Z 0 [Warning] [MY-010909] [Server] /usr/libexec/mysqld: Forcing close of thread 367 user: 'ndoutils'.
2021-04-14T01:40:05.019981Z 0 [Warning] [MY-010909] [Server] /usr/libexec/mysqld: Forcing close of thread 375 user: 'ndoutils'.
2021-04-14T01:40:05.028479Z 0 [Warning] [MY-010909] [Server] /usr/libexec/mysqld: Forcing close of thread 431 user: 'nagiosxi'.
2021-04-14T01:40:06.681362Z 0 [Warning] [MY-010909] [Server] /usr/libexec/mysqld: Forcing close of thread 167 user: 'ndoutils'.
2021-04-14T01:40:08.241875Z 0 [Warning] [MY-010909] [Server] /usr/libexec/mysqld: Forcing close of thread 423 user: 'nagiosql'.
2021-04-14T01:40:08.266746Z 0 [Warning] [MY-010909] [Server] /usr/libexec/mysqld: Forcing close of thread 479 user: 'nagiosxi'.
2021-04-14T01:40:08.718058Z 0 [Warning] [MY-010909] [Server] /usr/libexec/mysqld: Forcing close of thread 191 user: 'ndoutils'.
2021-04-14T01:40:08.966233Z 0 [Warning] [MY-010909] [Server] /usr/libexec/mysqld: Forcing close of thread 895 user: 'ndoutils'.
2021-04-14T01:40:08.967056Z 0 [Warning] [MY-010909] [Server] /usr/libexec/mysqld: Forcing close of thread 255 user: 'ndoutils'.
2021-04-14T01:40:09.744924Z 0 [Warning] [MY-010909] [Server] /usr/libexec/mysqld: Forcing close of thread 47 user: 'nagiosxi'.
2021-04-14T01:40:09.750769Z 0 [Warning] [MY-010909] [Server] /usr/libexec/mysqld: Forcing close of thread 119 user: 'nagiosql'.
2021-04-14T01:40:10.049787Z 0 [Warning] [MY-010909] [Server] /usr/libexec/mysqld: Forcing close of thread 239 user: 'ndoutils'.
2021-04-14T01:40:23.482061Z 0 [System] [MY-010910] [Server] /usr/libexec/mysqld: Shutdown complete (mysqld 8.0.21) Source distribution.
2021-04-14T01:48:49.624393Z 0 [Warning] [MY-010139] [Server] Changed limits: max_open_files: 10000 (requested 250000)
2021-04-14T01:48:49.624404Z 0 [Warning] [MY-010141] [Server] Changed limits: max_connections: 9190 (requested 50000)
2021-04-14T01:48:50.432731Z 0 [System] [MY-010116] [Server] /usr/libexec/mysqld (mysqld 8.0.21) starting as process 1440763
2021-04-14T01:48:50.486452Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2021-04-14T01:48:51.679349Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2021-04-14T01:48:52.490068Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /var/lib/mysql/mysqlx.sock
2021-04-14T01:48:53.901641Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2021-04-14T01:48:53.902125Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2021-04-14T01:48:54.075074Z 0 [System] [MY-010931] [Server] /usr/libexec/mysqld: ready for connections. Version: '8.0.21' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution.
2021-04-14T01:48:54.745212Z 0 [System] [MY-013172] [Server] Received SHUTDOWN from user <via user signal>. Shutting down mysqld (Version: 8.0.21).
2021-04-14T01:48:56.130935Z 0 [System] [MY-010910] [Server] /usr/libexec/mysqld: Shutdown complete (mysqld 8.0.21) Source distribution.
2021-04-14T01:48:57.437945Z 0 [Warning] [MY-010139] [Server] Changed limits: max_open_files: 10000 (requested 250000)
2021-04-14T01:48:57.437955Z 0 [Warning] [MY-010141] [Server] Changed limits: max_connections: 9190 (requested 50000)
2021-04-14T01:48:58.196295Z 0 [System] [MY-010116] [Server] /usr/libexec/mysqld (mysqld 8.0.21) starting as process 1441556
2021-04-14T01:48:58.256907Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2021-04-14T01:48:59.579631Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2021-04-14T01:49:00.278638Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /var/lib/mysql/mysqlx.sock
2021-04-14T01:49:01.143945Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2021-04-14T01:49:01.144492Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2021-04-14T01:49:01.450207Z 0 [System] [MY-010931] [Server] /usr/libexec/mysqld: ready for connections. Version: '8.0.21' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution.
2021-04-14T01:49:02.538628Z 0 [System] [MY-013172] [Server] Received SHUTDOWN from user <via user signal>. Shutting down mysqld (Version: 8.0.21).
2021-04-14T01:49:05.447186Z 0 [Warning] [MY-010909] [Server] /usr/libexec/mysqld: Forcing close of thread 8 user: 'nagiosxi'.
2021-04-14T01:49:05.447329Z 0 [Warning] [MY-010909] [Server] /usr/libexec/mysqld: Forcing close of thread 9 user: 'ndoutils'.
2021-04-14T01:49:06.822366Z 0 [System] [MY-010910] [Server] /usr/libexec/mysqld: Shutdown complete (mysqld 8.0.21) Source distribution.
2021-04-14T01:49:23.895258Z 0 [Warning] [MY-010139] [Server] Changed limits: max_open_files: 10000 (requested 250000)
2021-04-14T01:49:23.895278Z 0 [Warning] [MY-010141] [Server] Changed limits: max_connections: 9190 (requested 50000)
2021-04-14T01:49:24.561760Z 0 [System] [MY-010116] [Server] /usr/libexec/mysqld (mysqld 8.0.21) starting as process 1441917
2021-04-14T01:49:24.627106Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2021-04-14T01:49:25.251261Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2021-04-14T01:49:25.977419Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /var/lib/mysql/mysqlx.sock
2021-04-14T01:49:26.539806Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2021-04-14T01:49:26.540271Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2021-04-14T01:49:26.712659Z 0 [System] [MY-010931] [Server] /usr/libexec/mysqld: ready for connections. Version: '8.0.21' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution.
MY.CNF Setting
# cat mysql-server.cnf
#
# This group are read by MySQL server.
# Use it for options that only the server (but not clients) should see
#
# For advice on how to change settings please see
# http://dev.mysql.com/doc/refman/en/serv ... aults.html
# Settings user and group are ignored when systemd is used.
# If you need to run mysqld under a different user or group,
# customize your systemd unit file for mysqld according to the
# instructions in http://fedoraproject.org/wiki/Systemd
[mysqld]
tmp_table_size=64M
max_heap_table_size=64M
key_buffer_size=32M
table_open_cache=32
innodb_file_per_table=1
binlog_expire_logs_seconds=86400
sql_mode=NO_ENGINE_SUBSTITUTION
slow_query_log=1
slow-query_log_file = /var/log/mysql/mysql-slow.log
long_query_time=2
# Added for performance
max_connections = 50000
max_connect-errors = 100000
sort_buffer_size=256000000
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
log-error=/var/log/mysql/mysqld.log
pid-file=/run/mysqld/mysqld.pid
+--------------------------------------------+------------+
| Table | Size in MB |
+--------------------------------------------+------------+
| nagios_acknowledgements | 9.46 |
| nagios_commands | 0.02 |
| nagios_commenthistory | 15.80 |
| nagios_comments | 0.54 |
| nagios_configfiles | 0.01 |
| nagios_configfilevariables | 0.01 |
| nagios_conninfo | 5.76 |
| nagios_contact_addresses | 0.00 |
| nagios_contact_notificationcommands | 0.01 |
| nagios_contactgroup_members | 0.00 |
| nagios_contactgroups | 0.00 |
| nagios_contactnotificationmethods | 0.00 |
| nagios_contactnotifications | 0.00 |
| nagios_contacts | 0.01 |
| nagios_contactstatus | 0.00 |
| nagios_customvariables | 0.16 |
| nagios_customvariablestatus | 0.17 |
| nagios_dbversion | 0.00 |
| nagios_downtimehistory | 0.17 |
| nagios_eventhandlers | 0.47 |
| nagios_externalcommands | 2.85 |
| nagios_flappinghistory | 5.87 |
| nagios_host_contactgroups | 0.00 |
| nagios_host_contacts | 0.02 |
| nagios_host_parenthosts | 0.00 |
| nagios_hostchecks | 0.62 |
| nagios_hostdependencies | 0.00 |
| nagios_hostescalation_contactgroups | 0.00 |
| nagios_hostescalation_contacts | 0.00 |
| nagios_hostescalations | 0.00 |
| nagios_hostgroup_members | 0.03 |
| nagios_hostgroups | 0.00 |
| nagios_hosts | 0.17 |
| nagios_hoststatus | 0.30 |
| nagios_instances | 0.00 |
| nagios_logentries | 640.91 |
| nagios_notifications | 0.00 |
| nagios_objects | 0.82 |
| nagios_processevents | 4.37 |
| nagios_programstatus | 0.00 |
| nagios_runtimevariables | 0.00 |
| nagios_scheduleddowntime | 0.00 |
| nagios_service_contactgroups | 0.07 |
| nagios_service_contacts | 0.12 |
| nagios_service_parentservices | 0.00 |
| nagios_servicechecks | 3.53 |
| nagios_servicedependencies | 0.00 |
| nagios_serviceescalation_contactgroups | 0.00 |
| nagios_serviceescalation_contacts | 0.00 |
| nagios_serviceescalations | 0.00 |
| nagios_servicegroup_members | 0.00 |
| nagios_servicegroups | 0.00 |
| nagios_services | 0.74 |
| nagios_servicestatus | 1.94 |
| nagios_statehistory | 897.21 |
| nagios_systemcommands | 0.06 |
| nagios_timedeventqueue | 0.00 |
| nagios_timedevents | 0.00 |
| nagios_timeperiod_timeranges | 0.01 |
| nagios_timeperiods | 0.00 |
| tbl_command | 0.07 |
| tbl_contact | 0.01 |
| tbl_contactgroup | 0.01 |
| tbl_contacttemplate | 0.01 |
| tbl_domain | 0.01 |
| tbl_host | 0.15 |
| tbl_hostdependency | 0.00 |
| tbl_hostescalation | 0.00 |
| tbl_hostextinfo | 0.00 |
| tbl_hostgroup | 0.01 |
| tbl_hosttemplate | 0.02 |
| tbl_info | 0.27 |
| tbl_lnkContactToCommandHost | 0.00 |
| tbl_lnkContactToCommandService | 0.00 |
| tbl_lnkContactToContactgroup | 0.00 |
| tbl_lnkContactToContacttemplate | 0.00 |
| tbl_lnkContactToVariabledefinition | 0.00 |
| tbl_lnkContactgroupToContact | 0.00 |
| tbl_lnkContactgroupToContactgroup | 0.00 |
| tbl_lnkContacttemplateToCommandHost | 0.00 |
| tbl_lnkContacttemplateToCommandService | 0.00 |
| tbl_lnkContacttemplateToContactgroup | 0.00 |
| tbl_lnkContacttemplateToContacttemplate | 0.00 |
| tbl_lnkContacttemplateToVariabledefinition | 0.00 |
| tbl_lnkHostToContact | 0.01 |
| tbl_lnkHostToContactgroup | 0.00 |
| tbl_lnkHostToHost | 0.00 |
| tbl_lnkHostToHostgroup | 0.01 |
| tbl_lnkHostToHosttemplate | 0.01 |
| tbl_lnkHostToVariabledefinition | 0.01 |
| tbl_lnkHostdependencyToHost_DH | 0.00 |
| tbl_lnkHostdependencyToHost_H | 0.00 |
| tbl_lnkHostdependencyToHostgroup_DH | 0.00 |
| tbl_lnkHostdependencyToHostgroup_H | 0.00 |
| tbl_lnkHostescalationToContact | 0.00 |
| tbl_lnkHostescalationToContactgroup | 0.00 |
| tbl_lnkHostescalationToHost | 0.00 |
| tbl_lnkHostescalationToHostgroup | 0.00 |
| tbl_lnkHostgroupToHost | 0.00 |
| tbl_lnkHostgroupToHostgroup | 0.00 |
| tbl_lnkHosttemplateToContact | 0.00 |
| tbl_lnkHosttemplateToContactgroup | 0.00 |
| tbl_lnkHosttemplateToHost | 0.00 |
| tbl_lnkHosttemplateToHostgroup | 0.00 |
| tbl_lnkHosttemplateToHosttemplate | 0.00 |
| tbl_lnkHosttemplateToVariabledefinition | 0.00 |
| tbl_lnkServiceToContact | 0.03 |
| tbl_lnkServiceToContactgroup | 0.01 |
| tbl_lnkServiceToHost | 0.04 |
| tbl_lnkServiceToHostgroup | 0.00 |
| tbl_lnkServiceToServicegroup | 0.00 |
| tbl_lnkServiceToServicetemplate | 0.03 |
| tbl_lnkServiceToVariabledefinition | 0.02 |
| tbl_lnkServicedependencyToHost_DH | 0.00 |
| tbl_lnkServicedependencyToHost_H | 0.00 |
| tbl_lnkServicedependencyToHostgroup_DH | 0.00 |
| tbl_lnkServicedependencyToHostgroup_H | 0.00 |
| tbl_lnkServicedependencyToService_DS | 0.00 |
| tbl_lnkServicedependencyToService_S | 0.00 |
| tbl_lnkServicedependencyToServicegroup_DS | 0.02 |
| tbl_lnkServicedependencyToServicegroup_S | 0.02 |
| tbl_lnkServiceescalationToContact | 0.00 |
| tbl_lnkServiceescalationToContactgroup | 0.00 |
| tbl_lnkServiceescalationToHost | 0.00 |
| tbl_lnkServiceescalationToHostgroup | 0.00 |
| tbl_lnkServiceescalationToService | 0.00 |
| tbl_lnkServiceescalationToServicegroup | 0.02 |
| tbl_lnkServicegroupToService | 0.00 |
| tbl_lnkServicegroupToServicegroup | 0.00 |
| tbl_lnkServicetemplateToContact | 0.00 |
| tbl_lnkServicetemplateToContactgroup | 0.00 |
| tbl_lnkServicetemplateToHost | 0.00 |
| tbl_lnkServicetemplateToHostgroup | 0.00 |
| tbl_lnkServicetemplateToServicegroup | 0.00 |
| tbl_lnkServicetemplateToServicetemplate | 0.01 |
| tbl_lnkServicetemplateToVariabledefinition | 0.00 |
| tbl_lnkTimeperiodToTimeperiod | 0.00 |
| tbl_logbook | 0.04 |
| tbl_mainmenu | 0.00 |
| tbl_permission | 0.02 |
| tbl_permission_inactive | 0.02 |
| tbl_service | 0.29 |
| tbl_servicedependency | 0.00 |
| tbl_serviceescalation | 0.00 |
| tbl_serviceextinfo | 0.00 |
| tbl_servicegroup | 0.01 |
| tbl_servicetemplate | 0.03 |
| tbl_session | 0.00 |
| tbl_session_locks | 0.00 |
| tbl_settings | 0.00 |
| tbl_submenu | 0.00 |
| tbl_timedefinition | 0.02 |
| tbl_timeperiod | 0.01 |
| tbl_user | 0.01 |
| tbl_variabledefinition | 0.09 |
| xi_auditlog | 0.90 |
| xi_auth_tokens | 0.03 |
| xi_cmp_ccm_backups | 0.02 |
| xi_cmp_favorites | 0.03 |
| xi_cmp_nagiosbpi_backups | 0.05 |
| xi_cmp_scheduledreports_log | 0.02 |
| xi_cmp_trapdata | 0.03 |
| xi_cmp_trapdata_log | 0.03 |
| xi_commands | 0.00 |
| xi_deploy_agents | 0.02 |
| xi_deploy_jobs | 0.02 |
| xi_eventqueue | 34.84 |
| xi_events | 6.94 |
| xi_incidents | 0.00 |
| xi_meta | 304.63 |
| xi_mibs | 0.05 |
| xi_options | 0.04 |
| xi_sessions | 0.03 |
| xi_sysstat | 0.01 |
| xi_usermeta | 0.22 |
| xi_users | 0.02 |
+--------------------------------------------+------------+
Thanks,
Safuan
Recenly we upgrade the nagiosxi from v5.4 to 5.7.5 (inplace upgrade) without issue. We are facing very high cpu utilization. after we migrate the xi5.7.5 centos6 to xi 5.8.3 rhel 8.
https://support.nagios.com/forum/viewto ... 16&t=61539
The have a similar situation with the above thread link .
1. Are notifications be sent
Notification Disabled.
2. Can the customer access the GUI and perform necessary operations?
Yes and no, web portal are very slow and cannot load full page.
3. Are all the system components up and running, green status?
Most of them are green, except dbmaint is taking hours to complete.
4.Does the CPU load go down at night? How many users are logged into the system?
Nope. 1 to 2 user.
Mysql log:
# tail -n 100 /var/log/mysql/mysqld.log
2021-04-14T01:39:38.395924Z 0 [Warning] [MY-010909] [Server] /usr/libexec/mysqld: Forcing close of thread 243 user: 'nagiosql'.
2021-04-14T01:39:38.519682Z 0 [Warning] [MY-010909] [Server] /usr/libexec/mysqld: Forcing close of thread 139 user: 'ndoutils'.
2021-04-14T01:39:38.568320Z 0 [Warning] [MY-010909] [Server] /usr/libexec/mysqld: Forcing close of thread 43 user: 'nagiosql'.
2021-04-14T01:39:39.111731Z 0 [Warning] [MY-010909] [Server] /usr/libexec/mysqld: Forcing close of thread 899 user: 'ndoutils'.
2021-04-14T01:39:40.045625Z 0 [Warning] [MY-010909] [Server] /usr/libexec/mysqld: Forcing close of thread 115 user: 'nagiosql'.
2021-04-14T01:39:40.429216Z 0 [Warning] [MY-010909] [Server] /usr/libexec/mysqld: Forcing close of thread 891 user: 'ndoutils'.
2021-04-14T01:39:40.982079Z 0 [Warning] [MY-010909] [Server] /usr/libexec/mysqld: Forcing close of thread 643 user: 'nagiosql'.
2021-04-14T01:39:41.121380Z 0 [Warning] [MY-010909] [Server] /usr/libexec/mysqld: Forcing close of thread 907 user: 'ndoutils'.
2021-04-14T01:39:41.224968Z 0 [Warning] [MY-010909] [Server] /usr/libexec/mysqld: Forcing close of thread 324 user: 'nagiosql'.
2021-04-14T01:39:41.560309Z 0 [Warning] [MY-010909] [Server] /usr/libexec/mysqld: Forcing close of thread 436 user: 'nagiosql'.
2021-04-14T01:39:42.968554Z 0 [Warning] [MY-010909] [Server] /usr/libexec/mysqld: Forcing close of thread 364 user: 'nagiosxi'.
2021-04-14T01:39:43.259287Z 0 [Warning] [MY-010909] [Server] /usr/libexec/mysqld: Forcing close of thread 420 user: 'nagiosxi'.
2021-04-14T01:39:44.423939Z 0 [Warning] [MY-010909] [Server] /usr/libexec/mysqld: Forcing close of thread 236 user: 'ndoutils'.
2021-04-14T01:39:46.698100Z 0 [Warning] [MY-010909] [Server] /usr/libexec/mysqld: Forcing close of thread 204 user: 'nagiosql'.
2021-04-14T01:39:46.714709Z 0 [Warning] [MY-010909] [Server] /usr/libexec/mysqld: Forcing close of thread 484 user: 'nagiosql'.
2021-04-14T01:39:46.729611Z 0 [Warning] [MY-010909] [Server] /usr/libexec/mysqld: Forcing close of thread 492 user: 'ndoutils'.
2021-04-14T01:39:46.872632Z 0 [Warning] [MY-010909] [Server] /usr/libexec/mysqld: Forcing close of thread 252 user: 'ndoutils'.
2021-04-14T01:39:46.896342Z 0 [Warning] [MY-010909] [Server] /usr/libexec/mysqld: Forcing close of thread 892 user: 'nagiosql'.
2021-04-14T01:39:47.616820Z 0 [Warning] [MY-010909] [Server] /usr/libexec/mysqld: Forcing close of thread 900 user: 'nagiosql'.
2021-04-14T01:39:47.625300Z 0 [Warning] [MY-010909] [Server] /usr/libexec/mysqld: Forcing close of thread 172 user: 'nagiosql'.
2021-04-14T01:39:47.842410Z 0 [Warning] [MY-010909] [Server] /usr/libexec/mysqld: Forcing close of thread 300 user: 'nagiosxi'.
2021-04-14T01:39:47.852004Z 0 [Warning] [MY-010909] [Server] /usr/libexec/mysqld: Forcing close of thread 44 user: 'nagiosxi'.
2021-04-14T01:39:47.863852Z 0 [Warning] [MY-010909] [Server] /usr/libexec/mysqld: Forcing close of thread 116 user: 'nagiosxi'.
2021-04-14T01:39:47.893712Z 0 [Warning] [MY-010909] [Server] /usr/libexec/mysqld: Forcing close of thread 908 user: 'ndoutils'.
2021-04-14T01:39:47.918546Z 0 [Warning] [MY-010909] [Server] /usr/libexec/mysqld: Forcing close of thread 909 user: 'nagiosql'.
2021-04-14T01:39:48.080116Z 0 [Warning] [MY-010909] [Server] /usr/libexec/mysqld: Forcing close of thread 365 user: 'ndoutils'.
2021-04-14T01:39:48.093046Z 0 [Warning] [MY-010909] [Server] /usr/libexec/mysqld: Forcing close of thread 237 user: 'nagiosql'.
2021-04-14T01:39:48.124020Z 0 [Warning] [MY-010909] [Server] /usr/libexec/mysqld: Forcing close of thread 493 user: 'nagiosql'.
2021-04-14T01:39:48.124134Z 0 [Warning] [MY-010909] [Server] /usr/libexec/mysqld: Forcing close of thread 485 user: 'ndoutils'.
2021-04-14T01:39:48.159927Z 0 [Warning] [MY-010909] [Server] /usr/libexec/mysqld: Forcing close of thread 301 user: 'ndoutils'.
2021-04-14T01:39:48.197646Z 0 [Warning] [MY-010909] [Server] /usr/libexec/mysqld: Forcing close of thread 421 user: 'ndoutils'.
2021-04-14T01:39:48.198699Z 0 [Warning] [MY-010909] [Server] /usr/libexec/mysqld: Forcing close of thread 117 user: 'ndoutils'.
2021-04-14T01:39:48.212678Z 0 [Warning] [MY-010909] [Server] /usr/libexec/mysqld: Forcing close of thread 173 user: 'ndoutils'.
2021-04-14T01:39:48.855767Z 0 [Warning] [MY-010909] [Server] /usr/libexec/mysqld: Forcing close of thread 901 user: 'nagiosql'.
2021-04-14T01:39:48.868042Z 0 [Warning] [MY-010909] [Server] /usr/libexec/mysqld: Forcing close of thread 45 user: 'ndoutils'.
2021-04-14T01:39:49.020574Z 0 [Warning] [MY-010909] [Server] /usr/libexec/mysqld: Forcing close of thread 253 user: 'nagiosql'.
2021-04-14T01:39:50.724620Z 0 [Warning] [MY-010909] [Server] /usr/libexec/mysqld: Forcing close of thread 853 user: 'nagiosql'.
2021-04-14T01:39:50.730529Z 0 [Warning] [MY-010909] [Server] /usr/libexec/mysqld: Forcing close of thread 302 user: 'nagiosql'.
2021-04-14T01:39:50.730648Z 0 [Warning] [MY-010909] [Server] /usr/libexec/mysqld: Forcing close of thread 910 user: 'nagiosql'.
2021-04-14T01:39:51.613150Z 0 [Warning] [MY-010909] [Server] /usr/libexec/mysqld: Forcing close of thread 374 user: 'nagiosxi'.
2021-04-14T01:39:52.004033Z 0 [Warning] [MY-010909] [Server] /usr/libexec/mysqld: Forcing close of thread 422 user: 'nagiosxi'.
2021-04-14T01:39:52.020086Z 0 [Warning] [MY-010909] [Server] /usr/libexec/mysqld: Forcing close of thread 550 user: 'ndoutils'.
2021-04-14T01:39:52.023028Z 0 [Warning] [MY-010909] [Server] /usr/libexec/mysqld: Forcing close of thread 174 user: 'nagiosql'.
2021-04-14T01:39:54.709517Z 0 [Warning] [MY-010909] [Server] /usr/libexec/mysqld: Forcing close of thread 478 user: 'nagiosxi'.
2021-04-14T01:39:54.720840Z 0 [Warning] [MY-010909] [Server] /usr/libexec/mysqld: Forcing close of thread 166 user: 'nagiosxi'.
2021-04-14T01:39:56.301241Z 0 [Warning] [MY-010909] [Server] /usr/libexec/mysqld: Forcing close of thread 238 user: 'nagiosxi'.
2021-04-14T01:39:58.048980Z 0 [Warning] [MY-010909] [Server] /usr/libexec/mysqld: Forcing close of thread 190 user: 'nagiosxi'.
2021-04-14T01:39:58.059581Z 0 [Warning] [MY-010909] [Server] /usr/libexec/mysqld: Forcing close of thread 486 user: 'nagiosql'.
2021-04-14T01:39:58.068800Z 0 [Warning] [MY-010909] [Server] /usr/libexec/mysqld: Forcing close of thread 366 user: 'nagiosql'.
2021-04-14T01:39:58.104825Z 0 [Warning] [MY-010909] [Server] /usr/libexec/mysqld: Forcing close of thread 254 user: 'nagiosxi'.
2021-04-14T01:40:01.286031Z 0 [Warning] [MY-010909] [Server] /usr/libexec/mysqld: Forcing close of thread 46 user: 'nagiosql'.
2021-04-14T01:40:01.286435Z 0 [Warning] [MY-010909] [Server] /usr/libexec/mysqld: Forcing close of thread 118 user: 'nagiosxi'.
2021-04-14T01:40:05.005359Z 0 [Warning] [MY-010909] [Server] /usr/libexec/mysqld: Forcing close of thread 319 user: 'nagiosxi'.
2021-04-14T01:40:05.016997Z 0 [Warning] [MY-010909] [Server] /usr/libexec/mysqld: Forcing close of thread 303 user: 'nagiosxi'.
2021-04-14T01:40:05.019378Z 0 [Warning] [MY-010909] [Server] /usr/libexec/mysqld: Forcing close of thread 367 user: 'ndoutils'.
2021-04-14T01:40:05.019981Z 0 [Warning] [MY-010909] [Server] /usr/libexec/mysqld: Forcing close of thread 375 user: 'ndoutils'.
2021-04-14T01:40:05.028479Z 0 [Warning] [MY-010909] [Server] /usr/libexec/mysqld: Forcing close of thread 431 user: 'nagiosxi'.
2021-04-14T01:40:06.681362Z 0 [Warning] [MY-010909] [Server] /usr/libexec/mysqld: Forcing close of thread 167 user: 'ndoutils'.
2021-04-14T01:40:08.241875Z 0 [Warning] [MY-010909] [Server] /usr/libexec/mysqld: Forcing close of thread 423 user: 'nagiosql'.
2021-04-14T01:40:08.266746Z 0 [Warning] [MY-010909] [Server] /usr/libexec/mysqld: Forcing close of thread 479 user: 'nagiosxi'.
2021-04-14T01:40:08.718058Z 0 [Warning] [MY-010909] [Server] /usr/libexec/mysqld: Forcing close of thread 191 user: 'ndoutils'.
2021-04-14T01:40:08.966233Z 0 [Warning] [MY-010909] [Server] /usr/libexec/mysqld: Forcing close of thread 895 user: 'ndoutils'.
2021-04-14T01:40:08.967056Z 0 [Warning] [MY-010909] [Server] /usr/libexec/mysqld: Forcing close of thread 255 user: 'ndoutils'.
2021-04-14T01:40:09.744924Z 0 [Warning] [MY-010909] [Server] /usr/libexec/mysqld: Forcing close of thread 47 user: 'nagiosxi'.
2021-04-14T01:40:09.750769Z 0 [Warning] [MY-010909] [Server] /usr/libexec/mysqld: Forcing close of thread 119 user: 'nagiosql'.
2021-04-14T01:40:10.049787Z 0 [Warning] [MY-010909] [Server] /usr/libexec/mysqld: Forcing close of thread 239 user: 'ndoutils'.
2021-04-14T01:40:23.482061Z 0 [System] [MY-010910] [Server] /usr/libexec/mysqld: Shutdown complete (mysqld 8.0.21) Source distribution.
2021-04-14T01:48:49.624393Z 0 [Warning] [MY-010139] [Server] Changed limits: max_open_files: 10000 (requested 250000)
2021-04-14T01:48:49.624404Z 0 [Warning] [MY-010141] [Server] Changed limits: max_connections: 9190 (requested 50000)
2021-04-14T01:48:50.432731Z 0 [System] [MY-010116] [Server] /usr/libexec/mysqld (mysqld 8.0.21) starting as process 1440763
2021-04-14T01:48:50.486452Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2021-04-14T01:48:51.679349Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2021-04-14T01:48:52.490068Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /var/lib/mysql/mysqlx.sock
2021-04-14T01:48:53.901641Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2021-04-14T01:48:53.902125Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2021-04-14T01:48:54.075074Z 0 [System] [MY-010931] [Server] /usr/libexec/mysqld: ready for connections. Version: '8.0.21' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution.
2021-04-14T01:48:54.745212Z 0 [System] [MY-013172] [Server] Received SHUTDOWN from user <via user signal>. Shutting down mysqld (Version: 8.0.21).
2021-04-14T01:48:56.130935Z 0 [System] [MY-010910] [Server] /usr/libexec/mysqld: Shutdown complete (mysqld 8.0.21) Source distribution.
2021-04-14T01:48:57.437945Z 0 [Warning] [MY-010139] [Server] Changed limits: max_open_files: 10000 (requested 250000)
2021-04-14T01:48:57.437955Z 0 [Warning] [MY-010141] [Server] Changed limits: max_connections: 9190 (requested 50000)
2021-04-14T01:48:58.196295Z 0 [System] [MY-010116] [Server] /usr/libexec/mysqld (mysqld 8.0.21) starting as process 1441556
2021-04-14T01:48:58.256907Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2021-04-14T01:48:59.579631Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2021-04-14T01:49:00.278638Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /var/lib/mysql/mysqlx.sock
2021-04-14T01:49:01.143945Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2021-04-14T01:49:01.144492Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2021-04-14T01:49:01.450207Z 0 [System] [MY-010931] [Server] /usr/libexec/mysqld: ready for connections. Version: '8.0.21' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution.
2021-04-14T01:49:02.538628Z 0 [System] [MY-013172] [Server] Received SHUTDOWN from user <via user signal>. Shutting down mysqld (Version: 8.0.21).
2021-04-14T01:49:05.447186Z 0 [Warning] [MY-010909] [Server] /usr/libexec/mysqld: Forcing close of thread 8 user: 'nagiosxi'.
2021-04-14T01:49:05.447329Z 0 [Warning] [MY-010909] [Server] /usr/libexec/mysqld: Forcing close of thread 9 user: 'ndoutils'.
2021-04-14T01:49:06.822366Z 0 [System] [MY-010910] [Server] /usr/libexec/mysqld: Shutdown complete (mysqld 8.0.21) Source distribution.
2021-04-14T01:49:23.895258Z 0 [Warning] [MY-010139] [Server] Changed limits: max_open_files: 10000 (requested 250000)
2021-04-14T01:49:23.895278Z 0 [Warning] [MY-010141] [Server] Changed limits: max_connections: 9190 (requested 50000)
2021-04-14T01:49:24.561760Z 0 [System] [MY-010116] [Server] /usr/libexec/mysqld (mysqld 8.0.21) starting as process 1441917
2021-04-14T01:49:24.627106Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2021-04-14T01:49:25.251261Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2021-04-14T01:49:25.977419Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /var/lib/mysql/mysqlx.sock
2021-04-14T01:49:26.539806Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2021-04-14T01:49:26.540271Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2021-04-14T01:49:26.712659Z 0 [System] [MY-010931] [Server] /usr/libexec/mysqld: ready for connections. Version: '8.0.21' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution.
MY.CNF Setting
# cat mysql-server.cnf
#
# This group are read by MySQL server.
# Use it for options that only the server (but not clients) should see
#
# For advice on how to change settings please see
# http://dev.mysql.com/doc/refman/en/serv ... aults.html
# Settings user and group are ignored when systemd is used.
# If you need to run mysqld under a different user or group,
# customize your systemd unit file for mysqld according to the
# instructions in http://fedoraproject.org/wiki/Systemd
[mysqld]
tmp_table_size=64M
max_heap_table_size=64M
key_buffer_size=32M
table_open_cache=32
innodb_file_per_table=1
binlog_expire_logs_seconds=86400
sql_mode=NO_ENGINE_SUBSTITUTION
slow_query_log=1
slow-query_log_file = /var/log/mysql/mysql-slow.log
long_query_time=2
# Added for performance
max_connections = 50000
max_connect-errors = 100000
sort_buffer_size=256000000
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
log-error=/var/log/mysql/mysqld.log
pid-file=/run/mysqld/mysqld.pid
+--------------------------------------------+------------+
| Table | Size in MB |
+--------------------------------------------+------------+
| nagios_acknowledgements | 9.46 |
| nagios_commands | 0.02 |
| nagios_commenthistory | 15.80 |
| nagios_comments | 0.54 |
| nagios_configfiles | 0.01 |
| nagios_configfilevariables | 0.01 |
| nagios_conninfo | 5.76 |
| nagios_contact_addresses | 0.00 |
| nagios_contact_notificationcommands | 0.01 |
| nagios_contactgroup_members | 0.00 |
| nagios_contactgroups | 0.00 |
| nagios_contactnotificationmethods | 0.00 |
| nagios_contactnotifications | 0.00 |
| nagios_contacts | 0.01 |
| nagios_contactstatus | 0.00 |
| nagios_customvariables | 0.16 |
| nagios_customvariablestatus | 0.17 |
| nagios_dbversion | 0.00 |
| nagios_downtimehistory | 0.17 |
| nagios_eventhandlers | 0.47 |
| nagios_externalcommands | 2.85 |
| nagios_flappinghistory | 5.87 |
| nagios_host_contactgroups | 0.00 |
| nagios_host_contacts | 0.02 |
| nagios_host_parenthosts | 0.00 |
| nagios_hostchecks | 0.62 |
| nagios_hostdependencies | 0.00 |
| nagios_hostescalation_contactgroups | 0.00 |
| nagios_hostescalation_contacts | 0.00 |
| nagios_hostescalations | 0.00 |
| nagios_hostgroup_members | 0.03 |
| nagios_hostgroups | 0.00 |
| nagios_hosts | 0.17 |
| nagios_hoststatus | 0.30 |
| nagios_instances | 0.00 |
| nagios_logentries | 640.91 |
| nagios_notifications | 0.00 |
| nagios_objects | 0.82 |
| nagios_processevents | 4.37 |
| nagios_programstatus | 0.00 |
| nagios_runtimevariables | 0.00 |
| nagios_scheduleddowntime | 0.00 |
| nagios_service_contactgroups | 0.07 |
| nagios_service_contacts | 0.12 |
| nagios_service_parentservices | 0.00 |
| nagios_servicechecks | 3.53 |
| nagios_servicedependencies | 0.00 |
| nagios_serviceescalation_contactgroups | 0.00 |
| nagios_serviceescalation_contacts | 0.00 |
| nagios_serviceescalations | 0.00 |
| nagios_servicegroup_members | 0.00 |
| nagios_servicegroups | 0.00 |
| nagios_services | 0.74 |
| nagios_servicestatus | 1.94 |
| nagios_statehistory | 897.21 |
| nagios_systemcommands | 0.06 |
| nagios_timedeventqueue | 0.00 |
| nagios_timedevents | 0.00 |
| nagios_timeperiod_timeranges | 0.01 |
| nagios_timeperiods | 0.00 |
| tbl_command | 0.07 |
| tbl_contact | 0.01 |
| tbl_contactgroup | 0.01 |
| tbl_contacttemplate | 0.01 |
| tbl_domain | 0.01 |
| tbl_host | 0.15 |
| tbl_hostdependency | 0.00 |
| tbl_hostescalation | 0.00 |
| tbl_hostextinfo | 0.00 |
| tbl_hostgroup | 0.01 |
| tbl_hosttemplate | 0.02 |
| tbl_info | 0.27 |
| tbl_lnkContactToCommandHost | 0.00 |
| tbl_lnkContactToCommandService | 0.00 |
| tbl_lnkContactToContactgroup | 0.00 |
| tbl_lnkContactToContacttemplate | 0.00 |
| tbl_lnkContactToVariabledefinition | 0.00 |
| tbl_lnkContactgroupToContact | 0.00 |
| tbl_lnkContactgroupToContactgroup | 0.00 |
| tbl_lnkContacttemplateToCommandHost | 0.00 |
| tbl_lnkContacttemplateToCommandService | 0.00 |
| tbl_lnkContacttemplateToContactgroup | 0.00 |
| tbl_lnkContacttemplateToContacttemplate | 0.00 |
| tbl_lnkContacttemplateToVariabledefinition | 0.00 |
| tbl_lnkHostToContact | 0.01 |
| tbl_lnkHostToContactgroup | 0.00 |
| tbl_lnkHostToHost | 0.00 |
| tbl_lnkHostToHostgroup | 0.01 |
| tbl_lnkHostToHosttemplate | 0.01 |
| tbl_lnkHostToVariabledefinition | 0.01 |
| tbl_lnkHostdependencyToHost_DH | 0.00 |
| tbl_lnkHostdependencyToHost_H | 0.00 |
| tbl_lnkHostdependencyToHostgroup_DH | 0.00 |
| tbl_lnkHostdependencyToHostgroup_H | 0.00 |
| tbl_lnkHostescalationToContact | 0.00 |
| tbl_lnkHostescalationToContactgroup | 0.00 |
| tbl_lnkHostescalationToHost | 0.00 |
| tbl_lnkHostescalationToHostgroup | 0.00 |
| tbl_lnkHostgroupToHost | 0.00 |
| tbl_lnkHostgroupToHostgroup | 0.00 |
| tbl_lnkHosttemplateToContact | 0.00 |
| tbl_lnkHosttemplateToContactgroup | 0.00 |
| tbl_lnkHosttemplateToHost | 0.00 |
| tbl_lnkHosttemplateToHostgroup | 0.00 |
| tbl_lnkHosttemplateToHosttemplate | 0.00 |
| tbl_lnkHosttemplateToVariabledefinition | 0.00 |
| tbl_lnkServiceToContact | 0.03 |
| tbl_lnkServiceToContactgroup | 0.01 |
| tbl_lnkServiceToHost | 0.04 |
| tbl_lnkServiceToHostgroup | 0.00 |
| tbl_lnkServiceToServicegroup | 0.00 |
| tbl_lnkServiceToServicetemplate | 0.03 |
| tbl_lnkServiceToVariabledefinition | 0.02 |
| tbl_lnkServicedependencyToHost_DH | 0.00 |
| tbl_lnkServicedependencyToHost_H | 0.00 |
| tbl_lnkServicedependencyToHostgroup_DH | 0.00 |
| tbl_lnkServicedependencyToHostgroup_H | 0.00 |
| tbl_lnkServicedependencyToService_DS | 0.00 |
| tbl_lnkServicedependencyToService_S | 0.00 |
| tbl_lnkServicedependencyToServicegroup_DS | 0.02 |
| tbl_lnkServicedependencyToServicegroup_S | 0.02 |
| tbl_lnkServiceescalationToContact | 0.00 |
| tbl_lnkServiceescalationToContactgroup | 0.00 |
| tbl_lnkServiceescalationToHost | 0.00 |
| tbl_lnkServiceescalationToHostgroup | 0.00 |
| tbl_lnkServiceescalationToService | 0.00 |
| tbl_lnkServiceescalationToServicegroup | 0.02 |
| tbl_lnkServicegroupToService | 0.00 |
| tbl_lnkServicegroupToServicegroup | 0.00 |
| tbl_lnkServicetemplateToContact | 0.00 |
| tbl_lnkServicetemplateToContactgroup | 0.00 |
| tbl_lnkServicetemplateToHost | 0.00 |
| tbl_lnkServicetemplateToHostgroup | 0.00 |
| tbl_lnkServicetemplateToServicegroup | 0.00 |
| tbl_lnkServicetemplateToServicetemplate | 0.01 |
| tbl_lnkServicetemplateToVariabledefinition | 0.00 |
| tbl_lnkTimeperiodToTimeperiod | 0.00 |
| tbl_logbook | 0.04 |
| tbl_mainmenu | 0.00 |
| tbl_permission | 0.02 |
| tbl_permission_inactive | 0.02 |
| tbl_service | 0.29 |
| tbl_servicedependency | 0.00 |
| tbl_serviceescalation | 0.00 |
| tbl_serviceextinfo | 0.00 |
| tbl_servicegroup | 0.01 |
| tbl_servicetemplate | 0.03 |
| tbl_session | 0.00 |
| tbl_session_locks | 0.00 |
| tbl_settings | 0.00 |
| tbl_submenu | 0.00 |
| tbl_timedefinition | 0.02 |
| tbl_timeperiod | 0.01 |
| tbl_user | 0.01 |
| tbl_variabledefinition | 0.09 |
| xi_auditlog | 0.90 |
| xi_auth_tokens | 0.03 |
| xi_cmp_ccm_backups | 0.02 |
| xi_cmp_favorites | 0.03 |
| xi_cmp_nagiosbpi_backups | 0.05 |
| xi_cmp_scheduledreports_log | 0.02 |
| xi_cmp_trapdata | 0.03 |
| xi_cmp_trapdata_log | 0.03 |
| xi_commands | 0.00 |
| xi_deploy_agents | 0.02 |
| xi_deploy_jobs | 0.02 |
| xi_eventqueue | 34.84 |
| xi_events | 6.94 |
| xi_incidents | 0.00 |
| xi_meta | 304.63 |
| xi_mibs | 0.05 |
| xi_options | 0.04 |
| xi_sessions | 0.03 |
| xi_sysstat | 0.01 |
| xi_usermeta | 0.22 |
| xi_users | 0.02 |
+--------------------------------------------+------------+
Thanks,
Safuan