Performance Issues with XI

This support forum board is for support questions relating to Nagios XI, our flagship commercial network monitoring solution.
Locked
pbarnett865
Posts: 10
Joined: Tue Aug 30, 2016 8:46 am

Performance Issues with XI

Post by pbarnett865 »

CentOS Linux release 7.9.2009 (Core)
64bit
VMWare deployed from template provided by Nagios.

Our Nagios installation has come to a grinding halt. Any type of service or host update take forever to apply and typically they end up inactivated and never end up getting checked.
dchurch
Posts: 858
Joined: Wed Oct 07, 2020 12:46 pm
Location: Yo mama

Re: Performance Issues with XI

Post by dchurch »

Can you please PM me a system profile so that we can diagnose further?
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.
dchurch
Posts: 858
Joined: Wed Oct 07, 2020 12:46 pm
Location: Yo mama

Re: Performance Issues with XI

Post by dchurch »

Just checking in since we haven't heard from you in a while. Were you able to solve the problem?
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.
dchurch
Posts: 858
Joined: Wed Oct 07, 2020 12:46 pm
Location: Yo mama

Re: Performance Issues with XI

Post by dchurch »

Profile received. Looking into it now.
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.
dchurch
Posts: 858
Joined: Wed Oct 07, 2020 12:46 pm
Location: Yo mama

Re: Performance Issues with XI

Post by dchurch »

I'm noticing there's a database error, possibly a crashed table.

If you run the database repair script, it may clear things up. Run the following as root from the terminal.

Code: Select all

/usr/local/nagiosxi/scripts/repair_databases.sh
See here for complete instructions: run the database repairLet me know if that is successful.
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.
pbarnett865
Posts: 10
Joined: Tue Aug 30, 2016 8:46 am

Re: Performance Issues with XI

Post by pbarnett865 »

I have ran the database repair script multiple times and it doesn't seem to make a difference.
dchurch
Posts: 858
Joined: Wed Oct 07, 2020 12:46 pm
Location: Yo mama

Re: Performance Issues with XI

Post by dchurch »

Looks like your mysql process is running rampant, pegged at 100% CPU for the past 2 hours. Monitoring 2460 individual hosts may be the issue.

Here is a document on Maximizing Performance in Nagios XI:
https://assets.nagios.com/downloads/nag ... ios-XI.pdf

And on page 9 of the Doc there is a link to another doc titled Offloading MySQL To A Remote Server:
https://assets.nagios.com/downloads/nag ... Server.pdf
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