NDOUtils: high mysql (cpu) Load, after moving from vmware to kvm

Michael Friedrich michael.friedrich at univie.ac.at
Tue Sep 22 09:07:21 CEST 2009


Hi,

Denny Schierz wrote the following on 21.09.2009 23:13:
> but this helps only a few minutes (10-15min). So, any suggestions?
>   
Depending on your db trimming settings and the count of hosts/services 
you may encounter concurrent insert/update and delete statements.
If your event broker options point to -1 everything from Nagios and the 
neb module will be sent by ndmod to ndo2db and inserted/updated into the 
database. But the builtin housekeeping module keeps track of old entries 
and may send deletes by time comparison. Those deletes will get quite 
huge depending how many e.g. timed events have occured within a small 
period of time.

So for the first part, it would be interesting, which data do you really 
need (actual, historical, status only). Deciding upon this matching you 
should set the data processing option for the event broker. Either way 
also how often the most common tables will be cleaned (in ndo2db.cfg). 
Before you ask there is no key value for everyone. It's highly dependant 
on the rdbm (in this case only MySQL), hardware and i/o, and on the 
Nagios config and check intervals and generated events etc.

Kind regards,
Michael


-- 
DI (FH) Michael Friedrich
michael.friedrich at univie.ac.at
Tel: +43 1 4277 14359

Vienna University Computer Center
Universitaetsstrasse 7 
A-1010 Vienna, Austria  


------------------------------------------------------------------------------
Come build with us! The BlackBerry® Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay 
ahead of the curve. Join us from November 9-12, 2009. Register now!
http://p.sf.net/sfu/devconf
_______________________________________________
Nagios-users mailing list
Nagios-users at lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/nagios-users
::: Please include Nagios version, plugin version (-v) and OS when reporting any issue. 
::: Messages without supporting info will risk being sent to /dev/null





More information about the Users mailing list