Ndoutils MySQL performance problem?

Livio Zanol Puppim livio.zanol.puppim at gmail.com
Thu Mar 5 02:14:19 CET 2009


I've tweaked the ndo configuration... It doesn't saves logs at database, and
I'm still having this problem.

I'll give a try at everybody suggestion tomorow. Thanks very much! :)

2009/3/4 Marc Powell <marc at ena.com>

>
> On Mar 4, 2009, at 5:19 PM, Marc DeTrano wrote:
>
> > 2009/3/3 Livio Zanol Puppim <livio.zanol.puppim at gmail.com>:
>
> >
> > -We are using a my.cnf based on the "my-innodb-heavy-4G.cnf" example
> > that comes with MySQL.
> > -The innodb_flush_log_at_trx_commit setting in that file is
> > "2" (instead
> > of 1..the difference in performance is huge, and the trade off in data
> > integrity is negligible for us)
>
> Thanks for this info...
>
> > If your process gets heavy over time, you may have to reduce things in
> > ndo2db.cfg like max_servicechecks_age (to keep the size of these
> > historical tables manageable).
>
> I find that these are my two largest. They grow *huge* I had to drop
> them and recreate just last week as they were ~20G and ~35G
> respectively...
>
> 1.5G    nagios_host_contactgroups.ibd
> 3.2G    nagios_service_contactgroups.ibd
>
> They're not particularly relevant to me but I don't see that there is
> that kind of granularity to exclude them...
>
> --
> Marc
>
>
>
> ------------------------------------------------------------------------------
> Open Source Business Conference (OSBC), March 24-25, 2009, San Francisco,
> CA
> -OSBC tackles the biggest issue in open source: Open Sourcing the
> Enterprise
> -Strategies to boost innovation and cut costs with open source
> participation
> -Receive a $600 discount off the registration fee with the source code:
> SFAD
> http://p.sf.net/sfu/XcvMzF8H
> _______________________________________________
> 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
>



-- 
[]'s

Lívio Zanol Puppim
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://www.monitoring-lists.org/archive/users/attachments/20090304/31293e86/attachment.html>
-------------- next part --------------
------------------------------------------------------------------------------
Open Source Business Conference (OSBC), March 24-25, 2009, San Francisco, CA
-OSBC tackles the biggest issue in open source: Open Sourcing the Enterprise
-Strategies to boost innovation and cut costs with open source participation
-Receive a $600 discount off the registration fee with the source code: SFAD
http://p.sf.net/sfu/XcvMzF8H
-------------- next part --------------
_______________________________________________
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


More information about the Users mailing list