Page 1 of 1
Performance Issues with XI
Posted: Thu Dec 10, 2020 8:07 am
by pbarnett865
CentOS Linux release 7.9.2009 (Core)
64bit
VMWare deployed from template provided by Nagios.
Our Nagios installation has come to a grinding halt. Any type of service or host update take forever to apply and typically they end up inactivated and never end up getting checked.
Re: Performance Issues with XI
Posted: Thu Dec 10, 2020 5:38 pm
by dchurch
Can you please PM me a system profile so that we can diagnose further?
Re: Performance Issues with XI
Posted: Mon Dec 14, 2020 5:26 pm
by dchurch
Just checking in since we haven't heard from you in a while. Were you able to solve the problem?
Re: Performance Issues with XI
Posted: Mon Feb 01, 2021 11:37 am
by dchurch
Profile received. Looking into it now.
Re: Performance Issues with XI
Posted: Mon Feb 01, 2021 11:44 am
by dchurch
I'm noticing there's a database error, possibly a crashed table.
If you run the database repair script, it may clear things up. Run the following as root from the terminal.
Code: Select all
/usr/local/nagiosxi/scripts/repair_databases.sh
See here for complete instructions:
run the database repairLet me know if that is successful.
Re: Performance Issues with XI
Posted: Tue Feb 02, 2021 10:51 am
by pbarnett865
I have ran the database repair script multiple times and it doesn't seem to make a difference.
Re: Performance Issues with XI
Posted: Tue Feb 02, 2021 6:13 pm
by dchurch
Looks like your mysql process is running rampant, pegged at 100% CPU for the past 2 hours. Monitoring 2460 individual hosts may be the issue.
Here is a document on Maximizing Performance in Nagios XI:
https://assets.nagios.com/downloads/nag ... ios-XI.pdf
And on page 9 of the Doc there is a link to another doc titled Offloading MySQL To A Remote Server:
https://assets.nagios.com/downloads/nag ... Server.pdf