On 6 July 2010 15:40, Herb J. <[email protected]> wrote: > You may wish to periodically off-load the historical data to a second > database and clean up the primary one periodically. Having a smaller > database would help immensely when NDO periodically truncates old data. > > Also, make sure that you have the proper database table indexes created. > Also consider converting the tables to InnoDB. The default install of NDO > doesn't have things fully optimized as well as it should be for large > installations. Missing indexes would also cause MySQL to hang while > searching the tables for old data to remove, and with MyISAM the table would > be locked during the delete.
Amen to all that. Another trick which seems to make a huge difference was to create a file "/etc/mysql/conf/conf.d/nagios.cnf containing: [mysqld] innodb_flush_log_at_trx_commit = 2 I'm not a MySQL dba so can't explain what this does precisely. Suffice it to say you sacrifice a bit of reliability for some speed. Anyone looking to implement this change is recommended to read up on what it is before doing it. ------------------------------------------------------------------------------ This SF.net email is sponsored by Sprint What will you do first with EVO, the first 4G phone? Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first _______________________________________________ Nagios-users mailing list [email protected] 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
