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.friedr...@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@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