On Mon, Mar 8, 2010 at 1:29 PM, Platonides <[email protected]> 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. _______________________________________________ Toolserver-l mailing list ([email protected]) https://lists.wikimedia.org/mailman/listinfo/toolserver-l Posting guidelines for this list: https://wiki.toolserver.org/view/Mailing_list_etiquette
