mysqltuner - high-performance MySQL tuning script

Property Value
Distribution Ubuntu 12.04 LTS (Precise Pangolin)
Repository Ubuntu Universe amd64
Package name mysqltuner
Package version 1.1.0
Package architecture all
Package type deb
Installed size 88 B
Download size 13.33 KB
Official Mirror
High-performance MySQL tuning script written in perl that will provide
you with a snapshot of a MySQL server?s health. Based on the statistics
gathered, specific recommendations will be provided that will increase a
MySQL server's efficiency and performance. The script gives you
automated MySQL tuning that is on the level of what you would receive
from a MySQL DBA.
* Memory Usage: Calculates MySQL memory usage at max load and makes
recommendations for increasing or decreasing the MySQL memory
footprint. Per-thread and server-wide buffer data is calculated
separately for an accurate snapshot of the server?s configuration.
* Slow Queries: Reviews the amount of slow queries relative to the
total queries. Slow query time limits are also analyzed and
recommendations are made.
* Connections: Current and historical connection counts are
* Key Buffer: Takes configuration data and compares it to the actual
indexes found in MyISAM tables. Key cache hit rates are calculated
and variable adjustments are suggested.
* Query Cache: Query cache hit rates and usage percentages are used
to make recommendations for the query cache configuration
* Sorting & Joins: Per-thread buffers that affect sorts and joins
are reviewed along with the statistics from the queries run
against the server.
* Temporary Tables: Variable recommendations are made to reduce
temporary tables that are written to the disk.
* Table Cache: Compares total tables opened to the currently open
tables. Calculates the table cache hit rate in order to make
* Open Files: Determines if the server will approach or run into the
open file limit set by the operating system or the MySQL server
* Table Locks: Finds table locking that forces queries to wait and
makes suggestions for reducing locks that require a wait.
* Thread Cache: Calculates how many times MySQL must create a new
thread to respond to a query.
* Aborted Connections: Finds applications that are not closing
connections to MySQL properly.
* Read/Write Ratios: Calculates the percentage of read and write
operations on your MySQL installation.


Package Version Architecture Repository
mysqltuner_1.1.0_all.deb 1.1.0 all Ubuntu Universe
mysqltuner - - -


Name Value
perl -


Type URL
Binary Package mysqltuner_1.1.0_all.deb
Source Package mysqltuner

Install Howto

  1. Update the package index:
    # sudo apt-get update
  2. Install mysqltuner deb package:
    # sudo apt-get install mysqltuner



See Also

Package Description
mysqmail-courier-logger_0.4.9-7build1_amd64.deb real-time logging system in MySQL - Courier traffic-logger
mysqmail-dovecot-logger_0.4.9-7build1_amd64.deb real-time logging system in MySQL - Dovecot traffic-logger
mysqmail-postfix-logger_0.4.9-7build1_amd64.deb real-time logging system in MySQL - Postfix traffic-logger
mysqmail-pure-ftpd-logger_0.4.9-7build1_amd64.deb real-time logging system in MySQL - Pure-FTPd traffic-logger
mysqmail_0.4.9-7build1_all.deb real-time logging system in MySQL
mythbuntu-bare-client_2.2_all.deb Mythbuntu Bare Client
mythbuntu-bare-console_2.2_all.deb Mythbuntu Bare Console
mythbuntu-common_0.67_all.deb Mythbuntu application support functions
mythbuntu-control-centre_0.63-0ubuntu2_all.deb Mythbuntu Configuration Application
mythbuntu-default-settings_1.08_all.deb default settings for Mythbuntu
mythbuntu-diskless-client_0.9-0ubuntu1_all.deb Mythbuntu-diskless client environment
mythbuntu-diskless-server-standalone_0.9-0ubuntu1_all.deb Mythbuntu-diskless server environment with DHCP server
mythbuntu-diskless-server_0.9-0ubuntu1_all.deb Basic Mythbuntu-diskless server environment
mythbuntu-gdm-theme_0.6-0ubuntu1_all.deb Mythbuntu GDM theme
mythbuntu-lightdm-theme_1.01_all.deb Mythbuntu LightDM setup