What you are trying to perform is doable with InnoDB table handler.
Unlike BDB, InnoDB has multi-versioning and consistent reads.
--
Regards,
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED]
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime
1. Please explain the above in detail.
It depends on the type of table you're using. If you're using a table type
that only supports table-level locking, then each transaction is isolated by
being suspended until the previous transaction is done. This is slower
if you do a lot of longer
Hi.
I downloaded mysql 3.23.40 from www.mysql.com.
This site announces that this mysql version supports transaction which was
not supported in older mysql.
I was so happy to find that. So I tested that support. The case was
following.
I launched two mysql - one in A terminal window and other in