Plugins like this provide extra functionality beyond Scout's default monitoring capabilities. This and 90+ other plugins are available via a one-click install in our web interface.

MySQL Slow Queries

Mysql

Monitors for slow MySQL queries and generates an alert when the slow query rate increases dramatically.

Overview

Monitors for slow MySQL queries and generates an alert when the slow query rate increases dramatically.

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.

By Forumwarz