11 Jan
2013
11 Jan
'13
12:56 a.m.
Kristian Nielsen
The problem is with MyISAM tables, or other tables that use table-level locking instead of row-level locking.
What about just run those txns serially rather than attempting to do in parallel? As soon as you see a MyISAM operation, have a thread that waits for all replication up to that point to be committed, and then do the MyISAM operation. (as there's no reason why other replication couldn't be applied at the same time... after all, MyISAM isn't crash safe so would never be consistent with InnoDB txns). -- Stewart Smith