To optimized the tables and gain the disk space
- Navigate to the $SPECROOT/mysql/bin directory
Type the following: ./mysqlcheck -uroot -proot -o reporting
Let this run to completion.
If you see any errors like this:"The storage engine for the table doesn't support optimize", it can be safely ignored. When complete, verify disk space has been regained.