Today we’ll update MySQLTuner in cwp centos web panel to latest possible version with this easy updating guide. Just follow the below steps and you’re running latest version. First a short introduction to MySQLTuner :
MySQLTuner is a script written in Perl that will assist you with your MySQL configuration and make recommendations for increased performance and stability. Running MySQL at optimal settings for specific resources helps handle larger server loads and prevents server slowdown.
To update Follow this easy steps :
STEP 1 :
Backup current cwp provided MySQLTuner :
Backup the files (backups will be in
rsync -av /usr/local/cwpsrv/htdocs/resources/conf/mysqltunner/ /root/mysqltunner/
after backing up Then remove the current files :
cd /usr/local/cwpsrv/htdocs/resources/conf/mysqltunner rm -rf basic_passwords.txt mysqltuner.pl vulnerabilities.csv
Now we’ll download the updated version of MySQLTuner :
STEP 2 :
cd /usr/local/cwpsrv/htdocs/resources/conf/mysqltunner wget --no-cache https://raw.githubusercontent.com/major/MySQLTuner-perl/master/mysqltuner.pl wget --no-cache https://raw.githubusercontent.com/major/MySQLTuner-perl/master/vulnerabilities.csv wget --no-cache https://raw.githubusercontent.com/major/MySQLTuner-perl/master/basic_passwords.txt
Done you’ve successfully updated MySQLTuner in CWP.
You can run this comamnd to run and check version of MySQLTuner :