Scout Plugins

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:

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