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.

Was this answer helpful?

 Print this Article

Also Read

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....

Is it possible to add multiple backup destinations on the cPanel server?

Is it possible to add multiple backup destinations on the cPanel server?Solution :- Yes, its...

Fatal error: Call to undefined function utf8_substr()

While accessing Opencart site, I was getting error as 'Fatal error: Call to undefined function...

#1227 - Access denied; you need (at least one of) the SUPER privilege(s) for this operation

While running one query from cPanel >> PhpMyAdmin, I was getting this error message -#1227...

Failed to send your message. Please try later or contact the administrator by another method - WordPress Contact Form is not working

While sending email from WordPress's contact form, I was getting below error -Failed to send your...

Powered by WHMCompleteSolution