Optimize MySQL

You could try running the following script to see the recommendations it provides:

Code:
/usr/local/cpanel/3rdparty/mysqltuner/mysqltuner.pl
You need to modify your /etc/my.cnf according to the mysqltuner results.

Next, you can optimize all databases with this command:

Code:
mysqlcheck --auto-repair --check --optimize --all-databases
Restart MySQL after you've done the above:

Code:
/etc/init.d/mysql restart
Please wait 24 hours and then re-run mysqltuner.pl again on the machine to see any other variable changes to make.
  • Email, SSL
  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

Install Softaculous di cPanel

Sebelum melakukan install, pastikan ioncube terinstall pada server.Perintah instalasi: wget -N...

Convert Database ENGINE from InnoDB to MyISAM

Gunakan scrip PHP di bawah ini untuk mengubah database ENGINE dari InnoDB ke MyISAM  ...

Mail Security Tweaks

Cek lokasi pengiriman email terbanyak grep cwd /var/log/exim_mainlog | grep -v /var/spool | awk...

How to create backup Account via SSH?

Step 1: Log-in to the SSH as Root user. Step 2: Enter the following command string on the...

How to Install mod_geoIP for cPanel

Please do the following steps: # cd /var/cpanel/easy/apache/custom_opt_mods # wget...