Biblioteca de cunoștințe

Optimize MySQL

Portal clienți > Biblioteca de cunoștințe > 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.
Răspunsul a fost util?
28 utilizatori au considerat informația utilă 105 Voturi

V-ar mai putea interesa și

Instalasi cPanel pada Server Centos 21980 Error shell_exec() has been disabled for security reasons 22434 Install Mod_Sec Control di cpanel 30422 EasyApache Bandwidth Module 26206 Installing mod_cloudflare on cPanel 21658