NDO update delay

[Rodney Ramos]

Sorry, Jim, but my problem is not with Nagios startup. The problem is that
NDOUtils does not update MySQL tables fast. It takes more than 30 minutos do
make an update.

As I´ve told, I´ve noticed that making a query on the nagios_hoststatus
table.

Does anybody has a similiar problem? Has anybody made a query on this table
and compare de last_chek value with the "Last Check" value showed by Nagios?

Thanks,
Rodney.



On Thu, Mar 26, 2009 at 4:51 PM, Jim Avery <jim at jimavery.me.uk> wrote:

> 2009/3/26 Rodney Ramos <rodneyra at gmail.com>:
>  > Hi everybody.
> >
> > I´ve installed NDOUtils (nodutils-1.4b7) whith Nagios (nagios-3.0.6) and
> > it´s working.
> >
> > However I´ve noticed that it´s taking more than 30 minutes to update the
> > MySQL tables.
> >
> > I´ve detected the problem making a query on the field "last_check" on
> > "nagios_hoststatus" table.
> >
> > Can anyone help me? There is a parameter to make the update process
> faster?
>
>
> You can try reducing the number of days data you keep and adding some
> indexes.  The solution I think helps most though was contributed by
> Marc DeTrano here in a thread here on 3rd/4th March which I summarised
> thus:
>
> I simply added a file "nagios.cnf"
> under /etc/mysql/conf.d like so:
>
>  [mysqld]
>  innodb_flush_log_at_trx_commit = 2
>
> and it reduced my Nagios startup time from more than 3 minutes to only
> 30 seconds!
>
> I already had quite a few of the data_processing_options disabled in
> ndomod.cfg and had reduced all of the max_*_age parameters in
> ndo2db.cfg to 24 hours (before those my startup time was more than 5
> minutes).
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://www.monitoring-lists.org/archive/users/attachments/20090327/e4f51ef4/attachment.html>
-------------- next part --------------
------------------------------------------------------------------------------
-------------- 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