Performance Issue with Availability Report (avail.cgi)

[azreenariff]

Dear Support,

I have a performance issue with Availability Report after clicking on 'Report' tab. From top utility, CPU usage reaches 100% for 'avail.cgi' process and web interface takes very long time. Need your kind assistance to resolve.

Below are the info for your reference:

NagiosXI Server
OS: Redhat Enterprise Linux Serverrelease 7.4 (Maipo) x86-64
CPU: 8
Memory: 16GB
NagiosXI: 5.4.13

Database Server
OS: Redhat Enterprise Linux Serverrelease 7.4 (Maipo) x86-64
CPU: 16
Memory: 32GB
DB: MySQL 14.4 Distrib 5.7.21

Thank you in advnce.

[cdienger]

Check out https://support.nagios.com/kb/article.php?id=23 and at the bottom are some steps you can take to tune reports a bit as well as logs to monitor if it is still an issue.

[azreenariff]

Hi Support,

Thank you for your reply. The max_execution, max_input, and memory settings in /etc/php.ini are already double from default, and there is already a trailing forward slash after http://<server>/nagiosxi/ for Program URL, and External URL is left blank. There is no error in /var/log/httpd/*. But the issue still persists where the avail.cgi process is utilizing up to 100% of a CPU and the interface pages hanging during this time. Any other suggestions that we can look into?

For your info, we have 1627 hosts and 73750 services

Thanks.

[cdienger]

The report process is single threaded and with the number of services on the machine, it isn't surprising to see the cpu get spiked like that. I would suggest disabling the auto run report option in this case. It can be done under Admin > System Config > Performance Settings > Auto Running > Disable reports from automatically running on page load.

[azreenariff]

Disabled reports from automatically running on page load as suggested. This at least gives way to select which hosts, services, or groups to include before actually running the report. Actual running the Availability Report will still take at least 10min to produce, but I suppose this can't be avoided due to the high number of services and single threaded avail.cgi process.

Thanks.