Page 7 of 9

Re: ndo2db Hogging ALL the CPU

Posted: Wed Dec 17, 2014 12:45 pm
by abrist
This could still be due to ndomod instead of ndo2db . . . .
What process is to blame for the spike?

Re: ndo2db Hogging ALL the CPU

Posted: Wed Dec 17, 2014 12:51 pm
by BanditBBS
abrist wrote:This could still be due to ndomod instead of ndo2db . . . .
What process is to blame for the spike?
Nothing that I can see. There is no difference as to when the spike isn't happening(when watching top).

Re: ndo2db Hogging ALL the CPU

Posted: Wed Dec 17, 2014 1:05 pm
by scottwilkerson
James,

Can you PM me your nagios.cfg and also, can you confirm/deny if you have checks that have specific timeperiods.

e.g. A "work hours" time period that kicks off at 9am and a whole bunch of additional checks are scheduled...

thanks

Re: ndo2db Hogging ALL the CPU

Posted: Wed Dec 17, 2014 2:23 pm
by BanditBBS
Getting called James on the forums is like being called to the principal's office, lol.

I sent the PM. As for special time periods for checks, yes there are some, but I can count them on less then one hand, for sure less than 2.

Re: ndo2db Hogging ALL the CPU

Posted: Wed Dec 17, 2014 3:32 pm
by scottwilkerson
I looked at the file, and nothing out of the ordinary there...
BanditBBS wrote: As for special time periods for checks, yes there are some, but I can count them on less then one hand, for sure less than 2.
Less than 2 timeperiods, or less than 2 hosts/services that use the time periods?

I know this is a shot in the dark, but trying to figure out what the heck could be running causing the spike all at the same time.

It would be interesting to see the processes that are running right when the load spiked. Maybe you could setup an event handler that runs when load on localhost goes above a certain threshold that would write some process information to a text time?

Re: ndo2db Hogging ALL the CPU

Posted: Wed Dec 17, 2014 3:36 pm
by scottwilkerson
We just came to another possible conclusion...

Do you have scheduled reports setup on this system?

I ask because the default "time" for scheduled reports is in fact 9:00am and if you have many that you have not changed the run time of, they could be all kicking off at the exact same time...

Re: ndo2db Hogging ALL the CPU

Posted: Wed Dec 17, 2014 3:58 pm
by BanditBBS
Is there a way to qeury the DB for a list....I have many users that may have done that. However, the CPU load spike may last for 10 hours or more, so is that a real possibility?

Re: ndo2db Hogging ALL the CPU

Posted: Wed Dec 17, 2014 4:04 pm
by scottwilkerson

Code: Select all

crontab -u apache -l
However, I was under the assumption that there was just a large spike at 9am, not likely to last throughout the day

Re: ndo2db Hogging ALL the CPU

Posted: Wed Dec 17, 2014 4:06 pm
by BanditBBS
Nah, it can last all day. 12 hours 20-200 load, next 12 hours 2-4 load, doing the exact same stuff. However, if it is fine around 9am, it more often then not will start the spike then.

Apparently only 3 scheduled reports so far, actually surprised me a little.

Re: ndo2db Hogging ALL the CPU

Posted: Wed Dec 17, 2014 6:07 pm
by abrist
BanditBBS wrote:Apparently only 3 scheduled reports so far, actually surprised me a little.
Which reports? (if you have a db or logfile problem, certain reports could be to blame for load problems).