Scout PluginsSimple server and application monitoring that's powered by plugins like this.

Plugins » MySQL Stats w/MySQLTuner

by Eric Lindvall

This Plugin URL has not been approved yet.

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.

HomeFeaturesPricing & SignupPluginsAPIHelpBlogTwitterAbout