[Gllug] MySQL Woes

Nix nix at esperi.demon.co.uk
Thu Jun 13 14:03:17 UTC 2002


On 12 Jun 2002, Chris Ball said:
>>>>>> "itsbruce" == itsbruce <itsbruce at uklinux.net> writes:
>     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 :( )

-- 
`What happened?'
                 `Nick shipped buggy code!'
                                             `Oh, no dinner for him...'

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




More information about the GLLUG mailing list