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

[Denny Schierz]

hi,

Our Nagios was running in a Vmware  machine with a normal load round
about 1 or less on 4 CPU baremetal. We moved now from Vmware Server to
KVM on a CentOS. Nagios runs on Debian Lenny system with Centreon 2.x.

I don't now enough about MySQL, to solve my problem, so i need a little
bit help. After stopping NDO, the load is perfect <1 .

After a lot of searching, i found an entry to create a index:

create index nagios_servicechecks_idx1 on nagios_servicechecks
(start_time, instance_id);

but this helps only a few minutes (10-15min). So, any suggestions?

cu denny
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 197 bytes
Desc: Dies ist ein digital signierter Nachrichtenteil
URL: <https://www.monitoring-lists.org/archive/users/attachments/20090921/150bf835/attachment.sig>
-------------- next part --------------
------------------------------------------------------------------------------
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
-------------- next part --------------
_______________________________________________
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