Base de connaissances

Optimize MySQL

Accueil > Base de connaissances > cPanel > 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.
Cette réponse était-elle pertinente?
28 Utilisateurs l'ont trouvée utile 105 Votes

Consultez aussi

Instalasi cPanel pada Server Centos 21980 Error shell_exec() has been disabled for security reasons 22478 Install Mod_Sec Control di cpanel 30477 EasyApache Bandwidth Module 26251 Installing mod_cloudflare on cPanel 21690