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, mysql server optimization
  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

How to configure your domain email on Gmail app ?

Log in to cPanel using your username and your cPanel password at http://yourdomain.com/cpanel,...

How to Connect to the MYSQL Database Remotely?

Allowing remote MYSQL connections is often done to enable a program on your personal computer to...

How to disable mod security using htaccess file?

Mod_security is an apache module that helps to protect your website from various attacks.It is...

Prevent Brute Force Attacks in WordPress

A brute force attack is a trial-and-error method in which the hackers aim to gain access to a...

How to fix failed to retrieve directory listing error in FileZilla FTP?

When using FileZilla to connect to your FTP if you encounter an error like this: Status:...