Compacting MYSQL

DB’s with lots of activity should be
optimized regularly. Doing so is easy.

LOCK TABLES tablename READ;

CHECK TABLE affils;

UNLOCK TABLES;

OPTIMIZE TABLE tablename;

Source: http://bytes.com/topic/mysql/answers/75718-compacting-mysql