On Thu, Oct 14, 2010 at 3:28 AM, Johan De Meersman <vegiv...@tuxera.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 To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org