List:General Discussion« Previous MessageNext Message »
From:Perrin Harkins Date:October 14 2010 12:33pm
Subject:Re: How to kill locked queries
View as plain text  
On Thu, Oct 14, 2010 at 3:28 AM, Johan De Meersman <vegivamp@stripped> wrote:
> 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 :-)

Even that can work without locking in InnoDB if only one query is
trying to modify the rows.  Unlike MyISAM, readers do not block
writers in InnoDB and vice versa.

- Perrin
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