MySQL Forums
Forum List  »  InnoDB

Record locking INNODB
Posted by: Uwe Hennig
Date: February 01, 2005 02:15PM

Hi,

following problem:

start transaction

select client_number from client where client_number = 100 for update

another user send

start transaction

select client_number from client where client_number = 200

and the result is nothing
all selects with any client_number send as result nothing

the result is OK when the first transaction is finished but our application runs with
a lot of users and this problem is very often.

I hope for help

MySQL Version 4.0.20 with INNODB

greeting

Uwe

Options: ReplyQuote


Subject
Views
Written By
Posted
Record locking INNODB
7814
February 01, 2005 02:15PM
3547
February 01, 2005 02:52PM
3297
February 02, 2005 04:06AM
3392
February 04, 2005 01:35PM
3261
February 02, 2005 12:24PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.