Optimize MySQL

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

You need to modify your /etc/my.cnf according to the mysqltuner results.

Next, you can optimize all databases with this command:

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

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

Was this answer helpful?

 Print this Article

Also Read

Installing mod_cloudflare on cPanel

You can install mod_cloudflare on your cPanel server by running the following command:sudo perl...

Install Clamav cPanel Command Line

Berikut perintah untuk install clamav tanpa harus login ke WHM...

Install Mod_Sec Control di cpanel

1. install ConfigServer ModSecurity Control (cmc) http://www.configserver.com/cp/cmc.html untuk...

Instalasi cPanel pada Server Centos

Langkah-langkah yang harus disiapkan. 1.Pastikan anda memiliki koneksi Internet yang stabil...

How to Install mod_geoIP for cPanel

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

Powered by WHMCompleteSolution