MySQL Forums
Forum List  »  InnoDB

Alter multiple InnoDB tables at the same time
Posted by: nihal
Date: May 20, 2005 01:39PM

Are there any issues with running an alter command on multiple InnoDB tables at the same time?
I have several very large tables that I need to add/modify fields on. The process will probably take a couple of hours for each table
Is there anything wrong with opening up a couple of different sessions to the database and running all the 'alter' commands at once? Or would this freak things out, or just que up anyway?

Is there a better way to do this that I'm unaware of?

Thanks for the help,

Options: ReplyQuote

Written By
Alter multiple InnoDB tables at the same time
May 20, 2005 01:39PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.