On 12/13/08 3:14 PM, Brian Aker wrote:
Does atomic mean all or nothing, or best effort? I would like to
understand what Brian Moon was doing.
Each night, on our logging server, we loop through the tables (we log 5
or 6 different things straight to mysql) and run something like:
create table article_clicks_new ({definition});
rename table article_clicks to article_clicks_20081214000002,
article_clicks_new to article_clicks;
While I have no idea what would happen if the mysqld or server died in
the middle of this, I do know what it does when all is working. When
all is working, this prevents new inserts from happening while the
renaming is taking place. These are all MYISAM tables.
--
Brian Moon
Senior Web Engineer
------------------------------
When you care enough to spend the very least.
http://dealnews.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
