<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <meta content="text/html; charset=ISO-8859-1" http-equiv="Content-Type"> </head> <body text="#000000" bgcolor="#ffffff"> You may wish to periodically off-load the historical data to a second database and clean up the primary one periodically. Having a smaller database would help immensely when NDO periodically truncates old data. Also, make sure that you have the proper database table indexes created. Also consider converting the tables to InnoDB. The default install of NDO doesn't have things fully optimized as well as it should be for large installations. Missing indexes would also cause MySQL to hang while searching the tables for old data to remove, and with MyISAM the table would be locked during the delete. On 07/06/2010 09:37 AM, Scott Ward wrote: <blockquote cite="mid:AANLkTiknQvxTP8k_bVUpy3QtkWHVzFHUX-a_v3mhdqqX@mail.gmail.com" type="cite">The problem with that is that we need to retain the information for at least 6 months possibly more. ~Scott Ward <div class="gmail_quote">On Tue, Jul 6, 2010 at 8:35 AM, Assaf Flatto <<a moz-do-not-send="true" href="mailto:nagios@flatto.net">nagios@flatto.net</a>> wrote: <blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"> Scott I encountered a similar issue with ndo and mysql when the tables grew to a monstrous size , and ndo had trouble doing the updates to the DB. Check the tables sizes and see if you can trim them to a more "manageable" size. Personally i truncate the tables that grow to fast every week as the data i need the ndo for is never more then a day old . Assaf <div> <div class="h5"> Scott Ward wrote: > I am having major latency problems, 700 seconds in some cases. I am > pretty sure that it is coming from ndo and mysql. Anybody have any > mysql configs or changes to ndo that can help. Right now I am using > the default ndo config and made some changes to allocate more memory > to mysql and that's pretty much it. </div> </div> -- Never,Ever Cut A Deal With a Dragon ------------------------------------------------------------------------------ This SF.net email is sponsored by Sprint What will you do first with EVO, the first 4G phone? Visit <a moz-do-not-send="true" href="http://sprint.com/first" target="_blank">sprint.com/first</a> -- <a moz-do-not-send="true" href="http://p.sf.net/sfu/sprint-com-first" target="_blank">http://p.sf.net/sfu/sprint-com-first</a> _______________________________________________ Nagios-users mailing list <a moz-do-not-send="true" href="mailto:Nagios-users@lists.sourceforge.net">Nagios-users@lists.sourceforge.net</a> <a moz-do-not-send="true" href="https://lists.sourceforge.net/lists/listinfo/nagios-users" target="_blank">https://lists.sourceforge.net/lists/listinfo/nagios-users</a> ::: Please include Nagios version, plugin version (-v) and OS when reporting any issue. ::: Messages without supporting info will risk being sent to /dev/null </blockquote> </div> <pre wrap=""> <fieldset class="mimeAttachmentHeader"></fieldset> ------------------------------------------------------------------------------ This SF.net email is sponsored by Sprint What will you do first with EVO, the first 4G phone? Visit sprint.com/first -- <a class="moz-txt-link-freetext" href="http://p.sf.net/sfu/sprint-com-first">http://p.sf.net/sfu/sprint-com-first</a></pre> <pre wrap=""> <fieldset class="mimeAttachmentHeader"></fieldset> _______________________________________________ Nagios-users mailing list <a class="moz-txt-link-abbreviated" href="mailto:Nagios-users@lists.sourceforge.net">Nagios-users@lists.sourceforge.net</a> <a class="moz-txt-link-freetext" href="https://lists.sourceforge.net/lists/listinfo/nagios-users">https://lists.sourceforge.net/lists/listinfo/nagios-users</a> ::: Please include Nagios version, plugin version (-v) and OS when reporting any issue. ::: Messages without supporting info will risk being sent to /dev/null</pre> </blockquote> </body> </html>