Nagios, ndoutils and database indexes

[MAD]

I personally added indexes on the following fields :
* servicechecks / service_object_id
* servicechecks / state
* hostcheck / host_object_id
* hostcheck / state
* objects / objecttype_id
* services / host_object_id
* statehistory / object_id
* statehistory / state_change
* statehistory / state
* statehistory / state_time
* statehistory / last_state
* hoststatus / last_hard_state
* servicestatus / last_hard_state

Some may be useless to you.

Marc-André


----- Mail Original -----
De: "Marco Tirado" <marco.tirado at gmail.com>
À: nagios-users at lists.sourceforge.net
Envoyé: Mercredi 13 Mai 2009 09h49:18 GMT +01:00 Amsterdam / Berlin / Berne / Rome / Stockholm / Vienne
Objet: [Nagios-users] Nagios, ndoutils and database indexes


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 

------------------------------------------------------------------------------
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
_______________________________________________
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

------------------------------------------------------------------------------
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
_______________________________________________
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