I encounter the same problem . And I think the BDB take the table lock
instead of row level lock.
To resolve the problem .You can use Innodb table.
>From: Monika Andr?Jönsson <[EMAIL PROTECTED]>
>To: [EMAIL PROTECTED]
>Subject: Berkeley DBD and locking
>Date: Thu, 20 Sep 2
Monika,
Transactional InnoDB type tables in MySQL -Max allow
users to read tables while they are being updated.
That is because of the multiversioned concurrency
control used in InnoDB.
See http://www.innodb.com/ibman.html
for more info. There you also find the startup
options you should add to
Hello,
I have installed the Mysql Max version with DBD tables (3.23.40) and is
running the server on NT. I have a rather small database with lots of
tables (22) and liked the idea with transactions. This is my situation:
I have one application writing and reading data from my tables (using
transa
On Tue, May 29, 2001 at 04:26:01PM -0400, Seth Hall wrote:
>
> What if the queries were updates instead of inserts? Would I need
> or be able to lock the tables then?
Why do you think you need table locks in the first place. I'm not sure
that I ever really understood why you needed them.
> Can
On Thu, May 24, 2001 at 10:52:36PM -0400, Seth Hall wrote:
>
> Is locking not necessary on BDB tables? Does transaction support
> get rid of the need for table locking?
Probably, yes. It depends on your application.
Jeremy
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finan
What if the queries were updates instead of inserts? Would I need or be
able to lock the tables then?
Can I go without locking the bdb tables and not worry about the data
integrity on those tables during updates and inserts?
-Seth Hall
Student Programmer
Ohio State University Main Library
On
Is locking not necessary on BDB tables? Does transaction support get rid of
the need for table locking?
thanks,
-Seth
>On Thu, May 17, 2001 at 12:35:09PM -0400, Seth Hall wrote:
>>
>> Hi, could someone point me to a tutorial on when to do table locking
>> with the BDB tables in MySQL?
>
>Why
On Thu, May 17, 2001 at 12:35:09PM -0400, Seth Hall wrote:
>
> Hi, could someone point me to a tutorial on when to do table locking
> with the BDB tables in MySQL?
Why?
> I'm running version 3.23.37 on RH7.0 (with BDB tables :) and if I
> attempt to do locking within a transaction, the transacti
Hi, could someone point me to a tutorial on when to do table locking with the BDB
tables in MySQL?
I'm running version 3.23.37 on RH7.0 (with BDB tables :) and if I attempt to do
locking within a transaction, the transaction is automatically committed leaving me
with non-working transaction
