Plugins » MySQL Stats w/MySQLTuner

by Eric Lindvall


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.

Installs: 265
Tested On: OSX, Ubuntu 10, Centos 5
Source: View Source
All plugins listed in the directory are open source.
Help