From: Johan De Meersman Date: May 9 2012 10:17am Subject: Re: One table gets locked by itself List-Archive: http://lists.mysql.com/mysql/227371 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="=_4681c5e8-295e-4444-adca-cb06e23acc2c" --=_4681c5e8-295e-4444-adca-cb06e23acc2c Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit ----- Original Message ----- > From: "Claudio Nanni" > Yes indeed, > but I think we are talking about MySQL level deadlocks, > that can happen only with row level locking and transactions. > If the deadlock is generated at application level then you can have > it on anything, also blackhole :-) Yup, but you don't know where the lock comes from, so that's possible. However, I just checked the documentation, and he *is* right after all: MySQL claims to be deadlock-free for table-locking engines, they simply lock all tables at once (I suppose that means any lock statement will invalidate the previous one) and always lock tables in the same order. -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel --=_4681c5e8-295e-4444-adca-cb06e23acc2c--