Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email email@example.com
From: Perrin Harkins (perrinelem.com)
Date: Thu Oct 14 2010 - 07:33:10 CDT
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.
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql