Re: One table gets locked by itself

[Johan De Meersman]

----- Original Message -----

> From: "Claudio Nanni" <claudio.nanni@stripped>

> 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