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

Softaculous does not apper in cPanel

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

root @hostname cPanel / WHM emails are frozen

Code: 2016-08-30 02:45:48 1beNoq-0002Ca-Th <= root@myvps.myhostname.com U=root P=local...

Installing ImageMagick

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

How to Install Red5 on cPanel/WHM (CentOS) server

Installing Red5 on cPanel/WHM CentOS and RedHat Linux serversFollow the instructions and Red5...

cPanel SSH Commands List

List of commands for cPanel. Note that this is for SSH.  Restart chkservd:...