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

Fixed:”Function set_magic_quotes_runtime() is deprecated in PHP 5.3.0”

Problem with set_magic_quotes on Application with Code Igniter. The problem is “Function...

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

You have a local DNS server running but do not appear to have any recursion restrictions set

You have a local DNS server running but do not appear to have any recursion restrictions set....

Magento install error - Exception printing is disabled

Here is a known error which can occur when installing Magento: There has been an error...

cPane / WHM: Security Advisor - Current kernel version does not match the kernel version for boot

Try to reinstall the latest kernal sometimes on CloudLinux initrd img is missing.yum reinstall...