Reclaim storage occupied by dead rows.
Only engines that keep old row versions need this, which is why MySQL has no VACUUM: InnoDB reclaims space through its own purge threads, and the closest deliberate equivalent is OPTIMIZE TABLE.
VACUUM
OPTIMIZE TABLE
Reclaim storage occupied by dead rows.
Only engines that keep old row versions need this, which is why MySQL has no
VACUUM: InnoDB reclaims space through its own purge threads, and the closest deliberate equivalent isOPTIMIZE TABLE.