major.io words of wisdom from a systems engineer

MySQLTuner Revision 19 is available

I’ve revamped a few of the recommendations in MySQLTuner, and revision 19 is now available tonight! Here’s the main changes:

  • 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 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 You can download the latest copy on the MySQLTuner page, and you can get diffs for the new version as well.