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.
精彩评论