we are facing high load on our nagios xi servers.
nagios 5.5 version
mostly i see the vmware api process which is consuming high cpu. please help us in getting this resolved.
Load average is high on the Nagios server
-
IT-OPS-SYS
- Posts: 184
- Joined: Sun Jan 07, 2018 12:56 pm
Load average is high on the Nagios server
You do not have the required permissions to view the files attached to this post.
Re: Load average is high on the Nagios server
Try running "ps aux | grep vmware" to see if we can get more details on these checks. They appear to be taking a long time and could indicate a problem with a specific host or check that we can disable or modify.
As of May 25th, 2018, all communications with Nagios Enterprises and its employees are covered under our new Privacy Policy.
-
IT-OPS-SYS
- Posts: 184
- Joined: Sun Jan 07, 2018 12:56 pm
Re: Load average is high on the Nagios server
@cvrmnagiosxi001 libexec]$ ps aux | grep vmware
nagios 31676 0.0 0.0 116512 720 ? S 04:58 0:00 /usr/local/nagios/libexec/check_by_ssh -E 1 -t 90 -l vi-admin -H 149.24.38.141 -C ~/box293_check_vmware.pl --timeout 90 --server malvc1.corp.sct.com --check Datastore_Usage --name "DEV_ise_Pp1_008" --reporting_si "Disk_Size:GB" "--warning" "datastore_free:8" "" ""
nagios 31677 0.0 0.0 79484 4308 ? S 04:58 0:00 /bin/ssh -l vi-admin 149.24.38.141 ~/box293_check_vmware.pl --timeout 90 --server malvc1.corp.sct.com --check Datastore_Usage --name "DEV_ise_Pp1_008" --reporting_si "Disk_Size:GB" "--warning" "datastore_free:8" "" ""
nagios 31705 56.0 0.2 230300 41528 ? R 04:58 0:00 /usr/bin/perl -w /usr/local/nagios/libexec/check_vmware_api.pl -H mal4vi123.ellucian.com -f /usr/local/nagiosxi/etc/components/vmware/mal3vi36_ellucian_com_auth.txt -l NET
nagios 31711 68.0 0.2 230256 41528 ? R 04:58 0:00 /usr/bin/perl -w /usr/local/nagios/libexec/check_vmware_api.pl -H malvi6.ellucian.com -f /usr/local/nagiosxi/etc/components/vmware/mal3vi36_ellucian_com_auth.txt -l NET
nagios 31724 0.0 0.2 227156 38616 ? R 04:59 0:00 /usr/bin/perl -w /usr/local/nagios/libexec/check_vmware_api.pl -H ffxesx06.ellucian.com -f /usr/local/nagiosxi/etc/components/vmware/mal3vi36_ellucian_com_auth.txt -l RUNTIME
nagios 31766 0.0 0.0 182216 11984 ? R 04:59 0:00 /usr/bin/perl -w /usr/local/nagios/libexec/check_vmware_api.pl -H mal4vi65.ellucian.com -f /usr/local/nagiosxi/etc/components/vmware/mal3vi36_ellucian_com_auth.txt -l CPU
sunilka 31770 0.0 0.0 112684 1004 pts/0 S+ 04:59 0:00 grep --color=auto vmware
nagios 31676 0.0 0.0 116512 720 ? S 04:58 0:00 /usr/local/nagios/libexec/check_by_ssh -E 1 -t 90 -l vi-admin -H 149.24.38.141 -C ~/box293_check_vmware.pl --timeout 90 --server malvc1.corp.sct.com --check Datastore_Usage --name "DEV_ise_Pp1_008" --reporting_si "Disk_Size:GB" "--warning" "datastore_free:8" "" ""
nagios 31677 0.0 0.0 79484 4308 ? S 04:58 0:00 /bin/ssh -l vi-admin 149.24.38.141 ~/box293_check_vmware.pl --timeout 90 --server malvc1.corp.sct.com --check Datastore_Usage --name "DEV_ise_Pp1_008" --reporting_si "Disk_Size:GB" "--warning" "datastore_free:8" "" ""
nagios 31705 56.0 0.2 230300 41528 ? R 04:58 0:00 /usr/bin/perl -w /usr/local/nagios/libexec/check_vmware_api.pl -H mal4vi123.ellucian.com -f /usr/local/nagiosxi/etc/components/vmware/mal3vi36_ellucian_com_auth.txt -l NET
nagios 31711 68.0 0.2 230256 41528 ? R 04:58 0:00 /usr/bin/perl -w /usr/local/nagios/libexec/check_vmware_api.pl -H malvi6.ellucian.com -f /usr/local/nagiosxi/etc/components/vmware/mal3vi36_ellucian_com_auth.txt -l NET
nagios 31724 0.0 0.2 227156 38616 ? R 04:59 0:00 /usr/bin/perl -w /usr/local/nagios/libexec/check_vmware_api.pl -H ffxesx06.ellucian.com -f /usr/local/nagiosxi/etc/components/vmware/mal3vi36_ellucian_com_auth.txt -l RUNTIME
nagios 31766 0.0 0.0 182216 11984 ? R 04:59 0:00 /usr/bin/perl -w /usr/local/nagios/libexec/check_vmware_api.pl -H mal4vi65.ellucian.com -f /usr/local/nagiosxi/etc/components/vmware/mal3vi36_ellucian_com_auth.txt -l CPU
sunilka 31770 0.0 0.0 112684 1004 pts/0 S+ 04:59 0:00 grep --color=auto vmware
You do not have the required permissions to view the files attached to this post.
Re: Load average is high on the Nagios server
Try running some of these directly on the command line - do they take a long time to return or timeout?
For example:
For example:
Code: Select all
/usr/bin/perl -w /usr/local/nagios/libexec/check_vmware_api.pl -H mal4vi65.ellucian.com -f /usr/local/nagiosxi/etc/components/vmware/mal3vi36_ellucian_com_auth.txt -l CPU -vAs of May 25th, 2018, all communications with Nagios Enterprises and its employees are covered under our new Privacy Policy.
-
IT-OPS-SYS
- Posts: 184
- Joined: Sun Jan 07, 2018 12:56 pm
Re: Load average is high on the Nagios server
first command says:
root@cvrmnagiosxi001 ~]# /usr/bin/perl -w /usr/local/nagios/libexec/check_vmware_api.pl -H mal4vi65.ellucian.com -f
Option f requires an argument
Usage: check_vmware_api.pl -D <data_center> | -H <host_name> [ -C <cluster_name> ] [ -N <vm_name> ]
-u <user> -p <pass> | -f <authfile>
-l <command> [ -s <subcommand> ] [ -T <timeshift> ] [ -i <interval> ]
[ -x <black_list> ] [ -o <additional_options> ]
[ -t <timeout> ] [ -w <warn_range> ] [ -c <crit_range> ]
[ -V ] [ -h ]
=====================================================
2nd command:
root@cvrmnagiosxi001 ~]# /usr/local/nagiosxi/etc/components/vmware/mal3vi36_ellucian_com_auth.txt -l CPU -v
-bash: /usr/local/nagiosxi/etc/components/vmware/mal3vi36_ellucian_com_auth.txt: Permission denied
[root@cvrmnagiosxi001 ~]#
root@cvrmnagiosxi001 ~]# /usr/bin/perl -w /usr/local/nagios/libexec/check_vmware_api.pl -H mal4vi65.ellucian.com -f
Option f requires an argument
Usage: check_vmware_api.pl -D <data_center> | -H <host_name> [ -C <cluster_name> ] [ -N <vm_name> ]
-u <user> -p <pass> | -f <authfile>
-l <command> [ -s <subcommand> ] [ -T <timeshift> ] [ -i <interval> ]
[ -x <black_list> ] [ -o <additional_options> ]
[ -t <timeout> ] [ -w <warn_range> ] [ -c <crit_range> ]
[ -V ] [ -h ]
=====================================================
2nd command:
root@cvrmnagiosxi001 ~]# /usr/local/nagiosxi/etc/components/vmware/mal3vi36_ellucian_com_auth.txt -l CPU -v
-bash: /usr/local/nagiosxi/etc/components/vmware/mal3vi36_ellucian_com_auth.txt: Permission denied
[root@cvrmnagiosxi001 ~]#
Re: Load average is high on the Nagios server
This is one command:
Code: Select all
/usr/bin/perl -w /usr/local/nagios/libexec/check_vmware_api.pl -H mal4vi65.ellucian.com -f /usr/local/nagiosxi/etc/components/vmware/mal3vi36_ellucian_com_auth.txt -l CPU -vAs of May 25th, 2018, all communications with Nagios Enterprises and its employees are covered under our new Privacy Policy.
-
IT-OPS-SYS
- Posts: 184
- Joined: Sun Jan 07, 2018 12:56 pm
Re: Load average is high on the Nagios server
out is as follows:
[root@cvrmnagiosxi001 ~]# /usr/bin/perl -w /usr/local/nagios/libexec/check_vmware_api.pl -H mal4vi65.ellucian.com -f /usr/local/nagiosxi/etc/components/vmware/mal3vi36_ellucian_com_auth.txt -l CPU -v
CHECK_VMWARE_API.PL OK - cpu usage=6232.00 MHz (26.03%) | cpu_usagemhz=6232.00;; cpu_usage=26.03%;;
[root@cvrmnagiosxi001 ~]# /usr/bin/perl -w /usr/local/nagios/libexec/check_vmware_api.pl -H mal4vi65.ellucian.com -f /usr/local/nagiosxi/etc/components/vmware/mal3vi36_ellucian_com_auth.txt -l CPU -v
CHECK_VMWARE_API.PL OK - cpu usage=6232.00 MHz (26.03%) | cpu_usagemhz=6232.00;; cpu_usage=26.03%;;
Re: Load average is high on the Nagios server
One thing about the top command, it only shows a split second in time of the processes, not an average.
So the output is a bit misleading, those checks could of finished running just after the data is displayed.
I would take a look at the mysqld daemon and the aws application that in the first screen capture.
I would guess those are a longer sustained load in the server.
If you can post a System Profile fron the Nagios server?
To get your system profile. Login to the Nagios XI GUI using a web browser.
Click the "Admin" > "System Profile" Menu
Click the "Download Profile" button
Save the profile.zip file and upload it to the forum post.
Also, run the following commands as root and post the output here.
So the output is a bit misleading, those checks could of finished running just after the data is displayed.
I would take a look at the mysqld daemon and the aws application that in the first screen capture.
I would guess those are a longer sustained load in the server.
If you can post a System Profile fron the Nagios server?
To get your system profile. Login to the Nagios XI GUI using a web browser.
Click the "Admin" > "System Profile" Menu
Click the "Download Profile" button
Save the profile.zip file and upload it to the forum post.
Also, run the following commands as root and post the output here.
Code: Select all
echo "SELECT table_schema as 'Database', table_name AS 'Table', round(((data_length + index_length) / 1024 / 1024), 2) 'Size in MB' FROM information_schema.TABLES ORDER BY (data_length + index_length) DESC;" |mysql -t -u root -pnagiosxi
mysql -u root -pnagiosxi -e "show global status like '%used_connections%'; show variables like 'max_connections';"Be sure to check out our Knowledgebase for helpful articles and solutions!
-
IT-OPS-SYS
- Posts: 184
- Joined: Sun Jan 07, 2018 12:56 pm
Re: Load average is high on the Nagios server
[root@cvrmnagiosxi001 ~]# mysql -u root -pnagiosxi -e "show global status like '%used_connections%'; show variables like 'max_connections';"
=========================================================================
[root@cvrmnagiosxi001 ~]# echo "SELECT table_schema as 'Database', table_name AS 'Table', round(((data_length + index_length) / 1024 / 1024), 2) 'Size in MB' FROM information_schema.TABLES ORDER BY (data_length + index_length) DESC;" |mysql -t -u root -pnagiosxi
Code: Select all
+----------------------+-------+
| Variable_name | Value |
+----------------------+-------+
| Max_used_connections | 136 |
+----------------------+-------+
+-----------------+-------+
| Variable_name | Value |
+-----------------+-------+
| max_connections | 151 |[root@cvrmnagiosxi001 ~]# echo "SELECT table_schema as 'Database', table_name AS 'Table', round(((data_length + index_length) / 1024 / 1024), 2) 'Size in MB' FROM information_schema.TABLES ORDER BY (data_length + index_length) DESC;" |mysql -t -u root -pnagiosxi
Code: Select all
+--------------------+----------------------------------------------+------------+
| Database | Table | Size in MB |
+--------------------+----------------------------------------------+------------+
| nagios | nagios_commenthistory | 1662.39 |
| nagios | nagios_logentries | 411.95 |
| nagios | nagios_statehistory | 285.11 |
| nagios | nagios_notifications | 103.26 |
| nagios | nagios_downtimehistory | 57.31 |
| nagios | nagios_servicestatus | 5.86 |
| nagios | nagios_objects | 5.10 |
| nagios | nagios_flappinghistory | 4.98 |
| nagios | nagios_contactnotifications | 3.78 |
| nagios | nagios_contactnotificationmethods | 3.58 |
| nagios | nagios_services | 2.49 |
| nagiosxi | xi_meta | 1.84 |
| nagiosxi | xi_usermeta | 1.53 |
| nagiosxi | xi_eventqueue | 1.08 |
| nagiosxi | xi_auditlog | 0.78 |
| nagios | nagios_conninfo | 0.69 |
| nagios | nagios_hoststatus | 0.68 |
| nagios | nagios_processevents | 0.62 |
| nagios | nagios_service_contactgroups | 0.51 |
| nagios | nagios_customvariablestatus | 0.46 |
| mysql | help_topic | 0.45 |
| nagios | nagios_customvariables | 0.44 |
| nagios | nagios_hosts | 0.30 |
| nagiosql | tbl_host | 0.21 |
| nagios | nagios_servicegroup_members | 0.17 |
| nagios | nagios_acknowledgements | 0.16 |
| nagios | nagios_hostgroup_members | 0.15 |
| nagiosql | tbl_service | 0.15 |
| nagiosql | tbl_info | 0.13 |
| mysql | help_keyword | 0.10 |
| nagiosxi | xi_events | 0.09 |
| nagiosql | tbl_permission | 0.08 |
| nagiosql | tbl_variabledefinition | 0.07 |
| nagios | nagios_host_contactgroups | 0.06 |
| nagiosql | tbl_command | 0.05 |
| nagiosql | tbl_lnkHostToHosttemplate | 0.05 |
| nagios | nagios_externalcommands | 0.04 |
| nagiosql | tbl_lnkServiceToHost | 0.04 |
| nagios | nagios_systemcommands | 0.04 |
| nagios | nagios_commands | 0.04 |
| nagiosxi | xi_options | 0.04 |
| nagiosql | tbl_lnkHostToContactgroup | 0.03 |
| nagiosxi | xi_cmp_trapdata_log | 0.03 |
| nagiosxi | xi_cmp_trapdata | 0.03 |
| nagiosxi | xi_auth_tokens | 0.03 |
| nagiosxi | xi_sessions | 0.03 |
| nagios | nagios_contact_notificationcommands | 0.03 |
| mysql | help_relation | 0.03 |
| nagios | nagios_service_contacts | 0.03 |
| nagiosql | tbl_lnkHostgroupToHost | 0.02 |
| nagios | nagios_timeperiod_timeranges | 0.02 |
| nagiosql | tbl_lnkServiceToServicetemplate | 0.02 |
| nagiosql | tbl_servicetemplate | 0.02 |
| nagiosql | tbl_timedefinition | 0.02 |
| nagiosxi | xi_users | 0.02 |
| nagios | nagios_eventhandlers | 0.02 |
| nagiosql | tbl_lnkHostToVariabledefinition | 0.02 |
| nagiosxi | xi_incidents | 0.02 |
| nagiosql | tbl_permission_inactive | 0.02 |
| nagiosql | tbl_lnkServiceToVariabledefinition | 0.02 |
| nagiosql | tbl_hosttemplate | 0.02 |
| nagiosql | tbl_hostgroup | 0.01 |
| nagiosql | tbl_contact | 0.01 |
| nagiosql | tbl_timeperiod | 0.01 |
| nagios | nagios_comments | 0.01 |
| nagios | nagios_configfilevariables | 0.01 |
| nagiosql | tbl_contactgroup | 0.01 |
| nagiosql | tbl_domain | 0.01 |
| nagiosql | tbl_contacttemplate | 0.01 |
| nagiosql | tbl_user | 0.01 |
| nagiosql | tbl_servicedependency | 0.01 |
| nagiosql | tbl_servicegroup | 0.01 |
| nagios | nagios_servicedependencies | 0.01 |
| nagiosql | tbl_lnkServicedependencyToService_DS | 0.01 |
| information_schema | ROUTINES | 0.01 |
| information_schema | EVENTS | 0.01 |
| information_schema | PROCESSLIST | 0.01 |
| information_schema | VIEWS | 0.01 |
| information_schema | PLUGINS | 0.01 |
| information_schema | COLUMNS | 0.01 |
| information_schema | PARTITIONS | 0.01 |
| information_schema | PARAMETERS | 0.01 |
| information_schema | TRIGGERS | 0.01 |
| nagiosxi | xi_sysstat | 0.01 |
| nagios | nagios_contacts | 0.01 |
| mysql | db | 0.01 |
| nagios | nagios_hostgroups | 0.01 |
| nagiosql | tbl_lnkServiceToContactgroup | 0.01 |
| mysql | proxies_priv | 0.01 |
| nagios | nagios_scheduleddowntime | 0.01 |
| nagios | nagios_timeperiods | 0.01 |
| nagiosql | tbl_lnkServicetemplateToServicetemplate | 0.01 |
| nagios | nagios_contactstatus | 0.01 |
| nagios | nagios_configfiles | 0.00 |
| nagiosql | tbl_lnkServiceToHostgroup | 0.00 |
| nagiosql | tbl_lnkHostToHostgroup | 0.00 |
| mysql | proc | 0.00 |
| mysql | help_category | 0.00 |
| nagiosql | tbl_serviceescalation | 0.00 |
| mysql | tables_priv | 0.00 |
| nagiosql | tbl_hostescalation | 0.00 |
| nagiosql | tbl_hostdependency | 0.00 |
| mysql | procs_priv | 0.00 |
| mysql | columns_priv | 0.00 |
| nagios | nagios_contactgroup_members | 0.00 |
| nagios | nagios_runtimevariables | 0.00 |
| nagios | nagios_contactgroups | 0.00 |
| nagiosql | tbl_submenu | 0.00 |
| nagios | nagios_host_contacts | 0.00 |
| nagiosql | tbl_settings | 0.00 |
| nagiosql | tbl_session | 0.00 |
| nagios | nagios_servicegroups | 0.00 |
| nagios | nagios_programstatus | 0.00 |
| nagios | nagios_host_parenthosts | 0.00 |
| nagiosql | tbl_lnkHosttemplateToHosttemplate | 0.00 |
| mysql | user | 0.00 |
| nagiosxi | xi_commands | 0.00 |
| nagiosql | tbl_lnkContactToContacttemplate | 0.00 |
| nagiosql | tbl_lnkServiceToContact | 0.00 |
| nagiosql | tbl_lnkHostToContact | 0.00 |
| nagiosql | tbl_session_locks | 0.00 |
| nagiosql | tbl_lnkHostgroupToHostgroup | 0.00 |
| nagiosql | tbl_lnkServiceToServicegroup | 0.00 |
| nagiosql | tbl_mainmenu | 0.00 |
| nagiosql | tbl_lnkContactgroupToContact | 0.00 |
| nagiosql | tbl_logbook | 0.00 |
| nagiosql | tbl_lnkContactToCommandService | 0.00 |
| nagiosql | tbl_lnkContactToCommandHost | 0.00 |
| nagiosql | tbl_lnkHosttemplateToVariabledefinition | 0.00 |
| nagiosql | tbl_lnkHosttemplateToContactgroup | 0.00 |
| nagiosql | tbl_lnkHostToHost | 0.00 |
| nagiosql | tbl_lnkServicedependencyToHost_H | 0.00 |
| nagiosql | tbl_lnkServicedependencyToService_S | 0.00 |
| nagiosql | tbl_lnkServicegroupToService | 0.00 |
| nagiosql | tbl_lnkHosttemplateToHostgroup | 0.00 |
| nagiosql | tbl_lnkContacttemplateToCommandService | 0.00 |
| nagiosql | tbl_lnkContacttemplateToCommandHost | 0.00 |
| nagios | nagios_instances | 0.00 |
| nagiosql | tbl_lnkServicetemplateToHostgroup | 0.00 |
| nagiosql | tbl_lnkServicetemplateToHost | 0.00 |
| nagiosql | tbl_lnkContacttemplateToContactgroup | 0.00 |
| mysql | host | 0.00 |
| mysql | event | 0.00 |
| nagios | nagios_dbversion | 0.00 |
| nagiosql | tbl_lnkHostdependencyToHostgroup_H | 0.00 |
| mysql | ndb_binlog_index | 0.00 |
| nagiosql | tbl_lnkServicegroupToServicegroup | 0.00 |
| nagiosql | tbl_lnkServiceescalationToService | 0.00 |
| nagiosql | tbl_lnkHostdependencyToHostgroup_DH | 0.00 |
| nagiosql | tbl_serviceextinfo | 0.00 |
| nagiosql | tbl_lnkServiceescalationToHostgroup | 0.00 |
| nagiosql | tbl_lnkHostdependencyToHost_H | 0.00 |
| nagiosql | tbl_lnkServiceescalationToHost | 0.00 |
| nagiosql | tbl_lnkHostdependencyToHost_DH | 0.00 |
| nagios | nagios_contact_addresses | 0.00 |
| nagiosql | tbl_lnkServiceescalationToContactgroup | 0.00 |
| mysql | time_zone_transition | 0.00 |
| nagiosql | tbl_lnkServiceescalationToContact | 0.00 |
| nagiosql | tbl_hostextinfo | 0.00 |
| nagios | nagios_timedevents | 0.00 |
| mysql | time_zone_name | 0.00 |
| nagios | nagios_timedeventqueue | 0.00 |
| mysql | time_zone_leap_second | 0.00 |
| nagiosql | tbl_lnkHosttemplateToHost | 0.00 |
| mysql | time_zone | 0.00 |
| nagiosql | tbl_lnkServicedependencyToHostgroup_H | 0.00 |
| nagiosql | tbl_lnkTimeperiodToTimeperiod | 0.00 |
| nagiosql | tbl_lnkServicedependencyToHostgroup_DH | 0.00 |
| nagiosql | tbl_lnkServicetemplateToVariabledefinition | 0.00 |
| nagios | nagios_serviceescalations | 0.00 |
| nagiosql | tbl_lnkHosttemplateToContact | 0.00 |
| mysql | func | 0.00 |
| nagiosql | tbl_lnkContacttemplateToVariabledefinition | 0.00 |
| nagios | nagios_serviceescalation_contacts | 0.00 |
| nagiosql | tbl_lnkContactgroupToContactgroup | 0.00 |
| mysql | servers | 0.00 |
| nagiosql | tbl_lnkServicedependencyToHost_DH | 0.00 |
| nagiosql | tbl_lnkServicetemplateToServicegroup | 0.00 |
| nagiosql | tbl_lnkContacttemplateToContacttemplate | 0.00 |
| nagios | nagios_serviceescalation_contactgroups | 0.00 |
| nagios | nagios_hostchecks | 0.00 |
| nagios | nagios_hostescalations | 0.00 |
| nagios | nagios_servicechecks | 0.00 |
| nagiosql | tbl_lnkHostescalationToHostgroup | 0.00 |
| nagios | nagios_hostescalation_contacts | 0.00 |
| nagiosql | tbl_lnkContactToVariabledefinition | 0.00 |
| mysql | time_zone_transition_type | 0.00 |
| nagios | nagios_service_parentservices | 0.00 |
| nagiosql | tbl_lnkHostescalationToContactgroup | 0.00 |
| nagiosql | tbl_lnkHostescalationToHost | 0.00 |
| nagios | nagios_hostescalation_contactgroups | 0.00 |
| nagiosql | tbl_lnkServicetemplateToContactgroup | 0.00 |
| nagiosql | tbl_lnkHostescalationToContact | 0.00 |
| nagios | nagios_hostdependencies | 0.00 |
| nagiosql | tbl_lnkContactToContactgroup | 0.00 |
| mysql | plugin | 0.00 |
| nagiosql | tbl_lnkServicetemplateToContact | 0.00 |
| performance_schema | file_summary_by_instance | 0.00 |
| information_schema | INNODB_BUFFER_PAGE_LRU | 0.00 |
| information_schema | TABLES | 0.00 |
| information_schema | INNODB_SYS_FIELDS | 0.00 |
| performance_schema | file_summary_by_event_name | 0.00 |
| information_schema | KEY_COLUMN_USAGE | 0.00 |
| information_schema | INNODB_SYS_FOREIGN_COLS | 0.00 |
| information_schema | STATISTICS | 0.00 |
| information_schema | INNODB_SYS_TABLES | 0.00 |
| information_schema | KEY_CACHES | 0.00 |
| information_schema | INNODB_TABLE_STATS | 0.00 |
| information_schema | SESSION_VARIABLES | 0.00 |
| information_schema | INNODB_BUFFER_POOL_PAGES_BLOB | 0.00 |
| information_schema | INNODB_INDEX_STATS | 0.00 |
| performance_schema | file_instances | 0.00 |
| information_schema | XTRADB_ADMIN_COMMAND | 0.00 |
| information_schema | SESSION_STATUS | 0.00 |
| information_schema | INNODB_LOCKS | 0.00 |
| information_schema | INNODB_LOCK_WAITS | 0.00 |
| performance_schema | events_waits_summary_global_by_event_name | 0.00 |
| information_schema | INDEX_STATISTICS | 0.00 |
| information_schema | SCHEMA_PRIVILEGES | 0.00 |
| information_schema | INNODB_BUFFER_POOL_PAGES_INDEX | 0.00 |
| information_schema | INNODB_SYS_TABLESTATS | 0.00 |
| performance_schema | events_waits_summary_by_thread_by_event_name | 0.00 |
| information_schema | GLOBAL_VARIABLES | 0.00 |
| information_schema | SCHEMATA | 0.00 |
| information_schema | INNODB_TRX | 0.00 |
| information_schema | INNODB_CMPMEM | 0.00 |
| performance_schema | events_waits_summary_by_instance | 0.00 |
| information_schema | GLOBAL_STATUS | 0.00 |
| information_schema | INNODB_BUFFER_POOL_PAGES | 0.00 |
| information_schema | INNODB_UNDO_LOGS | 0.00 |
| performance_schema | events_waits_history_long | 0.00 |
| information_schema | FILES | 0.00 |
| information_schema | INNODB_RSEG | 0.00 |
| performance_schema | events_waits_history | 0.00 |
| information_schema | REFERENTIAL_CONSTRAINTS | 0.00 |
| information_schema | INNODB_CHANGED_PAGES | 0.00 |
| information_schema | INNODB_CMPMEM_RESET | 0.00 |
| performance_schema | events_waits_current | 0.00 |
| information_schema | ENGINES | 0.00 |
| information_schema | PROFILING | 0.00 |
| information_schema | INNODB_CMP_RESET | 0.00 |
| information_schema | COLUMN_PRIVILEGES | 0.00 |
| mysql | general_log | 0.00 |
| information_schema | INNODB_CMP | 0.00 |
| performance_schema | cond_instances | 0.00 |
| performance_schema | threads | 0.00 |
| mysql | slow_log | 0.00 |
| information_schema | USER_STATISTICS | 0.00 |
| performance_schema | setup_timers | 0.00 |
| information_schema | USER_PRIVILEGES | 0.00 |
| information_schema | COLLATION_CHARACTER_SET_APPLICABILITY | 0.00 |
| information_schema | INNODB_SYS_INDEXES | 0.00 |
| information_schema | COLLATIONS | 0.00 |
| performance_schema | setup_consumers | 0.00 |
| performance_schema | setup_instruments | 0.00 |
| information_schema | INNODB_SYS_FOREIGN | 0.00 |
| information_schema | TABLE_STATISTICS | 0.00 |
| information_schema | CLIENT_STATISTICS | 0.00 |
| performance_schema | rwlock_instances | 0.00 |
| information_schema | INNODB_SYS_STATS | 0.00 |
| information_schema | TABLE_PRIVILEGES | 0.00 |
| information_schema | CHARACTER_SETS | 0.00 |
| performance_schema | performance_timers | 0.00 |
| information_schema | INNODB_BUFFER_PAGE | 0.00 |
| information_schema | INNODB_SYS_COLUMNS | 0.00 |
| information_schema | TABLE_CONSTRAINTS | 0.00 |
| performance_schema | mutex_instances | 0.00 |
| information_schema | INNODB_BUFFER_POOL_STATS | 0.00 |
| information_schema | TABLESPACES | 0.00 |
+--------------------+----------------------------------------------+------------+You do not have the required permissions to view the files attached to this post.
Last edited by tgriep on Wed Jul 31, 2019 12:08 pm, edited 1 time in total.
Reason: Added Code Wraps around large output.
Reason: Added Code Wraps around large output.
Re: Load average is high on the Nagios server
Thanks for the data.
The .tar.gz file only has the config files for nagios, the rest of the profile has the logs and other information we need to view.
Any chance you can upload the full system profile or PM it to me?
I would increase the max_connections limit for the MYSQL database by following this KB article.
https://support.nagios.com/kb/article/n ... html#focus
Do you have any details on the aws process that is running on the system?
Are there any MYSQL errors in the following files if they exist on the server?
The .tar.gz file only has the config files for nagios, the rest of the profile has the logs and other information we need to view.
Any chance you can upload the full system profile or PM it to me?
I would increase the max_connections limit for the MYSQL database by following this KB article.
https://support.nagios.com/kb/article/n ... html#focus
Do you have any details on the aws process that is running on the system?
Are there any MYSQL errors in the following files if they exist on the server?
Code: Select all
/var/log/messages
/var/log/mysqld.log
/var/log/mariadb/mariadb.log
/var/log/httpd/error_log
/var/log/httpd/ssl_error_logBe sure to check out our Knowledgebase for helpful articles and solutions!