| List: | General Discussion | « Previous MessageNext Message » | |
| From: | Perrin Harkins | Date: | March 3 2009 5:50pm |
| Subject: | Re: Select query locks tables in Innodb | ||
| View as plain text | |||
On Tue, Mar 3, 2009 at 10:53 AM, Carl <carl@stripped> 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