On Mon, Mar 8, 2010 at 1:29 PM, Platonides platonides@gmail.com wrote:
You may need per-table tablespaces, but i think it worked.
According to http://dev.mysql.com/doc/refman/5.0/en/multiple-tablespaces.html, the process still basically involves shutting down the server so that the file is clean (no outstanding transactions). It's a lot more complicated than just adding the index, and would require server-wide downtime instead of just lagging one table. This doesn't even account for the problems you'd get if the copied table was replicated to a different point from the table it's replacing.