From: Perrin Harkins Date: March 3 2009 5:50pm Subject: Re: Select query locks tables in Innodb List-Archive: http://lists.mysql.com/mysql/216560 Message-Id: <66887a3d0903030950j9e4e93dr8e21f3a6ca5cfe8f@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit On Tue, Mar 3, 2009 at 10:53 AM, Carl wrote: > A query that is selecting data for a report locks the files that it accesses forcing users who are attempting to enter transactions to wait until the select query is finished. Is it an INSERT INTO...SELECT FROM? Those lock. Also, have you verified that each table you think is InnoDB really is? Do a SHOW CREATE TABLE on them. - Perrin