On 13.11.2007 20:43 CE(S)T, Baron Schwartz wrote:
> Yves Goergen wrote:
>> I assume that at this point, any SELECT on the table I have locked
>> should block. But guess what, it doesn't. So it doesn't really lock.
>>
>
> What kind of lock are you using?
>
> -- cxn 1
>
> set autocommit=0;
> begin;
> lock tables t1 write;
> Query OK, 0 rows affected (6.29 sec)
>
> -- cxn 2
>
> set autocommit=0;
> begin;
> select * from t1;
> -- hangs
Not for me. This is what I was doing here.
(FYI: MySQL 5.0.45-community-nt, Windows XP, mysql command line client,
InnoDB tables)
--
Yves Goergen "LonelyPixel" <nospam.list@stripped>
Visit my web laboratory at http://beta.unclassified.de
