Hi! On Wed, Aug 5, 2009 at 11:37 AM, Konstantin Osipov<[email protected]> wrote: > All tables used in a statement are locked at once, before > execution. > > Then we update the first table, while accumulating PKs of the > second table in a temporary table. > > Then we go over temporary table and update the rows in the second > table, using the accumulated PKs. > > For MyISAM, this is as atomic as you get with LOCK TABLE t1 WRITE, > t2 WRITE, and then running the two updates.
Yes. So if some error occurs while dealing with the second table (say, a constraint violation) then you could end up having processed only all of the first table, and half of the second with MyISAM, right? At least, that's how I understood it. kind regards, -- Roland Bouman http://rpbouman.blogspot.com/ Author of "Pentaho Solutions: Business Intelligence and Data Warehousing with Pentaho and MySQL", http://www.wiley.com/WileyCDA/WileyTitle/productCd-0470484322.html _______________________________________________ Mailing list: https://launchpad.net/~drizzle-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-discuss More help : https://help.launchpad.net/ListHelp
