List:General Discussion« Previous MessageNext Message »
From:Gerald Clark Date:June 29 2001 1:52pm
Subject:Re: BerkleyDB and mysql and COMMIT
View as plain text  
I believe BDB uses page locking, so you will likely need more than one 
record before you can avoid the lock.

Gerlinde Fischer wrote:

> Hi,
> I have the following configuration
> I have Linux
> I have compile mysql with the following configure parameters:
>  ./configure --enable-shared --with-berkeley-db 
> --with-mysqld-ldflags='-all-static'
> I have created a BerkleyDB-table.
> After that I have
> set autocommit=0 and I have inserted one row in the one client
> and I tried to look with "select" on the same table in another client.
> Now I found, that the whole table is locked. But I want only row-locking.
> Knows someone a solution.
> After commit I can see all records.
> Thanks
> Gerlinde
>             BLITZ Internet Service GmbH
>                       Kronacher Strasse 41
>                     D-96052 Bamberg, Germany
>            Tel. +49/951/9685160, Fax +49/951/9685164
> ---------------------------------------------------------------------
> Before posting, please check:
>   (the manual)
>           (the list archive)
> To request this thread, e-mail <mysql-thread78042@stripped>
> To unsubscribe, e-mail 
> <>
> Trouble unsubscribing? Try:

Gerald L. Clark

BerkleyDB and mysql and COMMITGerlinde Fischer29 Jun
  • Re: BerkleyDB and mysql and COMMITGerald Clark29 Jun
  • Re: BerkleyDB and mysql and COMMITMike<mickalo>Blezien29 Jun
    • RE: BerkleyDB and mysql and COMMITWarren van der Merwe29 Jun