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 href="mailto:nagios@flatto.net">nagios@flatto.net</a>> wrote: <blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); 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></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 href="http://sprint.com/first" target="_blank">sprint.com/first</a> -- <a 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 href="mailto:Nagios-users@lists.sourceforge.net">Nagios-users@lists.sourceforge.net</a> <a 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>