From Free Software Directory
Jump to: navigation, search


high-performance MySQL tuning script

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 reviewed. * 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 variables. * 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 suggestions. * Open Files: Determines if the server will approach or run into the open file limit set by the operating system or the MySQL server itself. * 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.



Verified by

Verified on


Verified by

Debian: KURASHIKI Satoru <>

Verified on

22 October 2014


License: gpl-3.0+

Leaders and contributors

Resources and communication

AudienceResource typeURI
Debian (Ref)

Software prerequisites


"Debian (Ref)" is not in the list (General, Help, Bug Tracking, Support, Developer) of allowed values for the "Resource audience" property.

Date 2015-07-17
Source Debian
Source link


Permission is granted to copy, distribute and/or modify this document under the terms of the GNU Free Documentation License, Version 1.3 or any later version published by the Free Software Foundation; with no Invariant Sections, no Front-Cover Texts, and no Back-Cover Texts. A copy of the license is included in the page “GNU Free Documentation License”.

The copyright and license notices on this page only apply to the text on this page. Any software or copyright-licenses or other similar notices described in this text has its own copyright notice and license, which can usually be found in the distribution or license text itself.