2009/3/3 Livio Zanol Puppim <livio.zanol.pup...@gmail.com>: > > > > I'm having huge troubles with Mysql using 100% of CPU at peculiar times. I > > don't know when this problem starts and I don't know the reason, but when it > > happends I kill nagios, ndoutils and Mysql, and try to restart Mysql, > > ndoutils and Nagios at this order. When I start Nagios, the CPU usage of > > Mysql goes to 100% and everything just freezes with the initials > > INSERT/UPDATES made by ndoutils. > > > > Has anyone had the same problem? I've changed my.cnf to hold slow-queries > > logging, an have seen at intervals of 1 minute a query runned by ndo that 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. ------------------------------------------------------------------------------ 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
