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.

  • mysql performance check, mysql, mysql server optimization
  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

How to access server via Remote Desktop (RDP)?

Remote Desktop Protocol (RDP) is a proprietary protocol developed by Microsoft, which provides a...

How to install Let’s Encrypt on CentOS 7 with Apache?

Today, we will show you, How to install Let’s Encrypt on CentOS 7 with Apache. Let’s Encrypt is a...

Domains are not showing in WHM -> List accounts

We were unable to see any domains listed under WHM -> List Accounts. However, we can see the...

HOW TO INSTALL LITESPEED WEB SERVER IN LINUX SERVER?

Litespeed Cache is useful to increase high performance for your Wordpress Website. Following are...

Remove ONLY_FULL_GROUP_BY in my.cnf file

Remove ONLY_FULL_GROUP_BY in my.cnf file First you need to find my.cnf file location and then...