Plugins » MySQL Slow Queries

by Forumwarz

mysql

Monitors for slow MySQL queries and generates an alert (containing the queries) whey they occur.

The plugin requires the path to your MySQL slow queries log file.

Enabling MySQL Slow Queries Logging

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

A restart of mysql may be required.