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

How to Specify the exact time to run a backup on cPanel server?

How to Specify the exact time (hour) to run a backup on cPanel server? Solution :- By default,...

Can't find disk space in /home directory on the cPanel server.

Before transferring a website from one server to another, I checked disk space of website using...

A fatal error has occurred Cannot write to cache directory /tmp

While accessing WebMail client I was getting an error as below - A fatal error has occurred...

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

sendmail cannot be called directly from a shell with the current user id

While sending email using sendmail scirpt, I was getting the error message as - sendmail:...

Powered by WHMCompleteSolution