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