Slowness in generating Nagios Report

[kmartaus]

Hi,
We have the most up to date Nagios Xi version (2014 R1.4) and recently upgraded our mysql version to 5.6.20. Every month we have to generate SLA reports for the business from Nagios which takes a lot of time. Even after upgrading to the current version of Nagios XI and mysql, it still takes a lot of time to generate those reports. For an example, to generate a quarterly report for one hostgroup takes more than 12 mins. Also the avails.cgi chew up most of the cpu time.

is there anyway we can tune up the nagios to improve the performance of report generation?

Also I was wonder how does Nagios generate reports? Does it only uses mysql databases to generate the report or it uses the archive logs as well?
Also which tables does it uses mostly to generate SLA (service state) report?

OS Version:
Application in CentOS Linux release 6.0
Database is on SUSE Linux Enterprise Server 11 SP1 for VMware
Application is a VM Image.

Thank you
Zubair Altaf
System Engineer

[slansing]

What type of hardware resources are available for these two systems on demand? You will also see an I/O latency increase if that is an offloaded mysql instance, especially when querying larger tables, and an even greater I/O increase if the mysql system uses NAS or networked drives, rather than local ones.

[mrochelle]

I believe this is a known problem or let say, we are experiencing similar performance problems with reports. However, we also use the GUI addon feature Thruk http://www.thruk.org which leverages the backend interface using the Livestatus API. Thruk has a Reporting option that runs substantially fast. All the reports that were taking 12 to 15 minutes for us run in under 40 seconds via thruk and it will mail the reports as required, the same as the nagiosxi interface.

fyi, Marcus

OS Version:
Nagios XI Version : 2014R2.0
Database is local.
Application is a VM Image.

[lmiltchev]

The reason why generating reports could be so slow (in large environments) is that they are being pulled from the logs. This will be changed in Nagios XI 2015. The reports will be pulled from the database, which should significantly speed up the process.

[kmartaus]

Thanks for all your responses.

@lmiltchev : do you know when in 2015 the new Nagios XI version will come out which will only pull from databases?
As we have large environment and will continue to grow more, we will need this new version so we can generate reports fast.

Zubair

[abrist]

Well, the logs files can get oppressive, and end up really slowing down the db if we just added all log entries to the logentries table or status table.
We have not announced 2015 officially yet, so I would not expect it in early 2015.