Page 2 of 2

Re: High Load CPU

Posted: Mon Jan 30, 2017 4:15 am
by 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.

Re: High Load CPU

Posted: Mon Jan 30, 2017 10:17 am
by 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

Re: High Load CPU

Posted: Mon Jan 30, 2017 11:53 am
by 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.

Re: High Load CPU

Posted: Mon Jan 30, 2017 12:31 pm
by ssax
What is eating up the cpu?

Code: Select all

top

Re: High Load CPU

Posted: Wed Feb 01, 2017 8:05 am
by asardouk
ssax wrote: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.

Re: High Load CPU

Posted: Wed Feb 01, 2017 10:34 am
by 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.

Re: High Load CPU

Posted: Wed Mar 01, 2017 1:56 pm
by tmcdonald
Just checking in since we have not heard from you in a while. Did @rkennedy's post clear things up?

Re: High Load CPU

Posted: Mon Mar 13, 2017 10:10 am
by asardouk
rkennedy wrote: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 :P. I've figured out how to correct it :D

Re: High Load CPU

Posted: Mon Mar 13, 2017 3:45 pm
by 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?