Run OPTIMIZE TABLE to defragment tables for better performance

For this suggestion:

Run OPTIMIZE TABLE to defragment tables for better performance

Run this command:

Code:
mysqlcheck -u root --auto-repair --optimize --all-databases

You can usually fix the table by issuing:

Code:
mysqlcheck -A -r -p

Restart MYSQL Server:
/etc/init.d/mysql restart

Was this answer helpful?

 Print this Article

Also Read

How to restart cron daemon

You have to do it from root shell via SSH using the command:/etc/init.d/crond restart

cPanel License Update

Login to root via SSH and run:/usr/local/cpanel/cpkeyclt

How to fix ini_set() has been disabled for security reasons

1. Create php.ini file inside your public_html folder, OR the folder in which you have...

How to fix: Getting an SMTP 451 error when trying to send out email

Getting an SMTP error 451 Temporary local problem - please try later error when trying to send...

AryanIct.com standard Domain Name Server Resolvers

If you get an error about not being able to resolve the host, you need to edit your...