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

How to transfer cPanel accounts from one server to another cPanel server

The server we are transferring the accounts from : OLD SERVERThe server to are transferring...

Install Nginx RTMP Ubuntu

Nginx RTMP Protocol Nginx-RTMP is an open source extension module for the Nginx web server that...

Disk usage problem: WHM is showing incorrect disk usage and cpanel also

The problem happens when the disk quota file get corrupted on server. You can run the following...

MySQL Optimization cPanel

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

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