> -----Original Message----- > From: nagios-users On Behalf Of Marcel Mitsuto Fucatu Sugano > Sent: 15 February 2007 14:58 > > On Thu, 2007-02-15 at 10:17 +0000, Wheeler, JF (Jonathan) wrote: > > -----Original Message----- > > From: nagios-users On Behalf Of Marcel Mitsuto Fucatu Sugano > > Sent: 14 February 2007 19:27 (big snip) > > >> 2) Is it crazy to think I can keep *all* the NDO data > forever? (~500 hosts / 6000+ srvcs) > > > > > > Well, considering that only state changes matters, it isn't that crazy. > > > > The only place where I have had to do anything is with the logentries > > table which (in our case) has written more records than is allowed by > > MySQL and sometimes generates MySQL errors. Deleting old entries solves > > the problem (I have a script that deletes entries more than 6 weeks > > old). > > Deleting old entries didn't wacks historical state change data?
I do not see a need to keep the log data for more than six weeks in the SQL tables; these are separate from the log files on the Nagios server. Note that there is no cleanup of the Nagios logs (as far as I am aware), so these need to be cleared out every so often as well. I have a separate script which compresses all log files except the last six and only keeps 190 files (about 6 months of data) in the log archives directory. Jonathan Wheeler e-Science Centre Rutherford Appleton Laboratory ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys-and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ Nagios-users mailing list [email protected] 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
