OPTIMIZE TABLE
CautionRebuild/defragment tables
OPTIMIZE TABLE <table>;
Reclaims space after mass deletes; on InnoDB it's a rebuild — schedule it, it locks and takes time.
Examples
OPTIMIZE TABLE session_log;Rebuild a bloated table
Syntax
OPTIMIZE TABLE t;(MySQL)
Before you run it
Locks and load during the rebuild.
Related commands
- VACUUMVacuum (PostgreSQL)
- ANALYZE TABLERefresh optimizer stats
The same reference, with no signal at all
Every command and flow from this site, held on your device and searchable with no connection. Free to install, no ads.
Get it free on the App Store