How to run the MySql performance tuning script for the cPanel server?

Follow below steps and run the mysql performance tuning script on your cPanel server -

1. cd /usr/local/src
2. wget http://cpanelkb.net/download/cpanel-mysql-tuning.sh
3. chmod 755 cpanel-mysql-tuning.sh
4. ./cpanel-mysql-tuning.sh

1. Make a copy of my.cnf file before you make any changes -
    cd /etc
    cp my.cnf my.cnf_bk
2. Edit my.cnf with your favorite editor - vi my.cnf
3. Add the variables to my.cnf file as per the mysql script recommendations.
4. 
Finally, restart mysql service - service mysql restart

You will observe a great performance on the server.

  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

mod_security rule [Id '-1'] triggered! ModSecurity: Access denied with code 403

While updating the contents in any of the CMS, I was getting a 403 error on the Litespeed server....

SSL Installation error -directive missing closing '>'

While installing the SSL on domain from WHM >> SSL/TLS >> Install an SSL Certificate...

#145 - Table './database_name/table_name' is marked as crashed and should be repair

I was getting below error while accessing one site - Error in establishing database...

The MySQL server is currently offline. Mysql::initcache() failed: The mysql server is offline.

I was getting below error while accessing MySQL Databases from cPanel though MySQL service was...

Powered by WHMCompleteSolution