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 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

2 Comments Comment

Using on Solaris.

It would be helpful if the slow and very slow query thresholds were displayed in the graph key.

Leave a Comment
You must be logged in to your Scout account to leave a comment. Don't have a Scout Account?
Rating:
1 star2 star3 star4 star5 star
(3 votes)
You must have a Scout Account to vote.
Installs: 23
Tested On: Linux osx
Source: View Source
All plugins listed in the directory are open source.
Already have a Scout account?   Where do I login? Highgroove Studios Powered By Rails Machine