3 ms·
You want to "defrag" a live database? You're brave. Dump it and rebuild it - you should be able to do a node at a time.
by lotsofcows 13y ago
You want to "defrag" a live database? You're brave. Dump it and rebuild it - you should be able to do a node at a time.
- ck2 13y agoWith terabyte sized databases, thousands of tables, not really an option to dump and reload. Alter and optimize are already possible on a live innodb table, in theory it should not be exponentially harder to optimize ibdata. Note that oracle solved this problem on their commercial database product.