lp:~gnarvaja/mysqltuner/sarsql-dev

Created by seattlegaucho on 2009-12-17 and last modified on 2009-12-17
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

Owner:
seattlegaucho
Project:
mysqltuner
Status:
Merged

Recent revisions

13. By Sheeri K. Cabral on 2009-12-03

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

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

tuner-default.cnf:
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 on 2009-12-03

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 on 2009-12-02

mysqltuner.pl:
changed the split character to |||

tuner-default.cnf
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):
  query_cache_size
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
 tmp_table_size
 max_heap_table_size
 slow_launch_time
 Max_used_connections
 max_connections
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 on 2009-12-02

got rid of goodprint, badprint, infoprint

9. By Sheeri K. Cabral on 2009-11-28

tuner-default.cnf:
- 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 on 2009-11-27

mysqltuner.pl:
- 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.

tuner-default.cnf:
- Connections
- Bytes sent
- Bytes received

7. By Sheeri K. Cabral on 2009-11-27

mysqltuner.pl:
changed the rounding function to account for scientific notation

tuner-default.cnf:
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
uptime
pretty uptime

6. By U-BOSCABRAL\cabral <cabral@BOSCABRAL> on 2009-11-27

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> on 2009-11-27

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

4. By Sheeri K. Cabral on 2009-11-15

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.

Subscribers