[Gllug] MySQL Woes

Matthew Kirkwood matthew at hairy.beasts.org
Thu Jun 13 15:14:51 UTC 2002


On 13 Jun 2002, Nix wrote:

> >     itsbruce> 5.  No record locking (just whole-table locking)
> >
> > Yes, row-level locking, also via the InnoDB wrappers.
>
> Alas, compared to MVCC this is slow as a dog in any situation where
> lots of locks are being waited on, because of all the (unnecessary)
> blocking.
>
> (Oracle has the same problem :( )

Oracle had MVCC before postgres.  Interbase/Phoenix/Firebird/
whatever it's called also does MVCC.

Matthew.


-- 
Gllug mailing list  -  Gllug at linux.co.uk
http://list.ftech.net/mailman/listinfo/gllug




More information about the GLLUG mailing list