Skip to main content

[Case # 90317] - Warning on using mysqltuner and MySQL 5.6!

cPanelPeter cPanel Staff
Hello, We get a number of requests for MySQL optimization and/or tuning. Many people use the mysqltuner.pl script to help them in doing so. One of our analysts (cPanelKaden) recently did some research and discovered that mysqltuner doesn't fully support any MySQL versions past 5.1. From the README file: [quote] Compatibility: * MySQL 3.23, 4.0, 4.1, 5.0, 5.1 (full support) * MySQL 5.4 (not fully tested, partially supported) * MySQL 6.0 (partial support) * Perl 5.6 or later * Unix/Linux based operating system (tested on Linux, BSD variants, and Solaris variants) * Windows is not supported at this time * Unrestricted read access to the MySQL server (OS root access recommended for MySQL < 5.0)
The last time that mysqltuner.pl script was updated no their github site was 3 years ago. If you are running mysqltuner.pl on MySQL 5.6, then it will make recommendations that no longer exist on 5.6. This will in turn break your MySQL so that it won't even start. It's highly recommended that you do not use mysqltuner.pl any longer in order to optimize/tune your MySQL configuration. Case # 90317 has been created as of today to remove mysqltuner.pl from cPanel distribution. This of course does not stop someone from downloading mysqltuner from their website and running it.

Comments

9 comments

Date Votes
  • kernow
    Thanks for the info. What recommendations that no longer exist on 5.6 does it make? Do you know if there is a simular problem using tuning-primer.sh ? EDIT Looks like tuning-primer is OK with 5.6
    0
  • eva2000
    Well mysqltuner has never really been updated beyond MySQL 5.1 and it's recommendations have never 100% been correct. My mysqlmymonlite.sh script uses a modified version of mysqltuner and it works fine with MariaDB 5.5. But some issues it seems recognising MariaDB 10.0.7 (MySQL 5.6 version of MariaDB). mysqltuner thinks i am on MySQL 4.x hehe. [!!] Your MySQL version 10.0.7-MariaDB is EOL software! Upgrade soon!
    /root/tools/mysqlmymonlite.sh mysqltuner ------------------------------------------------------------- System MySQL monitoring stats mysqlmymonlite.sh - 0.5.2 mysqlmymon.com compiled by George Liu (eva2000) vbtechsupport.com ------------------------------------------------------------- Report Generated: Mon Feb 10 13:03:11 EST 2014 ------------------------------------------------- mysqltuner output ------------------------------------------------- >> MySQLTuner 1.2.1 mod - Major Hayden >> Bug reports, feature requests, and downloads at
    0
  • kernow
    It should also be noted that with Mysql 5.6 the default storage engine is InnoDB [url=http://dev.mysql.com/doc/refman/5.5/en/innodb-default-se.html]MySQL :: MySQL 5.5 Reference Manual :: 14.3.1.2 InnoDB as the Default MySQL Storage Engine unless you specify otherwise in my.cnf And if you upgrade to 5.6 remember if your my.cnf says; table_cache (value) change it to read : table_open_cache Otherwise mysql will fail to start!!!! :eek:
    0
  • eva2000
    FYI, mysqltuner.pl 1.3 is out with MySQL 5.6 and MariaDB 10 support only partial support for new versions as version checking was temporarily removed
    0
  • kernow
    Ummm.... I don't see support for MySQL 5.6 listed?
    0
  • eva2000
    it's just detection support as they removed the version checking temporarily and fixed some variables for mysql 5.5 and 5.6+
    0
  • kernow
    Oh I see. Been using tuning-primer.sh instead, which does support current MySQL version and has the edge me thinks..........
    0
  • Palsman
    So what server admin or cPanel recommend to do Mysql optimization? Can you please help us? Regards,
    0
  • cPanelMichael
    Hello :) You may find this thread helpful: mysqlmymonlite.sh server stats gathering tool for cPanel Server Thank you.
    0

Please sign in to leave a comment.

Didn't find what you were looking for?

New post