NagioSQL

[Moby]

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<jim at jimavery.me.uk>  wrote:
>> On 15 March 2010 21:14, Ron Wilson<ron at 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 at 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 at 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 at 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