lp:~gnarvaja/mysqltuner/sarsql-dev

Branch merges

Propose for merging

No branches dependent on this one.

Related source package recipes

No recipes using this branch. (?)

Create packaging recipe

Related snap packages

Related bugs

Related blueprints

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