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
