Created by seattlegaucho and last modified
Get this branch:
bzr branch lp:~gnarvaja/mysqltuner/sarsql-dev
Only seattlegaucho can upload to this branch. If you are seattlegaucho please log in for upload directions.

Branch merges

Related bugs

Related blueprints

Branch information


Recent revisions

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

8. By Sheeri K. Cabral

- changed B,M,K to Billion, Million, Thousand
- changed G,M,K to Gb, Mb, Kb
- added hr_bytime subroutine, which takes in a number that is a rate per second, and outputs a human-readable value. Fo
r example, 0.01 queries per second is hard to comprehend, but it's the same as 36 times per hour.
- took the rounding function out into the round2 subroutine, so it could be used in the hr_bytime subroutine.

- Connections
- Bytes sent
- Bytes received

7. By Sheeri K. Cabral

changed the rounding function to account for scientific notation

added query cache low memory prunes
added % query cache used
added total sorts
added % sorts that cause temporary table
Joins without indexes
Joins without indexes per day
% temp disk tables
% table cache hit rate
% open files
Immediate table locks %
Thread cache hit rate
% aborted connections
% reads
% writes
% innoDB log size
queries per second
pretty uptime

6. By U-BOSCABRAL\cabral <cabral@BOSCABRAL>

added filelist to the help and fixed it so the proper error occurs if there's no local connection possible.

5. By U-BOSCABRAL\cabral <cabral@BOSCABRAL>

added some more defaults, and a rounding algorithm that rounds numbers (except versions) to 2 decimal places.

4. By Sheeri K. Cabral

adding help

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.