Archive for April, 2011
Optimize MySQL tables after deleteing alot of data
0 Comments Published April 12th, 2011 in UncategorizedOPTIMIZE TABLE foo; will squeeze out the dead space. ALTER TABLE foo ORDER BY something; does what OPTIMIZE does (but in a totally different way), plus clusters data based on the ORDER BY. In a few cases, this can be quite beneficial. Here’s an example: * Table is bigger than will fit in cache. * [...]