Nagios Support Forum

Hello Everyone,
We are still running XI version 5.6.12 due to the fact that when NDO 3 was first released we updated and ran into major performance issues where check results fell 20 - 30 minutes behind. Just wondering if anyone else is running a new version of XI with a large system that has 1000+ hosts and 20k+ service checks. If so are you seeing any latency when it comes to check results or any other noticeable performance issues?

I've seen a number of people running large systems with NDO-3 and the performance doesn't suffer once the database performance is tweaked a bit.

There's a couple of things you can do to optimize it:

- Offloading MySQL to Remote Server
- Nagios XI Database Optimization

On long-running systems with mucho checks, the database can get bogged down with excessive "paper trail" type data and the software's database queries aren't properly utilizing indexes. It just needs better thresholds to get performance back where it should be:

Open Admin => Performance Settings, then click on the Databases tab. Change the following settings:

- Max Log Entries Age: change to 10
- Max Audit Log Age: change to 10
- Max State History Age: change to 30

It might take up to a day for the "cleaner" process to run depending on how your system is configured, but it'll eventually run and clean your database of all these for you.