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

Unable to perform operation. No free disk space.

I'm getting this error when I tried to send an email from webmail:Unable to perform operation....

How to resolve the 404 error message on the website with the temporary URL?

To access website while developing we often need to see how it looks, there is an option...

How to check the PHP version and configuration for your website?

'phpinfo.php' is the file which is used for checking the PHP version and configuration on cPanel...

Database connection error (2): Could not connect to MySQL- Joomla Issue

While accessing the Joomla site I was getting the error as "Database connection error (2): Could...

How to exclude file/folder from backup (pkgacct) on cPanel server?

Is it possible to exlude file/folder from the full cPanel backup on cPanel server? Solution :-...

Powered by WHMCompleteSolution