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
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