Scout Plugins |
Scout is a server monitoring & reporting application that's powered by plugins like this. Once you create your free Scout account, installing a plugin is a button-click away. |
|---|
Plugins » MySQL Slow Queries
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
7 Comments
| Installs: | 68 |
| Tested On: | Linux osx |
| Source: |
View Source
All plugins listed in the directory are open source.
|
Using on Solaris.
It would be helpful if the slow and very slow query thresholds were displayed in the graph key.
Source code to this is a 403 error – http://blog.forumwarz.com/scout/scout_mysql_slow.rb
This plugin has been put on GitHub so source code errors should no longer occur.
Why don’t you just read the slow queries file location from my.cnf
Since I’m using the new scout_agent this plugin is unable to read my slow-queries file : Error: Errno::EACCES Message: Permission denied.
Any advice ?
Raphaël,
By default, the agent runs plugins as the ‘daemon’ user (specified in /etc/scout_agent.rb). You’ll want to ensure this user has permission to read your slow query log file.