~gnarvaja/mysqltuner/sarsql-dev : changes

~gnarvaja/mysqltuner/sarsql-dev » Changes from revision 13

From Revision 13

Rev	Summary	Authors	Date
13	mysqltuner.pl: 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.	Sheeri K. Cabral	15 years ago
12	Added a README 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).	Sheeri K. Cabral	15 years ago
11	mysqltuner.pl: 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	Sheeri K. Cabral	15 years ago
10	got rid of goodprint, badprint, infoprint got rid of goodprint, badprint, infoprint	Sheeri K. Cabral	15 years ago
9	tuner-default.cnf: 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	awfief at gmail	15 years ago
8	mysqltuner.pl: 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	awfief at gmail	15 years ago
7	mysqltuner.pl: 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	awfief at gmail	15 years ago
6	added filelist to the help and fixed it so the proper error ... added filelist to the help and fixed it so the proper error occurs if there's no local connection possible.	U-BOSCABRAL\cabral	15 years ago
5	added some more defaults, and a rounding algorithm that roun... added some more defaults, and a rounding algorithm that rounds numbers (except versions) to 2 decimal places. -Sheeri	U-BOSCABRAL\cabral	15 years ago
4	adding help adding help	Sheeri K. Cabral	15 years ago
3	added more tuner defaults, fixed some minor stuff in the myq... added more tuner defaults, fixed some minor stuff in the myqsltuner.pl file	Sheeri K. Cabral	15 years ago
2	Adding launchpad info into the header Adding launchpad info into the header	Gerry	15 years ago
1	adding to bzr tree adding to bzr tree	Sheeri K. Cabral	15 years ago