Hi
Also Nusphere have just released GEMINI tables which support row
locking.Been on their beta team since day one and the commercial product is
very good. Easy to setup with their install procedure and all round worth
every penny. Their support staff have been fantastic, never once letting me
down.!
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Warren van der Merwe
Software Director
PRT Trading (Pty) Ltd t/a RedTie
Durban, South Africa
Cell (+27-83) 262-9163
Office (+27-31) 767-0249
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of
> Mike<mickalo>Blezien
> Sent: 29 June 2001 15:49
> To: Gerlinde Fischer
> Cc: [EMAIL PROTECTED]
> Subject: Re: BerkleyDB and mysql and COMMIT
>
>
> 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
---------------------------------------------------------------------
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
