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

Cpanel / SuPHP – chmod All Files 644, All folders 755

When switching from DSO to SUPHP in cpanel (a must for anyone who takes security seriously on a...

How to restart cron daemon

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

Server email problem not receiving error log {perl{enforce_mail_permissions}}}}}}

/etc/exim.pl had 000 for permissions thus exim was not able to access that file. Change it to 644,

What does "406 Not Acceptable" mean?

Most likely, you are reading this article because you received an "Access Denied" error or a "406...

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