Graph generating very slowely

[progressive.nagiosXI]

Hi team ,

We are facing this issue quite frequently after some time that Graph getting updates on very slowly we have also checked

ls /usr/local/nagios/var/spool/perfdata/ | wc -l and output is 688

also we have tried all possible changes based on your KB article please help here.

[npolovenko]

Hello, @progressive.nagiosXI. Could you send in your Nagios XI System Profile so I can review it?
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 send it to me in a personal message.
After you send me the profile please post something in this thread to bring it back up in the support queue.

[progressive.nagiosXI]

please check

[npolovenko]

@progressive.nagiosXI, Unfortunately, the profile didn't get attached. Did you click on the "Add the file" button after selecting the file?

[npolovenko]

@progressive.nagiosXI, Recieved the profile and shared it with the support team.

In the perfdata log I see that the server system load reaches up to 70, while your NPCD threshold is set to 15. Meaning if the system load goes above 15 -> pause processing the perfdata. It would make sense to increase the load_threshold even further to at least 40.

I highly suggest implementing a ramdisk. You can easily set it up with a few commands and it almost always incrases the perfdata processing speed.
https://assets.nagios.com/downloads/nag ... giosXI.pdf

Your system is complaining that the max mysql connection limit is reached. Consider increasing the limit in the /etc/my.cnf and then restarting the database with:

service mysqld restart

Also, show me the output of:

ulimit -a

Finally, I saw that your disk was maxed out in the beginning of December and that caused some DB corruption:

mysqld: Disk is full writing '/var/tmp/STEFSIGl'

Please run through these commands:

mysqlcheck -r -f -uroot -pnagiosxi --all-databases
systemctl stop crond
systemctl stop npcd
systemctl stop nagios
systemctl stop ndo2db
pkill -9 -u nagios
for i in $(ipcs -q | grep nagios |awk '{print $2}'); do ipcrm -q $i; done
rm -rf /usr/local/nagiosxi/var/dbmaint.lock
rm -rf /usr/local/nagiosxi/var/event_handler.lock
rm -rf /usr/local/nagiosxi/scripts/reconfigure_nagios.lock
systemctl restart mariadb
systemctl start ndo2db
systemctl start nagios
systemctl start npcd
systemctl start crond