High Load CPU

[asardouk]

Hi,

The two first request worked correctly. results are in attachment.

The last request is make an ERROR. The table "xi_eventqueue" does not exist.

[ssax]

First, take an XI backup:

https://assets.nagios.com/downloads/nag ... ios-XI.pdf

Then, please run this command and it should resolve the issue for you:
- NOTE: Running this command will wipe out all data from the Home > Event Log OR Reports > Event Log report (this is the only information affected, those 2 locations are the same report), make sure you have known-good XI backups

Code: Select all

echo "truncate table xi_events; truncate table xi_meta;" | mysql -uroot -pnagiosxi nagiosxi

Let us know the results.

Thank you

[asardouk]

i executed the command, no error.

the load goes up to arount 20 this afternoon and then dropped between 4 and 6 since i executed the command. but it still a high cpu usage.

[ssax]

What is eating up the cpu?

Code: Select all

top

[asardouk]

What is eating up the cpu?

Code: Select all

top

same as first post.

We're going to migrate Nagios to a new server with more powerfull CPU and SSD. I hope that it's just an issue with VM performance.

[rkennedy]

It's possible - it sounds like it is one process spiking for a bit and then cooling down. Are you monitoring a lot of devices using SNMP by any chance?

Let us know how the new machine goes.

[tmcdonald]

Just checking in since we have not heard from you in a while. Did @rkennedy's post clear things up?

[asardouk]

It's possible - it sounds like it is one process spiking for a bit and then cooling down. Are you monitoring a lot of devices using SNMP by any chance?

Let us know how the new machine goes.

Hello,

it took me some times to get back to the Nagios Machine, I've optimized snmp requests in one of my scripts. And the Load drop down to an average of 2.30 . I think that the load is normal now, Can you confirm ?

My script works good with few hosts and when it's exetuted many time, the load grow up like an expo function . I've figured out how to correct it

[ssax]

Yeah, that's a good load value, nice job on the correction! Are we okay to mark this as resolved and lock the topic?