SLA report causing high CPU spikes

[niebais]

Redhat 7
Nagios XI 5.4.10

When I click on the availability report or the SLA reports, it causes a spike in one of the http processes and the report never shows up. I've modified the php.ini parameters to support larger memory (2048MB) and a longer processing time of up to 10 (600 seconds) minutes, but the reports never come back and it eventually times out.

What can I look at to fix this?

[dwhitfield]

I'm not surprised with that many hosts+services (~19k). Is this a physical machine or a VM? You may need to move it to a physical machine.

Do you have jumbo frames enabled? With your size, I'd generally NOT suggest having an offloaded db. The biggest caveat to that statement though may be if you have passive checks. Do you know roughly how many of those 19k checks are passive?

[niebais]

Currently it is a VM. The load average generally runs around 1 to 2, so I'm not too concerned about resource utilization on the system. The database is offloaded, but it didn't make a difference when it wasn't offloaded either. The reports haven't worked ever since we got over 10K in services.

As for the jumbo packets, we are currently implementing those in production at this time.

[dwhitfield]

What's the output of cat /etc/hosts?

[niebais]

127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
::1 localhost localhost.localdomain localhost6 localhost6.localdomain6

[dwhitfield]

As for the jumbo packets, we are currently implementing those in production at this time.

Any changes? I'd still not suggest it on a system of your size. 10k is when we start getting a little worried, so I'm not bothered by that # either as far as seeing this as a concern.

Can you PM me your Profile? You can download it by going to Admin > System Config > System Profile and click the ***Download Profile*** button towards the top. If for whatever reason you *cannot* download the profile, please put the output of View System Info (5.3.4+, Show Profile if older) in the thread (that will at least get us some info). This will give us access to many of the logs we would otherwise ask for individually. If security is a concern, you can unzip the profile take out what you like, and then zip it up again. We may end up needing something you remove, but we can ask for that specifically.

You can also generate a profile manually using the script at /usr/local/nagiosxi/html/includes/components/profile/getprofile.sh

That should generate a profile in /usr/local/nagiosxi/var/components/ which you can get off the server with an application such as FileZilla.

After you PM the profile, please update this thread. Updating this thread is the only way for it to show back up on our dashboard.

If you get an error that PROFILE BUILD FAILED, please see https://support.nagios.com/kb/article.p ... ategory=44