trimming nagvis database via cron
Kevin Keane
subscription at kkeane.com
Fri Jun 19 20:57:15 CEST 2009
I had a similar problem with my ndoutils and mysql. If you are using
MySQL and aren't using replication, don't forget to first clear and then
turn off binary logs - those files get huge very quickly.
Michael W. Lucas wrote:
> Hi,
>
> 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.
>
> Surely someone has already written a script to purge the NagVis
> database on a regular basis, trimming old data to keep the database at
> a reasonable size. If so, could you share it?
>
> I'm sure I can figure this out, but I can't believe that nobody else
> has had this issue.
>
> Thanks,
> ==ml
>
>
>
--
Kevin Keane
Owner
The NetTech
Find the Uncommon: Expert Solutions for a Network You Never Have to Think About
Office: 866-642-7116
http://www.4nettech.com
This e-mail and attachments, if any, may contain confidential and/or proprietary information. Please be advised that the unauthorized use or disclosure of the information is strictly prohibited. The information herein is intended only for use by the intended recipient(s) named above. If you have received this transmission in error, please notify the sender immediately and permanently delete the e-mail and any copies, printouts or attachments thereof.
------------------------------------------------------------------------------
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
More information about the Users
mailing list