On Mon, Mar 8, 2010 at 1:29 PM, Platonides <platonides(a)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.