~mysqltuner-dev/mysqltuner/devel : changes

~mysqltuner-dev/mysqltuner/devel » Changes from revision 18

From Revision 18

Rev	Summary	Authors	Date
18	release 18 release 18	Sheeri K. Cabral	14 years ago
17	Mar 2 2010: Mar 2 2010: mysqltuner.pl 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	Sheeri K. Cabral	14 years ago
16	Feb 25 2010: Feb 25 2010: mysqltuner.pl: 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 127.0.0.1 tuner-default.cnf: Now checks for both table_cache and table_open_cache, specifying that the former is pre 5.1	Sheeri K. Cabral	14 years ago
15	gave executable permissions to mysqltuner.pl gave executable permissions to mysqltuner.pl	Sheeri K. Cabral	14 years ago
14	Feb 11 2010: Feb 11 2010: tuner-default.cnf: 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	Sheeri K. Cabral	14 years ago
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	14 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	14 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	14 years ago
10	got rid of goodprint, badprint, infoprint got rid of goodprint, badprint, infoprint	Sheeri K. Cabral	14 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	14 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	14 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	14 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	14 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	14 years ago
4	adding help adding help	Sheeri K. Cabral	14 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	14 years ago
2	Adding launchpad info into the header Adding launchpad info into the header	Gerry	14 years ago
1	adding to bzr tree adding to bzr tree	Sheeri K. Cabral	14 years ago