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 edit cpanel crontab

You have to do it from root shell via SSH using the command:crontab -eThis will throw you into an...

Removing ACL List from WHM

If you need to remove some ACLs/lists from the dropdown that you have already created.Open a SSH...

MySQL Optimization cPanel

The best way to get optimization recommendations for your specific hardware resources and...

Scanning for Rootkits with chkrootkit

Up-to-date and secure installations, firewalls, limited ssh access and strong passwords are all...

How To Install and Configure an OpenVPN Access Server on CentOS 6.5

VPN, or virtual private network, is a secure method of connecting remote internet resources...