From: Perrin Harkins Date: December 15 2009 5:06pm Subject: Re: How to not lock anything? List-Archive: http://lists.mysql.com/mysql/219782 Message-Id: <66887a3d0912150906x7fc1c121hcf0fa4399744e97f@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 On Tue, Dec 15, 2009 at 11:58 AM, Keith Murphy wrote: > Writers do block readers. Just at the row level vs the table level of > MyISAM. It's just much less likely for writers to block readers. No, they don't. Not unless you use an extreme isolation level. InnoDB uses multi-version concurrency to allow readers to work on the previous version while writers are updating. http://dev.mysql.com/doc/refman/5.1/en/innodb-consistent-read.html - Perrin