Prepare to OPTIMIZE MySQL tables

Prepare to OPTIMIZE MySQL tables

1. Check current defrag status:
SQL> select table_name,round(data_length/1024/1024) as data_length_mb, round(data_free/1024/1024) as data_free_mb  from information_schema.tables order by data_free_mb;

2. Optimize one table or multi:
SQL> OPTIMIZE TABLE your_table_name;
SQL> OPTIMIZE TABLE your_table_name1, your_table_name2, your_table_name3;

(or)
Optimize all of your tables in "your_database":
(from bash, not in mysql client bash)
# mysqlcheck -o your_database -u your_user -pYOUR_PASSWORD

(or even)
Optimize all of your databases:
# mysqlcheck -o --all-databases -u your_user -pYOUR_PASSWORD