On Fri, 29 Jun 2001 15:29:08 +0200, Gerlinde Fischer
<[EMAIL PROTECTED]> wrote:
I don't believe BDB table handler support row-locking. I suggest looking at
using Innobase tables handlers.
>>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 <[EMAIL PROTECTED]>
>>To unsubscribe, e-mail <[EMAIL PROTECTED]>
>>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Mike(mickalo)Blezien
========================================
Thunder Rain Internet Publishing
Providing Internet Solutions that work!
http://www.thunder-rain.com
Tel: 1(225) 686-2002
=========================================
---------------------------------------------------------------------
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 <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
