On Tue, Dec 15, 2009 at 11:58 AM, Keith Murphy <bmur...@paragon-cs.com> 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org