Page 1 of 1
Slow dashboard loading ....
Posted: Thu Mar 28, 2019 6:02 pm
by vishfx
Hi Nagios Team,
Am using Nagios Fusion 4.1.6
I have a dashboard with :
Tactitcal Summary
Service Group status
5 Performance graphs.
However, I see that the dashboards take a lot of time ( sometime 30 secs ) to load.
Below is a sample screenshot :
slow-Capture.PNG
How can we speed the loading time ?
Kindly advise.
Regards,
Vish.
Re: Slow dashboard loading ....
Posted: Fri Mar 29, 2019 11:53 am
by ssax
Hello Vish,
Please send me the output of this command so that we can see how large the tables are getting:
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 = 'fusion';" | mysql -ufusion -pfusion --table
Please run the dashboard again and then send me the output of these commands once you start it:
Code: Select all
top -n5
tail -F /var/log/httpd/error_log /var/log/httpd/ssl_error_log
Please attach your
/etc/php.ini as well.
Thank you
Re: Slow dashboard loading ....
Posted: Fri Mar 29, 2019 9:20 pm
by vishfx
Hi Sean,
PFA output you asked for.
Regards,
Vish.
Re: Slow dashboard loading ....
Posted: Mon Apr 01, 2019 5:03 pm
by benjaminsmith
Hi
@vishfx,
Thanks for sending over those files. One question we have is how many users are usually logged in at the same time?
Please increase the following values in php.ini:
Code: Select all
max_execution_time = 120
max_input_time = 120
memory_limit = 1G
Then restart Apache:
Let us know if this resolve the issue.
Re: Slow dashboard loading ....
Posted: Wed Apr 03, 2019 10:13 pm
by vishfx
Hi Sean,
It seems to have marginally improved.
Can this be improved further ?
At present, there are not more than 5 users logged in.
Regards,
Vish.
Re: Slow dashboard loading ....
Posted: Thu Apr 04, 2019 12:27 pm
by benjaminsmith
Hi
@vishfx,
We've recently made updates to Fusion to limit the polling of data to only users currently logged in. This will help reduce the load on the Fusion Server and improve performance.
We can either provide instructions for patching the system or Sean can reach to you a setup a remote session. Please let us know which would work best for you.
Thank you.