On Tue, Mar 3, 2009 at 12:35 PM, Brent Baisley <brentt...@gmail.com> wrote: > A SELECT will/can lock a table. It almost always does in MyISAM (no > insert/updates), almost never does in InnoDB. There is an exception to > every rule. The problem is most likely in the 107488 rows part of the > query. That's too many rows for InnoDB to keep a version history on so > it's likely just locking the table.
InnoDB does not do lock escalation a la SQL Server etc. I'd look at Perrin's suggestions, I think they are likely to be the problem. More importantly, what is the query? :-) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org