开发者

How to do an efficient rollback, when using both INNODB and MyISAM tables, within a transaction?

I have read the related questions posted here, But what i don't get is what if we have to use both MyISAM and INNODB...in such a case if we have DML's in a tr开发者_StackOverflow中文版ansaction INNODB tables will rollback, but how to ensure atomicity in the MyISAM tables ?


MyISAM definitely does not support rollback. If you want to ensure atomicity in MyISAM tables you will have to handle such errors yourself and update your MyISAM tables appropriately.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜