List:General Discussion« Previous MessageNext Message »
From:Perrin Harkins Date:December 15 2009 5:06pm
Subject:Re: How to not lock anything?
View as plain text  
On Tue, Dec 15, 2009 at 11:58 AM, Keith Murphy <bmurphy@stripped> 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
Thread
How to not lock anything?D. Dante Lorenso15 Dec
  • RE: How to not lock anything?Neil Aggarwal15 Dec
    • RE: How to not lock anything?Neil Aggarwal15 Dec
  • Re: How to not lock anything?Jay Ess15 Dec
  • Re: How to not lock anything?mos15 Dec
  • Re: How to not lock anything?Perrin Harkins15 Dec
    • Re: How to not lock anything?Keith Murphy15 Dec
      • Re: How to not lock anything?Perrin Harkins15 Dec