From: Perrin Harkins
Date: October 14 2010 12:33pm
Subject: Re: How to kill locked queries
List-Archive: http://lists.mysql.com/mysql/223330
Message-Id:
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
On Thu, Oct 14, 2010 at 3:28 AM, Johan De Meersman 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