On Thu, Feb 18, 2010 at 10:02:51AM -0600, Marc Powell wrote: > > On Feb 18, 2010, at 7:44 AM, Glynne Jones wrote: > > > Thought that might be the case. mysql is always busy (I've got 3370 checks > > over 362 hosts). > > > > You mention regular table maintenance tasks - is this something that comes > > out of the box or something separate? > > ndo2db.cfg -- > > ## TABLE TRIMMING OPTIONS
[snip] > I've set all of these to 1 hour for my install based on my needs. If you have > database backup scripts, those could be causing delays as well. > Doh!, cheers Marc. Forgot those were there. Don't think those are getting the way. Think it's more likely to be some of the other tables getting large. Have you changed the table engine from MyISAM to InnoDB? I'll have a play with the debug settings to see if I can find where the delay is coming in. Thanks, Glynne ------------------------------------------------------------------------------ Download Intel® Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev _______________________________________________ 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