On Wed, Nov 25, 2009 at 10:38:52PM -0500, Darius Jahandarie wrote: > Upon further investigation, I discovered that it is already atomic, > because Drizzle scraped the .frm files, and stored the table > definition inside the database itself, which can therefore be "rolled > back."
iff you: a) use an engine that has internal atomic rename b) AND the engine stores the table proto itself c) AND you are only renaming one table to another i.e. with ARCHIVE, BLACKHOLE and CSV you can rename a table and it's 100% crash safe and atomic. Note that this is renaming to an unused name. it is *not* doing multiple renames. > I am not entirely sure if DDL statements actually work inside of a > transaction without implicitly committing at the moment, but it should > be within the realm of possibility if they don't. At some point we hope to see if InnoDB is going to work when we start including DDL in transactions... I expect to find some interesting bugs for them :) -- Stewart Smith _______________________________________________ Mailing list: https://launchpad.net/~drizzle-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-discuss More help : https://help.launchpad.net/ListHelp
