2009/3/4 Marc DeTrano <m...@gridshield.net>: > 2009/3/3 Livio Zanol Puppim <livio.zanol.pup...@gmail.com>: > I'm no expert at MySQL performance, but we found a couple of things that > helped speed up NDO significantly: > > -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). > > 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). > > Marc > Gridshield, S.A.
Wow! That made a huge difference! 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). Many thanks indeed! Cheers, Jim ------------------------------------------------------------------------------ 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@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