Back
Syntax
Study
Editor
Mode:
HTML
CSS
JavaScript
PHP
Reset
Run »
HTML / CSS / JS
-- Update optimizer statistics ANALYZE TABLE orders; -- Defragment and reclaim space (rebuilds table) OPTIMIZE TABLE orders; -- Check fragmentation SELECT TABLE_NAME, ROUND(DATA_FREE/1024/1024, 2) AS free_mb FROM information_schema.TABLES WHERE TABLE_SCHEMA = DATABASE() ORDER BY DATA_FREE DESC;
Result
Open