OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
Re: One table gets locked by itself

From: Claudio Nanni (claudio.nannigmail.com)
Date: Wed May 09 2012 - 05:11:14 CDT


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 :-)

Claudio

2012/5/9 Johan De Meersman <vegivamptuxera.be>

> ----- Original Message -----
> > From: "nixofortune" <nixofortunegmail.com>
> >
> > Few more things. You can't have a deadlock on Mylsam table. You can
>
> You *can* have deadlocks in MyISAM; the concept is not related to any
> specific engine - or even databases.
>
> What you can't have, is deadlock on a single table :-)
>
> --
> Bier met grenadyn
> Is als mosterd by den wyn
> Sy die't drinkt, is eene kwezel
> Hy die't drinkt, is ras een ezel
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql
>
>

--
Claudio