SolarWinds acquires Scout’s SaaS-based server monitoring technology and launches it as SolarWinds Pingdom Server Monitor. Read more
MySQL Slow Queries ~ Pingdom Server Monitor
Plugins like this provide extra functionality beyond Pingdom Server Monitor'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