RE: BerkleyDB and mysql and COMMIT

2001-06-29 Thread Warren van der Merwe
ezien > 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 handle

Re: BerkleyDB and mysql and COMMIT

2001-06-29 Thread MikeBlezien
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 co

Re: BerkleyDB and mysql and COMMIT

2001-06-29 Thread Gerald Clark
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

BerkleyDB and mysql and COMMIT

2001-06-29 Thread Gerlinde Fischer
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