maria-developers team mailing list archive

[Stewart Smith <stewart@xxxxxxxxxxxxxxxx>]

Kristian Nielsen <knielsen@xxxxxxxxxxxxxxx> writes:
> 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

Attachment: pgpR00_uh_sCy.pgp
Description: PGP signature