trimming nagvis database via cron

[Syd Alsobrook]

On Friday 19 June 2009, Michael W. Lucas wrote:
> After a few months of use, our NagVis database grew to 23GB and
> overwhelmed my (tiny) server.  Shutting down the system, dropping the
> database, and recreating it solved my issues.

This isn't a NagVis issues, this is a ndoutils issue. You need to look in your 
ndo2db.cfg file for the entries:

max_timedevents_age
max_systemcommands_age
max_servicechecks_age
max_hostchecks_age
max_eventhandlers_age

It is recommended that you set these to a very low value. If they are too high 
you will have other issues with nagios appearing to hang while the DB is 
cleaned.

Syd


-- 
Syd Alsobrook
IT Tag Team, Inc.
518-362-1291
http://www.ittagteam.com

------------------------------------------------------------------------------
Are you an open source citizen? Join us for the Open Source Bridge conference!
Portland, OR, June 17-19. Two days of sessions, one day of unconference: $250.
Need another reason to go? 24-hour hacker lounge. Register today!
http://ad.doubleclick.net/clk;215844324;13503038;v?http://opensourcebridge.org
_______________________________________________
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