NagiosXI CCM - Slow to the point of unusable

[russell.it]

Morning,

We are currently running NagiosXI 5.4.10 on Centos 6.9 (Final) 64 bit and the MySQL Database is running on MySQL 5.1 on Centos 6.9 (Final) 64 bit both are sitting on the same VMWare cluster

The issue we are having is when in the CCM section of NagiosXI pages are taking minutes to load. Running top/htop of both servers there is no great load. I have run the optimisation tools for the database, run the database fix scripts with no avail.

Currently as it stands to add a new host it’s taking about 30 minutes to get through all the screens and get to the point of applying the configuration.
Can you please provide guidance on how to speed up CCM. All other parts of our Nagios install work well and don’t take long to load.

Thanks,

Russell

[kyang]

Were there any errors when you tried adding a new host?

Are there any issue's when you verify the configs? In the CCM --> click Config File Management under Tools --> Verify --> Show us the output.

Anything in the apache logs?

Code: Select all

tail -100 /var/log/httpd/error_log

You could try to increase the PHP values.

Code: Select all

Edit /etc/php.ini and increase these values:

max_execution_time = 60
max_input_time = 60
memory_limit = 256

to 

max_execution_time = 120
max_input_time = 120
memory_limit = 512

Code: Select all

After making these changes you'll need to restart the httpd service:

service httpd restart

[russell.it]

I grabbed the log as requested, I can see that I am having an issue with one of my hosts which I will fix but I dont believe that should cause that much issue with CCM.

I done the php.ini changes and restarted httpd my loading times have improved but still aren't good. I timed some page loading times.

• Homepage -> Service Detail 6.2s

• Service Detail -> Hyper map 5.6s

• Hyper map -> CCM Homepage 25.3s

• CCM Homepage -> CCM Hosts 24.6s

• CCM Hosts -> CCM Host Page 37.9s

• CCM Host Page -> CCM Services 1:36min

• CCM Services -> CCM Service page 32.9s

As you can see the load times in the CCM section are quite large. We are currently sitting at
Hosts: 292
Services: 826

[kyang]

Could you send us your whole profile?

Nagios XI Profile --> On the XI Home Page click "Admin" > "System Profile" --> "Download Profile" button
Save the profile.zip file and upload it here or PM me.

If you receive a PROFILE BUILD FAILED
Please follow this article,

https://support.nagios.com/kb/article.p ... ategory=44

After you PM the profile please update this thread, unless you post the profile on here. Thanks!

UPDATE: Logs received!

[russell.it]

Afternoon,

Can I get an update on this ticket please.

[dwhitfield]

After you PM the profile please update this thread, unless you post the profile on here. Thanks!

The reason @kyang asked you to post is because posting is the only way it gets back on our dashboard. This is why you have not gotten a response.

There's probably more tweaking you could do, but at your size, I would start with the suggestion of a ramdisk: https://assets.nagios.com/downloads/nag ... giosXI.pdf

[npolovenko]

@russell.it, Memory limit value should have M at the end. Please change this line in /etc/php.ini:

Code: Select all

memory_limit = 512

to

Code: Select all

memory_limit = 512M

Can you tell us how many CPU's are set to the VM image? How much memory is dedicated? There might be some other restrictions imposed by the VMWare infrastructure.

[russell.it]

I just had a look at the php.ini file the memory_limit does have an M at the end

Code: Select all

memory_limit = 512M

The Nagios VM has
16vCPUs
8GB of memory

[kyang]

by russell.it
I done the php.ini changes and restarted httpd my loading times have improved but still aren't good. I timed some page loading times.

Since increasing the memory_limit did not work. Have you tried increasing it to a higher value since it worked a little bit the first time?

Have you taken a look at @dwhitfields suggestion of utilizing a ramdisk?

https://assets.nagios.com/downloads/nag ... 1514991632

That is a good suggestion at this point if you haven't used one.

[russell.it]

I will bump the memory up again.

As for the ram disk change, I have planned it for the 11th of January as it is something that needs to be done in a change window for us. I will report back if it improves for us