List:General Discussion« Previous MessageNext Message »
From:Johan De Meersman Date:October 14 2010 7:28am
Subject:Re: How to kill locked queries
View as plain text  
On Thu, Oct 14, 2010 at 9:19 AM, monloi perez <mlp_folder@stripped> wrote:

> Does this happen if your table is InnoDB?
>


That depends on the type of lock. If no lock type is specified, InnDB will
prefer row locks, while MyISAM will do table locks.

That may help, unless all your queries are trying to access the same rows
anyway :-)  You really need to figure out *what* is being locked and *why*
before you can fix it.

-- 
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel

Thread
How to kill locked queriesmonloi perez14 Oct
  • Re: How to kill locked queriesJohan De Meersman14 Oct
  • Re: How to kill locked queriesClaudio Nanni14 Oct
    • Re: How to kill locked queriesmonloi perez14 Oct
      • Re: How to kill locked queriesJohan De Meersman14 Oct
        • Re: How to kill locked queriesPerrin Harkins14 Oct