Created by Sheeri K. Cabral and last modified
Get this branch:
bzr branch lp:mysqltuner
Members of MySQL Tuner developers can upload to this branch. Log in for directions.

Branch merges

Related bugs

Related blueprints

Branch information

MySQL Tuner developers

Recent revisions

18. By Sheeri K. Cabral

release 18

17. By Sheeri K. Cabral

Mar 2 2010:
corrected the versions for SHOW GLOBAL STATUS and SHOW GLOBAL VARIABLES
Fixes https://bugs.launchpad.net/mysqltuner/+bug/530285

added tuner-default_pre_5_1.cnf
changed tuner-default.cnf to not have table_cache
These are workarounds for https://bugs.launchpad.net/mysqltuner/+bug/530456

16. By Sheeri K. Cabral

Feb 25 2010:
took out the invalid reference to the print_all() function
error for not using forcemem when a host is specified is no longer thrown if the host specified is

Now checks for both table_cache and table_open_cache, specifying that the former is pre 5.1

15. By Sheeri K. Cabral

gave executable permissions to mysqltuner.pl

14. By Sheeri K. Cabral

Feb 11 2010:
Changed query cache lowmem prunes per day to a straight low memory prunes by time check
Added query cache minimum result size - warn if it's set to the default
Added rate of creating temporary disk tables (previously had only %)
Added rate of creating temporary tables (memory or disk)
Added table cache size to the output

13. By Sheeri K. Cabral

Changed the "matches" line to only print in debug mode
Added documentation for the --recommend and --output flags

Added documentation for the --recommend and --output flags

Changed the have_innodb check threshold from eq "NO" to ne "YES" because if the value is DISABLED the check should match.

12. By Sheeri K. Cabral

Added a README
Change mysqltuner.pl so that if it cannot read a file in the list, it exits (it used to just continue, printing an error).

11. By Sheeri K. Cabral

changed the split character to |||

changed the split character to |||
Changed the following to use readable byte-numbers (ie, anything >1024 bytes is in Kb, similar for Mb and Gb):
Changed the label for query_cache_size from "Query cache" to "Query cache size"
Changed the label of "InnoDB" to "Is InnoDB enabled?"
Changed thread cache hit rate to complain if Threads_created/Connections >20 (was <20, but < is a better hit rate)
Separated out Sorts, Joins/scans and temporary table sections
Fixed the threshold for MyISAM concurrent inserts - old test was "0", new test is "=0"Added the following variable printouts:
 sort_buffer_size printout
 read_rnd_buffer_size printout
Added the following checks:
 rate of sorted rows
 rate of reading first index entry
 rate of reading fixed position
 rate of reading next table row
 rate of joins without indexes (removed Joins w/out indexes, Joins w/out indexes per day)
 MyISAM key buffer size
 max % MyISAM key buffer ever used
 rate of table open
 Table lock wait rate
 Total threads created
 Threads that are slow to launch
 % aborted clients

10. By Sheeri K. Cabral

got rid of goodprint, badprint, infoprint

9. By Sheeri K. Cabral

- added long_query_time
- added slow query log is enabled
- added % connections used
- added thread_cache existence
- changing thresholds for several checks (the ones that were >=0 before)
- added concurrent_insert

Branch metadata

Branch format:
Branch format 6
Repository format:
Bazaar pack repository format 1 (needs bzr 0.92)
This branch contains Public information 
Everyone can see this information.