|
Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com |
Re: How to kill locked queries
From: Perrin Harkins (perrin
elem.com)
Date: Thu Oct 14 2010 - 07:33:10 CDT
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
On Thu, Oct 14, 2010 at 3:28 AM, Johan De Meersman <vegivamptuxera.be> 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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]