Commits on Sep 8, 2008
  1. @major
  2. @major

    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 committed Sep 8, 2008
Commits on Jul 21, 2008
  1. @major

    Version bump to 0.9.8

    Added new options to help output
    Made version checking off by default, enabled by --checkversion option
    major committed Jul 21, 2008
Commits on Jul 13, 2008
  1. @major

    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 committed Jul 13, 2008
Commits on Jun 19, 2008
  1. @major

    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 committed Jun 19, 2008
Commits on Apr 8, 2008
  1. @major
Commits on Apr 6, 2008
  1. @major

    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 committed Apr 6, 2008
Commits on Apr 5, 2008
  1. @major

    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 committed Apr 5, 2008
Commits on Feb 27, 2008
  1. @major

    Version bump.

    Added Shawn Ashlee to contributors.
    major committed Feb 27, 2008
  2. @major

    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 committed Feb 27, 2008
Commits on Feb 11, 2008
  1. @major

    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 committed Feb 11, 2008
Commits on Feb 1, 2008
  1. @major

    Corrected the total key buffer calculation when symlinks are used

    Went to traditional versioning scheme starting at 0.8.0
    major committed Feb 1, 2008
Commits on Jan 16, 2008
  1. @major

    Version bump

    major committed Jan 16, 2008
  2. @major

    Removing a minor left over comment

    major committed Jan 16, 2008
  3. @major

    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 committed Jan 16, 2008
Commits on Jan 15, 2008
  1. @major

    Fix for the bugfix in r24.

    major committed Jan 15, 2008
  2. @major

    Version bump and tab fix

    major committed Jan 15, 2008
  3. @major

    Fixed two bugs relating to the database crawler when database names c…

    …ontained a hyphen. (Thanks to Mike
    major committed Jan 15, 2008
Commits on Jan 14, 2008
  1. @major

    Added lots of InnoDB support

    Flipped spaces to tabs
    Added more storage engine checks
    Adjusted output display
    major committed Jan 14, 2008
Commits on Dec 1, 2007
  1. @major

    * 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 committed Dec 1, 2007
  2. @major

    * 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 committed Dec 1, 2007
Commits on Nov 6, 2007
  1. @major

    * Added NetBSD support (thanks to Dave Burgess)

    * Switched username/password prompts to STDERR so they won't appear in printouts
    major committed Nov 6, 2007
Commits on Oct 16, 2007
  1. @major

    * 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 committed Oct 16, 2007
Commits on Oct 7, 2007
  1. @major
Commits on Sep 7, 2007
  1. @major

    Added aborted connection checks

    Added % reads/writes counts
    Adjusted recommendations for slow query logging, max seeks per key, and joins without indexes
    major committed Sep 7, 2007
Commits on Aug 15, 2007
  1. @major
Commits on Aug 13, 2007
  1. @major
Commits on Aug 12, 2007
  1. @major
  2. @major

    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:
    The big feature changes will be documented there.
    major committed Aug 12, 2007
Commits on Aug 3, 2007
  1. @major

    Adjusted key_buffer_size logic checks.\nChanged max_connections wordi…

    …ng.\nAdded max_seeks_for_key check.
    major committed Aug 3, 2007
  2. @major

    Added explanations for key max_connections and fixed a Plesk bug when…

    … you run the script as a non-root user
    major committed Aug 3, 2007
Commits on Jun 6, 2007
  1. @major
  2. @major

    Added option to disable colors.

    Explanation option is disabled by default.
    major committed Jun 6, 2007
  3. @major

    Completed long explanation portion for slow query log section.

    Created 'explainonly' command line argument for long explanations only.
    Adjusted memory usage long explanation.
    major committed Jun 6, 2007
Commits on Jun 4, 2007
  1. @major