Re: [Nagios-users] Ndoutils MySQL performance problem?

2009-03-06 Thread Jim Avery
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

Re: [Nagios-users] Ndoutils MySQL performance problem?

2009-03-04 Thread Marc DeTrano
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,

Re: [Nagios-users] Ndoutils MySQL performance problem?

2009-03-04 Thread Marc Powell
On Mar 4, 2009, at 5:19 PM, Marc DeTrano wrote: 2009/3/3 Livio Zanol Puppim livio.zanol.pup...@gmail.com: -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

Re: [Nagios-users] Ndoutils MySQL performance problem?

2009-03-04 Thread Livio Zanol Puppim
I've tweaked the ndo configuration... It doesn't saves logs at database, and I'm still having this problem. I'll give a try at everybody suggestion tomorow. Thanks very much! :) 2009/3/4 Marc Powell m...@ena.com On Mar 4, 2009, at 5:19 PM, Marc DeTrano wrote: 2009/3/3 Livio Zanol Puppim

[Nagios-users] Ndoutils MySQL performance problem?

2009-03-03 Thread Livio Zanol Puppim
Hello everyone! 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

Re: [Nagios-users] Ndoutils MySQL performance problem?

2009-03-03 Thread Ciro Iriarte
2009/3/3 Livio Zanol Puppim livio.zanol.pup...@gmail.com: Hello everyone! 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

Re: [Nagios-users] Ndoutils MySQL performance problem?

2009-03-03 Thread Mathieu Gagné
Livio Zanol Puppim wrote: 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