[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