Hi!
By atomic I mean that any sort of crash/error is going to leave you in
a partial state. There seems to be some glossing over of this fact in
the documentation.
Cheers,
-Brian
On Dec 13, 2008, at 1:21 AM, Roland Bouman wrote:
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/
--
_______________________________________________________
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
