Page 1 of 1

service status detail page take so long to load

Posted: Thu Jan 21, 2016 9:25 am
by amit.ahuja
After upgrading to 5.2.3 version, it takes so long to load service status detail page, about 2 mins. It was working fine with previous version 2014R2.7; really fast. Any suggestions?

Re: service status detail page take so long to load

Posted: Thu Jan 21, 2016 12:15 pm
by lmiltchev
Do you see any errors in the apache error log when you try loading the page?

Code: Select all

tail -100 /var/log/httpd/error_log
Are you using any custom components such as the "Nagios XI Custom Column Component"?

https://exchange.nagios.org/directory/A ... nt/details

Have you modified any of the "default" settings under the "Performance Settings" page ("Dashlets" tab)?

Admin->Performance Settings

How long did it take to load the page prior to the upgrade?

Re: service status detail page take so long to load

Posted: Tue Feb 02, 2016 1:03 pm
by amit.ahuja
This is what i see in error_log

[Tue Feb 02 12:55:25 2016] [error] [client 11.48.269.61] PHP Notice: Undefined index: pretty in /usr/local/nagiosxi/html/api/includes/utils.inc.php on line 104

I have not change any default setting in performance setting.

it took milli sec to load the page prior to upgrade. After upgrade it took around 10 secs.

Re: service status detail page take so long to load

Posted: Tue Feb 02, 2016 3:26 pm
by hsmith
Is your machine you're using to access this server in the same data center that your XI server is? If not, please check /etc/hosts to make sure the internal and external URL you use to access this page are in there.

Re: service status detail page take so long to load

Posted: Tue Feb 02, 2016 5:05 pm
by gormank
I'm pretty sure the service detail page is grabbing data from the DB. As part of monitoring I set up 4 mysql monitors. You might enable something similar to see if the DB is slow.

mysql_connection_time
mysql_long_running_processes
mysql_slow_queries
service_mysql

Its just a guess so feel free to ignore it.

Re: service status detail page take so long to load

Posted: Tue Feb 02, 2016 6:20 pm
by EnvBroker1
Ours was slow too, but for some reason it only had 3% memory available. So we rebooted the server, available memory went up to 83%, everything sped back up and the services loaded with no problem. Haven't had the problem since, but we don't know what happened to the memory either.

Re: service status detail page take so long to load

Posted: Wed Feb 03, 2016 9:56 am
by lmiltchev
amit.ahuja, are you using any custom components such as the "Nagios XI Custom Column Component"? Have you restarted the server at least once after the upgrade?

What is the output of the following commands?

Code: Select all

top | head -6
echo 'show processlist;'|mysql -t -u root -pnagiosxi|wc -l
cat /etc/my.cnf
du /var/lib/mysql | sort -n -r