开发者

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

开发者 https://www.devze.com 2023-04-01 09:22 出处:网络
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 INNO

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

精彩评论

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