hhf/MySQLTuner-perl
1
0
Fork 0
Code Issues Pull requests Projects Releases Packages Wiki Activity Actions

Commit graph

  • a49c091457 Avoid some awk and grep invocations for portability (e.g. Windows). Ville Skyttä 2011-04-02 14:20:58 +0300
  • c88f07fa73 Grammar fix. Ville Skyttä 2011-04-01 21:17:33 +0300
  • 6da6fc937e Windows support: . different quote format for gawk and -p mysql option . /dev/null becomes NUL . force usage of --forcememe option, as we cannot find it on ourselves . put double quotes around path to mysqladmin Gaetano Giunta 2011-04-01 12:57:13 +0200
  • b5dd0397bf Trim trailing whitespace. Ville Skyttä 2011-03-08 20:38:37 +0200
  • d6c7f9ac4d Add Emacs indentation settings. Ville Skyttä 2011-03-08 20:37:58 +0200
  • a8971ea2cb Bleh mhayden 2011-03-06 19:10:39 -0600
  • 20fb6a9845 More color changes mhayden 2011-03-06 19:09:47 -0600
  • b7392f752e Changed colors a bit mhayden 2011-03-06 19:08:58 -0600
  • e4869c7554 github generated gh-pages branch Major Hayden 2011-03-06 16:53:28 -0800
  • 05813a1faa Version bump to 1.2.0 mhayden 2011-03-06 18:50:36 -0600
  • 23f582fe27 Merge branch 'master' of https://github.com/scop/MySQLTuner-perl into scop-master v1.2.0 mhayden 2011-03-06 16:34:57 -0600
  • 778cc60885 Work around MySQL bug #59393 wrt. ignore-builtin-innodb. Ville Skyttä 2011-03-06 13:04:08 +0200
  • 4df766729c Check engine availability also with SHOW ENGINES. Ville Skyttä 2011-03-06 12:59:46 +0200
  • a1d7114759 Fix detection of Federated engine availability. Ville Skyttä 2011-03-06 12:53:32 +0200
  • e8495cea28 List users without passwords as user@host, sorted. Ville Skyttä 2009-12-25 05:24:23 +0800
  • 0bd59c3330 List users without passwords as user@host, sorted. Ville Skyttä 2009-12-24 23:24:23 +0200
  • b2dfc8789a Bumped version number to 1.1.1 v1.1.1 rackerhacker 2009-09-17 23:26:12 +0000
  • f0f9f3f325 Added AIX 5L support (patch from Baptiste M. via the blog) Adjusted the version number (should have been done for the 1.1.0 tagged release) rackerhacker 2009-09-17 23:24:33 +0000
  • 32cf710293 Added in a check for users without passwords and check for slaves running with read_only disabled (patch from Isart Montane) rackerhacker 2009-09-17 23:13:22 +0000
  • 9d002146d5 Forgot to change the old assembla svn note in the script over to github. :| v1.1.0 rackerhacker 2009-09-17 22:42:53 +0000
  • 41594a5581 Added the GPLv3 license along with the script. rackerhacker 2009-09-16 03:33:28 +0000
  • 22aa240de8 Expanded README rackerhacker 2009-09-16 02:12:48 +0000
  • 25a5f310ae Test commit. rackerhacker 2009-09-16 01:43:21 +0000
  • ee9ba96d21 Added README file for github prettyness. major 2009-09-16 01:36:40 +0000
  • e29c3d342c Version bump to 1.1.0 Added git tag 'v1.1.0 major 2009-09-16 01:00:56 +0000
  • fff47e9a6f Fixed a Solaris awk bug, found a more reliable way to get the home directory, and fixed a syntactical error. (Thanks to Adam Stein) Major Hayden 2009-05-28 02:16:16 +0000
  • e425897b41 Fixed an issue where the percentage of keys pulled from memory would not exist if no keys have been read since the server started. (Thanks to Simon Greenaway) Major Hayden 2009-05-28 01:54:39 +0000
  • c4bb3c0d26 A warning is now provided if if the query_cache_size goes over 128M. (Thanks to Tim Soderstrom) Major Hayden 2009-05-28 01:50:29 +0000
  • e419c79356 Fixed an issue where null storage engines appeared when querying INFORMATION_SCHEMA. Major Hayden 2009-05-28 01:23:55 +0000
  • a2bb3ab149 Fixed an issue where MEMORY tables would appear in the fragmented table list, which caused some confusion. (Thanks to Gary Barrueto) Major Hayden 2009-05-28 00:57:31 +0000
  • 62e42e3c25 When counting index size for MyISAM tables, the INFORMATION_SCHEMA query included all engines. (Thanks to Tom Krouper) Major Hayden 2009-05-28 00:40:43 +0000
  • a462d4d01d Version bump to 1.0.0 Small spelling correction Contributors list updated Major Hayden 2008-12-01 23:37:24 +0000
  • c0ab5bc196 Version bump to 1.0.0-rc1 Fixed memory calculation problem in NetBSD where the amount of memory overflowed a 32-bit integer. Used "sysctl -n hw.physmem64" rather than "sysctl -n hw.physmem" in those situations. (Thanks to Dave Burgess) Fixed an issue where the script would suggest adding skip-isam to the MySQL configuration in 4.0.x, but the directive wasn't available until 4.1.1. (Thanks to Ryan Novosielski) Fixed an issue with MySQL 5.1 where table_open_cache needed to be adjusted, rather than open_cache. (Thanks to Michael Scheidell and Blair Christensen) Adjusted some misleading wording when MySQL's memory usage is very high relative to the amount of physical memory installed. Increased threshold to 90%. (Thanks to Hans du Plooy) Fixed an issue where MySQL logins failed when a socket was specified but a .my.cnf file was also present. (Thanks to Victor Trac) Added full support for Solaris. (Big thanks to Bill Bradford) Major Hayden 2008-11-02 18:25:55 +0000
  • e328934a19 Fixed an issue with NULL storage engines appearing on some servers. Major Hayden 2008-09-08 20:40:22 +0000
  • c8c2dd9518 Bumped version to 0.9.9 Added --socket option to use an alternative socket (thanks Mark!) Added OpenBSD memory checking support (thanks Giovanni!) Added counts to report lines to provide additional detail Fixed error where disabling BDB was recommended even when BDB tables were present (thanks Greg!) Fixed an issue with big integers (> 2^32) from key calculations (thanks Aubin!) Fixed an error on Solaris machines (thanks Bill!) Fixed an issue where the key buffer calculation caused errors when no indexes were present Added Giovanni Bechis, Greg Eden, Aubin Galinotti, Mark Imbriaco and Bill Bradford to the contributors list Major Hayden 2008-09-08 01:16:39 +0000
  • e475bfa48b Version bump to 0.9.8 Added new options to help output Made version checking off by default, enabled by --checkversion option Major Hayden 2008-07-21 16:19:50 +0000
  • ec4180839a Version bump to 0.9.5 Support is now available for remote servers Can force the script to assume that a certain amount of memory is present (thanks Jason!) Usernames and passwords can now be passed on the command line Added Jason Gill to the contributors list Major Hayden 2008-07-13 03:18:20 +0000
  • af3b70578f Version bump to 0.9.1 Added checks for fragmented tables Fixed login routine to allow zero-length passwords without re-prompting for the password repeatedly Added workaround for wget 1.11 timestamping bug Fixed a math error in the temporary table calculations Fixed an error that occurred when the status variable Open_files returned zero Added table cache change in preparation for MySQL 6.x Thanks to Ville Skytta, Trent Hornibrook and Luuk Vosslamber for the bug reports and feature requests! Major Hayden 2008-06-19 02:33:54 +0000
  • 7a154d635e Fixed an issue with table_cache in MySQL 6.x (it's now table_open_cache in MySQL 6.x) Major Hayden 2008-04-08 21:43:05 +0000
  • 59eaf76f47 Version bump to 0.9.0 Fixed a bug where NULL may appear when enumerating tables on MySQL 5 MySQLTuner now checks for updates and allows the checks to be disabled Major Hayden 2008-04-06 15:17:10 +0000
  • 6311b077cd Version bump to 0.8.9 Added an option to skip the enumeration/sizing of tables (--skipsize), which should help on servers with lots of tables Changed the table enumeration/sizing method for MySQL 5 to use information_schema (increased performance drastically) Adjusted the query_cache_limit recommendation to include the currently set value, rather than 1M each time Changed the wording for tmp_table_size/max_heap_table_size to make it less confusing Major Hayden 2008-04-05 16:34:57 +0000
  • dc73ed5328 Version bump. Added Shawn Ashlee to contributors. Major Hayden 2008-02-27 03:13:03 +0000
  • 734a8a4a2f Added lines between sections to increase readability. Corrected a bug where storage engine statuses were still in color even with --nocolor. Excluded information_schema tables from calculations (they were showing up as usual MEMORY tables). Major Hayden 2008-02-27 03:07:15 +0000
  • 2f2235fabc Bumped to version 0.8.5 Fixed copy/paste bug with OK/!!/-- output (Thanks to Nils!) Fixed a data length calculation bug in MySQL 4.0.x Fixed a key buffer calculation bug in MySQL 4.0.x Added in a notification for situations when no recommendations are available Added Nils Breunese to the contributors list Major Hayden 2008-02-11 17:53:26 +0000
  • 5e8c2311fa Corrected the total key buffer calculation when symlinks are used Went to traditional versioning scheme starting at 0.8.0 Major Hayden 2008-02-01 00:55:34 +0000
  • 9edfd8fb0f Version bump Major Hayden 2008-01-16 03:57:51 +0000
  • 218a41df8a Removing a minor left over comment Major Hayden 2008-01-16 03:54:19 +0000
  • e693649bf9 Fixed a bug in MySQL 3.23 where the storage engine checks had problems Adjusted some of the Perl code to be more compact, organized, and factored Major Hayden 2008-01-16 03:39:36 +0000
  • 9ccae41ead Fix for the bugfix in r24. Major Hayden 2008-01-15 01:38:47 +0000
  • c56383201c Version bump and tab fix Major Hayden 2008-01-15 01:30:51 +0000
  • d63d6fc23a Fixed two bugs relating to the database crawler when database names contained a hyphen. (Thanks to Mike Jackson) Major Hayden 2008-01-15 01:24:25 +0000
  • aee3d61131 Added lots of InnoDB support Flipped spaces to tabs Added more storage engine checks Adjusted output display Major Hayden 2008-01-14 00:57:46 +0000
  • bc69094412 * Added innodb_log_file_size checks * Added 32-bit/64-bit checks and warnings (maximum memory > 2GB = bad) * Fixed temporary table recommendation bug (would never recommend increase) * Fixed thread cache recommendations/warnings * Merged increase/decrease variable recommendations into one category Major Hayden 2007-12-01 22:04:00 +0000
  • 34b5cba861 * Changed indexing calculations so that all tables are not opened in MySQL 5 (thanks Jon!) * Adjusted some of the commented lines at the top of the script Major Hayden 2007-12-01 20:31:15 +0000
  • 33928700a3 * Added NetBSD support (thanks to Dave Burgess) * Switched username/password prompts to STDERR so they won't appear in printouts Major Hayden 2007-11-06 23:20:09 +0000
  • d98fa91a3d * Adjusted infoprint to use asterisks (cosmetic) * Per-thread/global buffer counts are now displayed * Key buffer increases are only recommended if the buffer is smaller than total indexes and key buffer hit rate is < 95% * Dropped max_seeks_for_key checks * Temporary table size increases are not recommended over 256M * Aborted connection calculation and recommendation adjustments Major Hayden 2007-10-16 01:45:09 +0000
  • b267fc7636 Very small bugfix for MySQL 3.23 on line 408 Major Hayden 2007-10-07 14:54:20 +0000
  • b3fd62e953 Added aborted connection checks Added % reads/writes counts Adjusted recommendations for slow query logging, max seeks per key, and joins without indexes Major Hayden 2007-09-07 00:29:18 +0000
  • 44f465ae0a Minor fix if no selects have been run (Thanks Kevin) Major Hayden 2007-08-15 12:30:08 +0000
  • efc984f945 Fixed a dumb logic error with the concurrent_insert check Major Hayden 2007-08-13 22:01:28 +0000
  • 04e84a7752 Minor divide by zero error in query cache calculations Major Hayden 2007-08-12 19:11:35 +0000
  • c6498519a5 Tremendous overhaul of massive proportions. Thanks to suggestions from Mike Jackson, BK Box, Bryan Tholen, and Shawn Ashlee. MySQLTuner's new home is now at: http://rackerhacker.com/mysqltuner/ The big feature changes will be documented there. Major Hayden 2007-08-12 18:51:10 +0000
  • 63faf9e7dc Adjusted key_buffer_size logic checks.\nChanged max_connections wording.\nAdded max_seeks_for_key check. Major Hayden 2007-08-03 02:27:37 +0000
  • 6ca1761b3f Added explanations for key max_connections and fixed a Plesk bug when you run the script as a non-root user Major Hayden 2007-08-03 01:55:56 +0000
  • 433c0b8749 Fixed bug with 'explainonly' argument. Major Hayden 2007-06-06 15:57:19 +0000
  • beaeaf26e8 Added option to disable colors. Explanation option is disabled by default. Major Hayden 2007-06-06 15:31:48 +0000
  • a4f7c5bbe0 Completed long explanation portion for slow query log section. Created 'explainonly' command line argument for long explanations only. Adjusted memory usage long explanation. Major Hayden 2007-06-06 15:14:06 +0000
  • be69a0063a Initial verbose explain output configuration (there you go Mike!) Major Hayden 2007-06-04 16:31:29 +0000
  • 4589601af0 Massive changes... output filtering, usage information, and temporary table corrections with regards to max memory calculations Major Hayden 2007-06-01 03:26:26 +0000
  • 89044755e1 Changed all prints to use subroutines to allow for exclusions via command line arguments (coming up next) Major Hayden 2007-06-01 01:27:18 +0000
  • f76e2746a4 Script now requires MySQL 4.1 or higher (4.0 is EOL, and support for that is lame...) Major Hayden 2007-06-01 01:19:01 +0000
  • 270bb7364f Corrected memory calculation issue in OS X / Darwin Major Hayden 2007-06-01 01:13:36 +0000
  • 810df8eded Added check to see if MySQL is even installed Major Hayden 2007-06-01 01:03:11 +0000
  • d38d22a80a Initial Import Major Hayden 2007-05-31 03:30:15 +0000