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
  • Email, SSL
  • 6 Users Found This Useful
Was this answer helpful?

Related Articles

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

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,

Softaculous does not apper in cPanel

Softaculous is the great feature available in Cpanel which has replaced with Fantastico. It...

Uninstall Apache service

CentOS Uninstall Apache service Type the following command to remove all httpd* and...

Installing ImageMagick

This is a quick howto on installing ImageMagick on a CPanel Server using the CPanel provided...