Hi Brian, all, according to the doc, it is an atomic command:
http://dev.mysql.com/doc/refman/5.1/en/rename-table.html " This statement renames one or more tables. The rename operation is done atomically, which means that no other session can access any of the tables while the rename is running." On Fri, Dec 12, 2008 at 8:38 PM, Brian Aker <[email protected]> wrote: > Hi! > > I don't see how the command can be atomic internal to the server. We have no > transactional DDL in any engine... I can not see how we would have an "all > or nothing" case occur, especially with a system failure. > > Cheers, > -Brian > > On Dec 12, 2008, at 11:31 AM, Monty Taylor wrote: > >> Brian Aker wrote: >>> >>> Hi! >>> >>> On Dec 12, 2008, at 10:34 AM, Harrison Fisk wrote: >>> >>>> The big advantage with RENAME TABLE is that you can do multiple tables >>>> at a time in an atomic fashion. >>> >>> >>> It is an atomic "command" but that is not an atomic action. >> >> Really? That's potentially unsettling. >> >> >> >>> Cheers, >>> -Brian >>> >>> -- >>> _______________________________________________________ >>> Brian "Krow" Aker, brian at tangent.org >>> Seattle, Washington >>> http://krow.net/ <-- Me >>> http://tangent.org/ <-- Software >>> _______________________________________________________ >>> You can't grep a dead tree. >>> >>> >>> >>> >>> _______________________________________________ >>> Mailing list: https://launchpad.net/~drizzle-discuss >>> Post to : [email protected] >>> Unsubscribe : https://launchpad.net/~drizzle-discuss >>> More help : https://help.launchpad.net/ListHelp >>> >> > > -- > _______________________________________________________ > Brian "Krow" Aker, brian at tangent.org > Seattle, Washington > http://krow.net/ <-- Me > http://tangent.org/ <-- Software > _______________________________________________________ > You can't grep a dead tree. > > > > > _______________________________________________ > Mailing list: https://launchpad.net/~drizzle-discuss > Post to : [email protected] > Unsubscribe : https://launchpad.net/~drizzle-discuss > More help : https://help.launchpad.net/ListHelp > -- Roland Bouman http://rpbouman.blogspot.com/ _______________________________________________ Mailing list: https://launchpad.net/~drizzle-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-discuss More help : https://help.launchpad.net/ListHelp
