High Service Check Latency

[Simone Felici]

Il 22/05/2012 16:25, Assaf Flatto ha scritto:

> One thing I found to help with performance with NDO was to make sure the DB is trimmed on a regular
> basis .
> tables timedevents, services , logentries and other ones grow very fast to large size and nagios is
> having trouble writing to the DB if the table is larger the 450MB .
>
> since i was using the NDO for nagviz the data was mostly not needed so i used to truncate those tables.
>
> If you do use the DB , replicate it to a secondary DB and use that as your queries master .and trim
> the one nagios writes to , but make sure that if the trimming is done , the data is not removed from
> the replicated server.

Thank's for this suggestion, I'll look to optimize as best as possible the database. Hope it helps!

Simon

------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and 
threat landscape has changed and how IT managers can respond. Discussions 
will include endpoint security, mobile security and the latest in malware 
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
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