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
>                       http://www.blitz.net
> ---------------------------------------------------------------------
> Before posting, please check:
>   http://www.mysql.com/manual.php   (the manual)
>   http://lists.mysql.com/           (the list archive)
> 
> To request this thread, e-mail <mysql-thread78042@stripped>
> To unsubscribe, e-mail 
> <mysql-unsubscribe-gerald_clark=suppliersystems.com@stripped>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


-- 
Gerald L. Clark
gerald_clark@stripped

Thread
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