highgroove / scout-plugins

Plugins for the Scout Server Monitoring and Reporting Tool

This URL has Read+Write access

itsderek23 (author)
Thu Jul 02 08:35:24 -0700 2009
commit  09eb7e51f9c3a48f96a05e53dbe8b4f0c0be9a1d
tree    94b3f1489bfa106a1d58692d64a852073f81f914
parent  dbdc24bea9835ab06d0415cae4aaaaf95665ac5b
scout-plugins / mysql_slow_queries
name age message
..
file README Wed Jan 28 13:38:10 -0800 2009 Put mysql slow queries plugin in github [itsderek23]
file mysql_slow_queries.rb Loading commit data...
file mysql_slow_queries.yml
mysql_slow_queries/README
Monitors for slow MySQL queries and generates an alert (containing the queries) whey they occur.

The plugin has two options, the path to your MySQL slow queries log and the threshold for a very slow query.

You must enable the [MySQL slow queries log](http://dev.mysql.com/doc/refman/5.0/en/slow-query-log.html) in your my.cnf 
file.

This can be done with the following 2 lines:

set-variable=long_query_time=2
log-slow-queries=/var/log/mysql/mysql-slow.log