Application Monitoring is coming soon! Git-integrated app monitoring streamlines the path from slow to fast. Early access
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 Stats w/MySQLTuner

Mysql

Returns statistics on MySQL select, delete, insert, and update operations, and generates weekly MySQL tuning and performance recommendations.

Overview

Updated 3/25/2013This plugin has been deprecated and is replaced by the MySQL Query Stats Plugin. The new plugin removes the dependency on the mysql gem.


mysql


This plugin reports statistics on MySQL operations, and generates weekly MySQL tuning and performance recommendations.

Queries per-second are reported for the following operations:

  • Delete
  • Insert
  • Update
  • Select
  • Total Queries

MySQLTuner

The plugin generates weekly analysis and recommendations on your MySQL configuration using MySQLTuner. For example, the analysis will inform you if:

  • the amount of memory you have allocated to MySQL is appropriate
  • tables are fragmented and need to be optimized
  • query cache sizes, max heap sizes, or buffer pool sizes need adjusting
  • queries are requiring an excessive number of temp tables
  • … and much more!

View an example report »

The analysis is generated weekly, or on a frequency you specify through the plugin settings.

Dependencies

This plugin requires to mysql Ruby gem. To install:

gem install mysql

The MySQLTuner script does not need to be installed. It is included in the plugin code.

By Eric Lindvall