On Wed, Aug 27, 2008 at 8:21 PM, Jose Estuardo Avila <[EMAIL PROTECTED]> 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]