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