On 03/15/2010 05:55 PM, Romain Komorn wrote: > Off the top of my head, > > The nagios_externalcommands table sounds a lot more related to > NDOutils than it is to NagioSQL . > I don't know if NagioSQL uses external commands to adjust the > configuration while nagios is running, without reloads, but that's the > only link I could see between NagioSQL and a growing > nagios_externalcommands table. > > Romain > > On Mon, Mar 15, 2010 at 3:46 PM, Jim Avery<j...@jimavery.me.uk> wrote: >> On 15 March 2010 21:14, Ron Wilson<r...@tvnz.co.nz> wrote: >>> I am using NagioSQL and find some of the tables are growing quite rapidly. >>> nagios_externalcommands is quite large and I would like to reduce it. Has >>> anyone any tips for general maintenance of the sql tables in ngaios. I don’t >>> want to zap something that system needs >> Nagios itself doesn't use anything in the database. >> >> I would point you to the NagioSQL support page at >> http://www.nagiosql.org/support.html , but it seems to be down at the >> moment :-( >> >> I doubt NagioSQL would need much in the nagios_externalcommands table >> so I guess you could trim it quite aggressively. I don't use NagioSQL >> myself, so can't be 100% sure though. >> >> Other addons, for example NagVis use the database too, but I doubt >> anything would need the externalcommands history for more than a day >> or two if at all. >> >> ------------------------------------------------------------------------------ >> 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 >> > ------------------------------------------------------------------------------ > 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 > > It is indeed to do with ndoutils and I have a script to clean out old (6 months in my case) data from all tables of ndoutils - if interested, I can send that script over.
-- --Moby They that can give up essential liberty to obtain a little temporary safety deserve neither liberty nor safety. -- Benjamin Franklin ------------------------------------------------------------------------------ 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
