Slow dashboard loading ....

This support forum board is for questions relating to Nagios Fusion.
Locked
vishfx
Posts: 134
Joined: Tue Apr 24, 2018 12:30 pm

Slow dashboard loading ....

Post 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.
You do not have the required permissions to view the files attached to this post.
ssax
Dreams In Code
Posts: 7682
Joined: Wed Feb 11, 2015 12:54 pm

Re: Slow dashboard loading ....

Post 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
vishfx
Posts: 134
Joined: Tue Apr 24, 2018 12:30 pm

Re: Slow dashboard loading ....

Post by vishfx »

Hi Sean,

PFA output you asked for.

Regards,
Vish.
You do not have the required permissions to view the files attached to this post.
benjaminsmith
Posts: 5324
Joined: Wed Aug 22, 2018 4:39 pm
Location: saint paul

Re: Slow dashboard loading ....

Post 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:

Code: Select all

systemctl restart httpd
Let us know if this resolve the issue.
As of May 25th, 2018, all communications with Nagios Enterprises and its employees are covered under our new Privacy Policy.

Be sure to check out our Knowledgebase for helpful articles and solutions!
vishfx
Posts: 134
Joined: Tue Apr 24, 2018 12:30 pm

Re: Slow dashboard loading ....

Post 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.
benjaminsmith
Posts: 5324
Joined: Wed Aug 22, 2018 4:39 pm
Location: saint paul

Re: Slow dashboard loading ....

Post 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.
As of May 25th, 2018, all communications with Nagios Enterprises and its employees are covered under our new Privacy Policy.

Be sure to check out our Knowledgebase for helpful articles and solutions!
Locked