Login to your system ssh with root
1: Move the old version of mysqltuner.pl
mv /usr/local/cpanel/3rdparty/bin/mysqltuner.pl /usr/local/cpanel/3rdparty/bin/mysqltuner.pl.old
2: Create a new file with nano
nano /usr/local/cpanel/3rdparty/bin/mysqltuner.pl
Copy the newest version from github direct link paste it in the file and save.
3: Change permission
chmod 755 /usr/local/cpanel/3rdparty/bin/mysqltuner.pl
Congratulations you now have the latest version of mysqltuner.pl
MySQLTuner-perl
MySQLTuner is a script written in Perl that allows you to review a MySQL installation quickly and make adjustments to increase performance and stability. The current configuration variables and status data is retrieved and presented in a brief format along with some basic performance suggestions.
Compatibility: As of 2/31/2014
- 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)
- MariaDB 10.x (partial support)
- Perl 5.6 or later (with perl-doc package)
- 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)
WARNING
It is extremely important for you to fully understand each change you make to a MySQL database server. If you don’t understand portions of the script’s output, or if you don’t understand the recommendations, you should consult a knowledgeable DBA or system administrator that you trust. Always test your changes on staging environments, and always keep in mind that improvements in one area can negatively affect MySQL in other areas.
Please review the FAQ section below.
Question: Will MySQLTuner fix my slow MySQL server?
No. MySQLTuner is a read only script. It won’t write to any configuration files, change the status of any daemons, or call your mother to wish her a happy birthday. It will give you an overview of your server’s performance and make some basic recommendations about improvements that you can make after it completes. Make sure you read the warning above prior to following any recommendations.
You can also run MySQL Performance Tuning Primer Script from www.day32.com this will help with tuning your my.cnf file “If the site is down use this link to wget the script http://enterprisevpssolutions.com/scripts/tuning-primer.sh
wget the file in /usr/local/cpanel/3rdparty/bin/ folder once its their you will need to run this command
chmod 755 /usr/local/cpanel/3rdparty/bin/tuning-primer.sh
Congratulations you now have the installed tuning-primer.sh
