From: Perrin Harkins Date: March 13 2009 6:40pm Subject: Re: Select query locks tables in Innodb List-Archive: http://lists.mysql.com/mysql/216708 Message-Id: <66887a3d0903131140i4986632dv78c8eb7134c54813@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit 2009/3/12 Carl : > I am still a little puzzled about how we could have a relatively large set > of records (100,000+) and yet not cause any table to be locked as the server > has only 8GB of memory. What's the relationship you're implying between memory and locking? Multi-version concurrency doesn't necessarily mean the older versions that are being read from have to be entirely in memory. > InnoDB will lock on a query that doesn't use an index. It shouldn't lock on a SELECT query, regardless of the indexes involved. - Perrin