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" <[EMAIL PROTECTED]> Visit my web laboratory at http://beta.unclassified.de -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]