Nagios, ndoutils and database indexes

[Marco Tirado]

Hello:

We run nagios 3.0.6 with ndoutils and nagvis for host visualization. We had
some problems with our nagios server a couple of weeks ago and we believe it
is related to mysql performance, we could see that the mysql process was
consumming from 80 to 90 % of the CPU in the monitoring server at certain
times. We could solve the problem by applying a couple of indexes to the
nagios database (the one used by ndoutils) as recommended in thread:

http://www.mail-archive.com/nagios-users@lists.sourceforge.net/msg23943.html

Afterwords we enabled monitoring for the nagios database by using the
check_mysql_health plugin and we see that the index usage for the nagios
database is under 10%. I am not a Database Administrator but I believe this
is a very low index usage.

I would like to konw if anyone has any recommendations about database
indexes applicable to the nagios database for ndoutils/nagvis.

Any tips/hints are appreciated

//Marco
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://www.monitoring-lists.org/archive/users/attachments/20090513/abca0a49/attachment.html>
-------------- next part --------------
------------------------------------------------------------------------------
The NEW KODAK i700 Series Scanners deliver under ANY circumstances! Your
production scanning environment may not be a perfect world - but thanks to
Kodak, there's a perfect scanner to get the job done! With the NEW KODAK i700
Series Scanner you'll get full speed at 300 dpi even with all image 
processing features enabled. http://p.sf.net/sfu/kodak-com
-------------- 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