NDO 3.x on a large system

This support forum board is for support questions relating to Nagios XI, our flagship commercial network monitoring solution.
Locked
jvaira
Posts: 59
Joined: Tue Dec 22, 2015 7:40 pm

NDO 3.x on a large system

Post by jvaira »

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?
dchurch
Posts: 858
Joined: Wed Oct 07, 2020 12:46 pm
Location: Yo mama

Re: NDO 3.x on a large system

Post by dchurch »

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.
If you didn't get an 8% raise over the course of the pandemic, you took a pay cut.

Discussion of wages is protected speech under the National Labor Relations Act, and no employer can tell you you can't disclose your pay with your fellow employees.
Locked