MySQL Tuning Primer Script

Registered 2008-06-20 by TodoInTX

This script takes information from "SHOW STATUS LIKE..." and "SHOW VARIABLES LIKE..." then attempts to produce sane recommendations for tuning server variables. It is compatible with all versions of MySQL 3.23 and above.

Currently the script handles recommendations for the following:
Slow Query Log
Max Connections
Worker Threads
Memory Usage
Key Buffer
Query Cache
Sort Buffer
Joins
Temp Tables
Table (Open & Definition) Cache
Table Scans (read_buffer)
Table Locking
Innodb Status

Project information

Part of:
MySQL
Maintainer:
TodoInTX
Driver:
TodoInTX
Development focus:

trunk series 

lp:mysql-tuning-primer 
Browse the code

Programming Languages:
GNU bash
Licences:
GNU GPL v2
()

RDF metadata

View full history Series and milestones

MySQL Tuning Primer Script trunk series is the current focus of development

Downloads

Latest version is 1.6-r1
released on 2011-08-06

All downloads

Announcements