Re: Record locking INNODB
Posted by:
Dick Stins
Date: February 01, 2005 02:52PM
Uwe Hennig wrote:
> 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
I guess that you forgot for update?
>
> 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
Is it a php/apache applicaton?
Does every user use a separate mysql user?
Is autocommit on?
Subject
Views
Written By
Posted
7888
February 01, 2005 02:15PM
Re: Record locking INNODB
3594
February 01, 2005 02:52PM
3344
February 02, 2005 04:06AM
3439
February 04, 2005 01:35PM
3302
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.