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 <j...@jimavery.me.uk> wrote: > 2009/3/26 Rodney Ramos <rodne...@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). >
------------------------------------------------------------------------------
_______________________________________________ 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
