Hi,
NagiosXI server CPU consumption climbed from 20% to 90% since 26/09/2020 (see the graph attached)
I applied the attached procedure (given by the nagiosxi support on a previous CPU problem) = no success
Restart server = no success
Could you please help me ?
Frederic
Nagios XI server CPU increasing
-
Frédéric GRANAT
- Posts: 445
- Joined: Mon Nov 19, 2012 11:36 am
Nagios XI server CPU increasing
You do not have the required permissions to view the files attached to this post.
-
benjaminsmith
- Posts: 5324
- Joined: Wed Aug 22, 2018 4:39 pm
- Location: saint paul
Re: Nagios XI server CPU increasing
Hi,
Do you recall making any changes since that time to the server? If the system were to have a corrupted database, that would certainly cause the CPU to spike. Let's go ahead and run the database repair script, and let me know if the CPU load decreases.
Additionally, please PM the system profile and we'll review the logs as well. Thanks, Benjamin
To send us 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 share in a private message or upload it to the post/ticket, and then reply to this post to bring it up in the queue.
Do you recall making any changes since that time to the server? If the system were to have a corrupted database, that would certainly cause the CPU to spike. Let's go ahead and run the database repair script, and let me know if the CPU load decreases.
Code: Select all
/usr/local/nagiosxi/scripts/repair_databases.sh
To send us 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 share in a private message or upload it to the post/ticket, and then reply to this post to bring it up in the queue.
As of May 25th, 2018, all communications with Nagios Enterprises and its employees are covered under our new Privacy Policy.
Be sure to check out our Knowledgebase for helpful articles and solutions!
Be sure to check out our Knowledgebase for helpful articles and solutions!
-
Frédéric GRANAT
- Posts: 445
- Joined: Mon Nov 19, 2012 11:36 am
Re: Nagios XI server CPU increasing
Hi,
I ran repair_databases a few days ago because there was an error in NAgiosXI and it asked me to do it.
I ran it one more time today.
I don't remember having make changes recently.
Please find attached my profile
Moderator's Note: The profile has been shared with the support team but has been removed from the public forum.
I ran repair_databases a few days ago because there was an error in NAgiosXI and it asked me to do it.
I ran it one more time today.
I don't remember having make changes recently.
Please find attached my profile
Moderator's Note: The profile has been shared with the support team but has been removed from the public forum.
Last edited by Frédéric GRANAT on Fri Oct 09, 2020 8:43 am, edited 1 time in total.
-
benjaminsmith
- Posts: 5324
- Joined: Wed Aug 22, 2018 4:39 pm
- Location: saint paul
Re: Nagios XI server CPU increasing
Hi,
Since running the repair did you notice any improvement? The load stats on the top command look pretty good.
However, I did see some connection issues in the system logs.
I think you may have a DNS issue here.
Talk to your network admin or try setting the Program URL to the IP address instead of using the FQDN. Go to Admin > System Settings > General Program Settings > Program URL to change this.
Alternatively, you could try to add the FQDN to your /etc/hosts file and set the server name in the Apache configuration file. See the links below.
Let me know if that resolves the issue.
Benjamin
Reference:
https://stackoverflow.com/questions/585 ... omain-name
https://hostingcanada.org/how-to-add-a- ... osts-file/
Since running the repair did you notice any improvement? The load stats on the top command look pretty good.
Code: Select all
top - 08:05:44 up 6 days, 23:44, 1 user, load average: 1.03, 1.27, 1.14
Tasks: 237 total, 5 running, 232 sleeping, 0 stopped, 0 zombie
Code: Select all
Oct 8 08:03:33 nagiosxi ndo2db: Error: Could not connect to MySQL database: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Oct 8 08:03:33 nagiosxi ndo2db: Error: Could not connect to MySQL database: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Oct 8 08:03:37 nagiosxi ndo2db: Trimming timedevents.
Oct 8 08:03:37 nagiosxi ndo2db: Trimming systemcommands.
Oct 8 08:03:37 nagiosxi ndo2db: Trimming servicechecks.
Code: Select all
httpd: Could not reliably determine the server's fully qualified domain name, using nagiosxi.cg.ahp for ServerName
Alternatively, you could try to add the FQDN to your /etc/hosts file and set the server name in the Apache configuration file. See the links below.
Let me know if that resolves the issue.
Benjamin
Reference:
https://stackoverflow.com/questions/585 ... omain-name
https://hostingcanada.org/how-to-add-a- ... osts-file/
As of May 25th, 2018, all communications with Nagios Enterprises and its employees are covered under our new Privacy Policy.
Be sure to check out our Knowledgebase for helpful articles and solutions!
Be sure to check out our Knowledgebase for helpful articles and solutions!
-
Frédéric GRANAT
- Posts: 445
- Joined: Mon Nov 19, 2012 11:36 am
Re: Nagios XI server CPU increasing
Hi,
"try setting the Program URL to the IP address instead of using the FQDN"
=> I don't understand how that setting could suddenly impact the CPU whereas there was no problem from now.
Anyway I made the change : changing dns to ip address in Program URL:, but that doesn't solve my problem
I would like to see the configuration changes I made on a particular date : how can I do that ?
"try setting the Program URL to the IP address instead of using the FQDN"
=> I don't understand how that setting could suddenly impact the CPU whereas there was no problem from now.
Anyway I made the change : changing dns to ip address in Program URL:, but that doesn't solve my problem
I would like to see the configuration changes I made on a particular date : how can I do that ?
-
benjaminsmith
- Posts: 5324
- Joined: Wed Aug 22, 2018 4:39 pm
- Location: saint paul
Re: Nagios XI server CPU increasing
HI,
The other item to check here would be the older Postgres database. I noticed most of the highest CPU consuming processes in the top command are from the postmaster. Try running the vacuum command on this database.
And then clear the queues.
Lastly, I'd like to get a look at the size of the database tables. Post the full output to the queries below. Thanks, Benjamin
Postgres
I would start by checking the Audit Log. Go to Admin > System Information > Audit Log.I would like to see the configuration changes I made on a particular date : how can I do that
The other item to check here would be the older Postgres database. I noticed most of the highest CPU consuming processes in the top command are from the postmaster. Try running the vacuum command on this database.
Code: Select all
echo "vacuum;vacuum analyze;vacuum full;"|psql nagiosxi postgre
Code: Select all
echo "truncate table xi_events; truncate table xi_meta; truncate table xi_eventqueue;" | psql nagiosxi nagiosxi
Code: Select all
echo "SELECT table_name AS 'Table', round(((data_length + index_length) / 1024 / 1024), 2) 'Size in MB' FROM information_schema.TABLES WHERE table_schema IN ('nagios', 'nagiosql');" | mysql -h 127.0.0.1 -uroot -pnagiosxi --table
Code: Select all
echo "SELECT relname as Table, pg_size_pretty(pg_total_relation_size(relid)) As Size, pg_size_pretty(pg_total_relation_size(relid) - pg_relation_size(relid)) as ExternalSize FROM pg_catalog.pg_statio_user_tables ORDER BY pg_total_relation_size(relid) DESC;" | psql nagiosxi nagiosxi
As of May 25th, 2018, all communications with Nagios Enterprises and its employees are covered under our new Privacy Policy.
Be sure to check out our Knowledgebase for helpful articles and solutions!
Be sure to check out our Knowledgebase for helpful articles and solutions!
-
Frédéric GRANAT
- Posts: 445
- Joined: Mon Nov 19, 2012 11:36 am
Re: Nagios XI server CPU increasing
Hi,
Here it is :
Good news : since I applied the above change this morning, the CPU consumption decreased to a "normal level".
I suggest to wait a week to check if the problem is really resolved
I don't have access to audit log (it requires enterprise edition).I would start by checking the Audit Log. Go to Admin > System Information > Audit Log.
Here it is :
Code: Select all
[root@nagiosxi ~]# echo "vacuum;vacuum analyze;vacuum full;"|psql nagiosxi postgres
VACUUM
VACUUM
VACUUM
You have new mail in /var/spool/mail/root
[root@nagiosxi ~]# echo "truncate table xi_events; truncate table xi_meta; truncate table xi_eventqueue;" | psql nagiosxi nagiosxi
TRUNCATE TABLE
TRUNCATE TABLE
TRUNCATE TABLE
[root@nagiosxi ~]# echo "SELECT table_name AS 'Table', round(((data_length + index_length) / 1024 / 1024), 2) 'Size in MB' FROM information_schema.TABLES WHERE table_schema IN ('nagios', 'nagiosql');" | mysql -h 127.0.0.1 -uroot -pnagiosxi --table
+--------------------------------------------+------------+
| Table | Size in MB |
+--------------------------------------------+------------+
| nagios_acknowledgements | 0.53 |
| nagios_commands | 0.02 |
| nagios_commenthistory | 5.16 |
| nagios_comments | 0.01 |
| nagios_configfiles | 0.00 |
| nagios_configfilevariables | 0.01 |
| nagios_conninfo | 0.30 |
| nagios_contact_addresses | 0.00 |
| nagios_contact_notificationcommands | 0.01 |
| nagios_contactgroup_members | 0.00 |
| nagios_contactgroups | 0.00 |
| nagios_contactnotificationmethods | 35.05 |
| nagios_contactnotifications | 33.22 |
| nagios_contacts | 0.00 |
| nagios_contactstatus | 0.00 |
| nagios_customvariables | 0.02 |
| nagios_customvariablestatus | 0.01 |
| nagios_dbversion | 0.00 |
| nagios_downtimehistory | 0.08 |
| nagios_eventhandlers | 0.01 |
| nagios_externalcommands | 0.00 |
| nagios_flappinghistory | 7.58 |
| nagios_host_contactgroups | 0.02 |
| nagios_host_contacts | 0.00 |
| nagios_host_parenthosts | 0.02 |
| nagios_hostchecks | 0.00 |
| nagios_hostdependencies | 0.00 |
| nagios_hostescalation_contactgroups | 0.00 |
| nagios_hostescalation_contacts | 0.00 |
| nagios_hostescalations | 0.00 |
| nagios_hostgroup_members | 0.05 |
| nagios_hostgroups | 0.00 |
| nagios_hosts | 0.08 |
| nagios_hoststatus | 0.20 |
| nagios_instances | 0.00 |
| nagios_logentries | 248.40 |
| nagios_notifications | 176.70 |
| nagios_objects | 0.57 |
| nagios_processevents | 0.03 |
| nagios_programstatus | 0.00 |
| nagios_runtimevariables | 0.00 |
| nagios_scheduleddowntime | 0.00 |
| nagios_service_contactgroups | 0.04 |
| nagios_service_contacts | 0.00 |
| nagios_service_parentservices | 0.00 |
| nagios_servicechecks | 0.00 |
| nagios_servicedependencies | 0.00 |
| nagios_serviceescalation_contactgroups | 0.00 |
| nagios_serviceescalation_contacts | 0.00 |
| nagios_serviceescalations | 0.00 |
| nagios_servicegroup_members | 0.10 |
| nagios_servicegroups | 0.00 |
| nagios_services | 0.21 |
| nagios_servicestatus | 0.59 |
| nagios_statehistory | 352.53 |
| nagios_systemcommands | 0.04 |
| nagios_timedeventqueue | 0.00 |
| nagios_timedevents | 0.00 |
| nagios_timeperiod_timeranges | 0.01 |
| nagios_timeperiods | 0.00 |
| tbl_command | 0.04 |
| tbl_contact | 0.01 |
| tbl_contactgroup | 0.01 |
| tbl_contacttemplate | 0.01 |
| tbl_domain | 0.01 |
| tbl_host | 0.07 |
| tbl_hostdependency | 0.00 |
| tbl_hostescalation | 0.00 |
| tbl_hostextinfo | 0.00 |
| tbl_hostgroup | 0.01 |
| tbl_hosttemplate | 0.01 |
| tbl_info | 0.13 |
| 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.00 |
| tbl_lnkHostToContactgroup | 0.00 |
| tbl_lnkHostToHost | 0.01 |
| tbl_lnkHostToHostgroup | 0.00 |
| tbl_lnkHostToHosttemplate | 0.01 |
| tbl_lnkHostToVariabledefinition | 0.00 |
| 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.01 |
| 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.00 |
| tbl_lnkServiceToContactgroup | 0.00 |
| tbl_lnkServiceToHost | 0.02 |
| tbl_lnkServiceToHostgroup | 0.00 |
| tbl_lnkServiceToServicegroup | 0.00 |
| tbl_lnkServiceToServicetemplate | 0.03 |
| tbl_lnkServiceToVariabledefinition | 0.00 |
| 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.03 |
| 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.00 |
| tbl_mainmenu | 0.00 |
| tbl_permission | 0.02 |
| tbl_permission_inactive | 0.02 |
| tbl_service | 0.10 |
| tbl_servicedependency | 0.00 |
| tbl_serviceescalation | 0.00 |
| tbl_serviceextinfo | 0.00 |
| tbl_servicegroup | 0.01 |
| tbl_servicetemplate | 0.02 |
| tbl_session | 0.00 |
| tbl_session_locks | 0.00 |
| tbl_settings | 0.00 |
| tbl_submenu | 0.00 |
| tbl_timedefinition | 0.01 |
| tbl_timeperiod | 0.01 |
| tbl_user | 0.01 |
| tbl_variabledefinition | 0.15 |
+--------------------------------------------+------------+
[root@nagiosxi ~]# echo "SELECT relname as Table, pg_size_pretty(pg_total_relation_size(relid)) As Size, pg_size_pretty(pg_total_relation_size(relid) - pg_relation_size(relid)) as ExternalSize FROM pg_catalog.pg_statio_user_tables ORDER BY pg_total_relation_size(relid) DESC;" | psql nagiosxi nagiosxi
table | size | externalsize
---------------------+------------+--------------
xi_auditlog | 592 kB | 520 kB
xi_usermeta | 208 kB | 176 kB
xi_sysstat | 160 kB | 144 kB
xi_auth_tokens | 128 kB | 128 kB
xi_options | 120 kB | 96 kB
xi_commands | 104 kB | 96 kB
xi_users | 80 kB | 72 kB
xi_mibs | 72 kB | 64 kB
xi_sessions | 64 kB | 56 kB
xi_events | 40 kB | 32 kB
xi_cmp_trapdata | 24 kB | 24 kB
xi_cmp_trapdata_log | 16 kB | 16 kB
xi_meta | 16 kB | 8192 bytes
xi_eventqueue | 16 kB | 8192 bytes
xi_incidents | 8192 bytes | 8192 bytes
(15 rows)
login as: root
root@nagiosxi's password:
Last login: Fri Oct 9 16:46:04 2020 from 5004378-d.cg.ahp
[root@nagiosxi ~]# echo "vacuum;vacuum analyze;vacuum full;"|psql nagiosxi postgre
psql: FATAL: role "postgre" does not exist
[root@nagiosxi ~]# echo "vacuum;vacuum analyze;vacuum full;"|psql nagiosxi postgres
VACUUM
VACUUM
VACUUM
You have new mail in /var/spool/mail/root
[root@nagiosxi ~]# echo "truncate table xi_events; truncate table xi_meta; truncate table xi_eventqueue;" | psql nagiosxi nagiosxi
TRUNCATE TABLE
TRUNCATE TABLE
TRUNCATE TABLE
[root@nagiosxi ~]# echo "SELECT table_name AS 'Table', round(((data_length + index_length) / 1024 / 1024), 2) 'Size in MB' FROM information_schema.TABLES WHERE table_schema IN ('nagios', 'nagiosql');" | mysql -h 127.0.0.1 -uroot -pnagiosxi --table
+--------------------------------------------+------------+
| Table | Size in MB |
+--------------------------------------------+------------+
| nagios_acknowledgements | 0.53 |
| nagios_commands | 0.02 |
| nagios_commenthistory | 5.16 |
| nagios_comments | 0.01 |
| nagios_configfiles | 0.00 |
| nagios_configfilevariables | 0.01 |
| nagios_conninfo | 0.30 |
| nagios_contact_addresses | 0.00 |
| nagios_contact_notificationcommands | 0.01 |
| nagios_contactgroup_members | 0.00 |
| nagios_contactgroups | 0.00 |
| nagios_contactnotificationmethods | 35.05 |
| nagios_contactnotifications | 33.22 |
| nagios_contacts | 0.00 |
| nagios_contactstatus | 0.00 |
| nagios_customvariables | 0.02 |
| nagios_customvariablestatus | 0.01 |
| nagios_dbversion | 0.00 |
| nagios_downtimehistory | 0.08 |
| nagios_eventhandlers | 0.01 |
| nagios_externalcommands | 0.00 |
| nagios_flappinghistory | 7.58 |
| nagios_host_contactgroups | 0.02 |
| nagios_host_contacts | 0.00 |
| nagios_host_parenthosts | 0.02 |
| nagios_hostchecks | 0.00 |
| nagios_hostdependencies | 0.00 |
| nagios_hostescalation_contactgroups | 0.00 |
| nagios_hostescalation_contacts | 0.00 |
| nagios_hostescalations | 0.00 |
| nagios_hostgroup_members | 0.05 |
| nagios_hostgroups | 0.00 |
| nagios_hosts | 0.08 |
| nagios_hoststatus | 0.20 |
| nagios_instances | 0.00 |
| nagios_logentries | 248.40 |
| nagios_notifications | 176.70 |
| nagios_objects | 0.57 |
| nagios_processevents | 0.03 |
| nagios_programstatus | 0.00 |
| nagios_runtimevariables | 0.00 |
| nagios_scheduleddowntime | 0.00 |
| nagios_service_contactgroups | 0.04 |
| nagios_service_contacts | 0.00 |
| nagios_service_parentservices | 0.00 |
| nagios_servicechecks | 0.00 |
| nagios_servicedependencies | 0.00 |
| nagios_serviceescalation_contactgroups | 0.00 |
| nagios_serviceescalation_contacts | 0.00 |
| nagios_serviceescalations | 0.00 |
| nagios_servicegroup_members | 0.10 |
| nagios_servicegroups | 0.00 |
| nagios_services | 0.21 |
| nagios_servicestatus | 0.59 |
| nagios_statehistory | 352.53 |
| nagios_systemcommands | 0.04 |
| nagios_timedeventqueue | 0.00 |
| nagios_timedevents | 0.00 |
| nagios_timeperiod_timeranges | 0.01 |
| nagios_timeperiods | 0.00 |
| tbl_command | 0.04 |
| tbl_contact | 0.01 |
| tbl_contactgroup | 0.01 |
| tbl_contacttemplate | 0.01 |
| tbl_domain | 0.01 |
| tbl_host | 0.07 |
| tbl_hostdependency | 0.00 |
| tbl_hostescalation | 0.00 |
| tbl_hostextinfo | 0.00 |
| tbl_hostgroup | 0.01 |
| tbl_hosttemplate | 0.01 |
| tbl_info | 0.13 |
| 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.00 |
| tbl_lnkHostToContactgroup | 0.00 |
| tbl_lnkHostToHost | 0.01 |
| tbl_lnkHostToHostgroup | 0.00 |
| tbl_lnkHostToHosttemplate | 0.01 |
| tbl_lnkHostToVariabledefinition | 0.00 |
| 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.01 |
| 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.00 |
| tbl_lnkServiceToContactgroup | 0.00 |
| tbl_lnkServiceToHost | 0.02 |
| tbl_lnkServiceToHostgroup | 0.00 |
| tbl_lnkServiceToServicegroup | 0.00 |
| tbl_lnkServiceToServicetemplate | 0.03 |
| tbl_lnkServiceToVariabledefinition | 0.00 |
| 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.03 |
| 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.00 |
| tbl_mainmenu | 0.00 |
| tbl_permission | 0.02 |
| tbl_permission_inactive | 0.02 |
| tbl_service | 0.10 |
| tbl_servicedependency | 0.00 |
| tbl_serviceescalation | 0.00 |
| tbl_serviceextinfo | 0.00 |
| tbl_servicegroup | 0.01 |
| tbl_servicetemplate | 0.02 |
| tbl_session | 0.00 |
| tbl_session_locks | 0.00 |
| tbl_settings | 0.00 |
| tbl_submenu | 0.00 |
| tbl_timedefinition | 0.01 |
| tbl_timeperiod | 0.01 |
| tbl_user | 0.01 |
| tbl_variabledefinition | 0.15 |
+--------------------------------------------+------------+
[root@nagiosxi ~]# echo "SELECT relname as Table, pg_size_pretty(pg_total_relation_size(relid)) As Size, pg_size_pretty(pg_total_relation_size(relid) - pg_relation_size(relid)) as ExternalSize FROM pg_catalog.pg_statio_user_tables ORDER BY pg_total_relation_size(relid) DESC;" | psql nagiosxi nagiosxi
table | size | externalsize
---------------------+------------+--------------
xi_auditlog | 592 kB | 520 kB
xi_usermeta | 208 kB | 176 kB
xi_sysstat | 160 kB | 144 kB
xi_auth_tokens | 128 kB | 128 kB
xi_options | 120 kB | 96 kB
xi_commands | 104 kB | 96 kB
xi_users | 80 kB | 72 kB
xi_mibs | 72 kB | 64 kB
xi_sessions | 64 kB | 56 kB
xi_events | 40 kB | 32 kB
xi_cmp_trapdata | 24 kB | 24 kB
xi_cmp_trapdata_log | 16 kB | 16 kB
xi_meta | 16 kB | 8192 bytes
xi_eventqueue | 16 kB | 8192 bytes
xi_incidents | 8192 bytes | 8192 bytes
(15 rows)
I suggest to wait a week to check if the problem is really resolved
Last edited by Frédéric GRANAT on Tue Oct 13, 2020 1:10 am, edited 1 time in total.
-
benjaminsmith
- Posts: 5324
- Joined: Wed Aug 22, 2018 4:39 pm
- Location: saint paul
Re: Nagios XI server CPU increasing
Hi,
Thank you,
Benjamin
Indeed. We'll keep this open and just update us in a week or so.Good news : since I applied the above change this morning, the CPU consumption discreased to a "normal level".
I suggest to wait a week to check if the problem is really resolved
Thank you,
Benjamin
As of May 25th, 2018, all communications with Nagios Enterprises and its employees are covered under our new Privacy Policy.
Be sure to check out our Knowledgebase for helpful articles and solutions!
Be sure to check out our Knowledgebase for helpful articles and solutions!
-
Frédéric GRANAT
- Posts: 445
- Joined: Mon Nov 19, 2012 11:36 am
Re: Nagios XI server CPU increasing
Hi,
CPU stays at a low level since I made the change, so I close the post.
Thanks for your help
Frederic
CPU stays at a low level since I made the change, so I close the post.
Thanks for your help
Frederic
-
scottwilkerson
- DevOps Engineer
- Posts: 19396
- Joined: Tue Nov 15, 2011 3:11 pm
- Location: Nagios Enterprises
- Contact:
Re: Nagios XI server CPU increasing
Great!Frédéric GRANAT wrote:Hi,
CPU stays at a low level since I made the change, so I close the post.
Thanks for your help
Frederic
Locking thread