2 ms·
With 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
by ck2 13y ago
With 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.