Re: [Nagios-users] trimming nagvis database via cron
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? Nagvis-1.4 added support for Merlin's database, which has a much slimmer profile than NDO. Merlin is not quite recommended for production use yet but we are working on it so it will be in a few weeks time, you might want to check it out. Cheers -- Johannes Dagemark CTO / VP Engineering op5 AB Första Långgatan 19 SE-413 27 Gothenburg cell: +46 733-70 90 24 fax: +46 31-774 04 32 Email: j...@op5.com http://www.op5.com/ I'm sure I can figure this out, but I can't believe that nobody else has had this issue. Thanks, ==ml -- 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@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
[Nagios-users] trimming nagvis database via cron
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 -- Michael W. Lucasmwlu...@blackhelicopters.org, mwlu...@freebsd.org http://www.BlackHelicopters.org/~mwlucas/ Latest book: Cisco Routers for the Desperate, 2nd Edition http://www.CiscoRoutersForTheDesperate.com/ -- Crystal Reports - New Free Runtime and 30 Day Trial Check out the new simplified licensing option that enables unlimited royalty-free distribution of the report engine for externally facing server and web deployment. http://p.sf.net/sfu/businessobjects ___ 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
Re: [Nagios-users] trimming nagvis database via cron
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@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
Re: [Nagios-users] trimming nagvis database via cron
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@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
Re: [Nagios-users] trimming nagvis database via cron
On Friday 19 June 2009, Kevin Keane wrote: 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. Yea, binary logs can be a pain to, I am working on a global event handler for purging. 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@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
