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

Related Articles

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

CSF Blocking Gmail SMTP email sending

Problem:Your VPS server or scripts are configured to send email using GMail's SMTP but emails are...

Uninstall Apache service

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

Softaculous does not apper in cPanel

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

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