Kim,
I use WRITE locks extensively with MySQL 4 with a large distributed
application.
Your example logs indicate that your test application obtained a READ lock,
which will not block other select requests from accessing the table. Only a
WRITE lock will cause subsequent select requests to be hel
"Kim G. Pedersen" <[EMAIL PROTECTED]> wrote:
>
> I try in my program to make a lock.
>
> I try to prevent another session to read and write from the whole table
> I tried both
> LOCK TABLES pstockx WRITE
> and
> LOCK TABLES pstockx READ
>
> but no success.
>
> I put in a breakpoint in my prog
Hello
I try in my program to make a lock.
I try to prevent another session to read and write from the whole table
I tried both
LOCK TABLES pstockx WRITE
and
LOCK TABLES pstockx READ
but no success.
I put in a breakpoint in my program to be sure the lock are held
and then I try to make a s
