Nagios XI Reports Page UnResponsive

[sarfarosh]

Hi Team,
We are able to fetch the reports for today,yesterday,weekly. But when we are trying to fetch the reports for monthly, quarterly or above, the reports page become unresponsive after 8-10 minutes of buffering. Please find the screenshot of the reports page, system profile and php.ini settings.

/etc/php.ini
max_execution_time = 240 (increased from 30 - 60 -120 -240)
max_input_time = 240 (increased from 30 - 60 -120 -240)
memory_limit = 1024M (increased from 512 - 1024)
output_buffering = 8192 (increased from 4096 to 8192)

[tacolover101]

a few questions for you:
- what type of disks are you running XI on?
- what is the CPU / memory specs?
- how many hosts are in these reports?

this is a lot of data to process through SQL which leads to it taking a while to generate. there may be ways to optimize somewhat though. i would try generating your reports in smaller chunks if possible.

[scottwilkerson]

It can take even longer if it is the Availability, SLA or Executive Summary report as these have to parse MANY log files off the drive to do the calculations.

Which reports are you seeing this with?

We do have a plan to make it so the reports can be generated in the background and then be available when re-visiting the page but I don't have a timeline when this will be finished.