Re: MyIsam Locking Questions

[Perrin Harkins]

On Wed, Aug 27, 2008 at 8:21 PM, Jose Estuardo Avila <tachu@stripped> wrote:
> Hi, I've been trying to find information on how myisam handles locks. I
> though myisam had locking only on writes and not on reads.

No, readers block writers.  This true of any system that only has read
and write locks to work with.  The only reason they don't block in
InnoDB tables is the MVCC system that lets readers use snapshots while
writers modify the data.  This is all in the MyISAM section of the
docs.

- Perrin