How to update mysqltuner.pl to latest version on cpanel

Enterprisevpssolutions

Article Submitter
Verified Provider
Login to your cpanel system ssh with root you can also update this on a linux system just do a updatedb first and locate your mysqltuner.pl

 

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 or another editor that you prefer.

 

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.

 

Also if you need another tuning program with a little more information try out Tuning Primer Script from www.day32.com

 


wget the file in /usr/local/cpanel/3rdparty/bin/ folder once its their you will need to change permission using this command

 

chmod 755 /usr/local/cpanel/3rdparty/bin/tuning-primer.sh


 

Congratulations you now have the installed tuning-primer.sh

 

Have fun and remember you will still need a db admin don't fire him yet.  B)
 
Top