service status detail page take so long to load

[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?

[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?

[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.

[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.

[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.

[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.

[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