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.

Was this answer helpful?

 Print this Article

Also Read

Install mod_pagespeed module cPanel

A custom module for CPanel WHM using CPanel Easy Framework - allows easy installation of...

EasyApache Bandwidth Module

The module used for limiting bandwidth usage differs depending on the branch of apache you are...

Clear EXIM Logs

Jika mendapatkan log EXIM yang cukup besar bisa menggunakan perintah berikut untuk...

How to Install mod_geoIP for cPanel

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

Mysqldump dengan PHP

Berikut ini script untuk membuat backup database dengan mysqldump pada script php  ...

Powered by WHMCompleteSolution