I did check that all tables are Innodb.
I was using the Navicat Server Monitor because I know that when I see the
monitor reporting a status of locked during an attempted query, that user
comes to a complete halt until the lock is cleared (usually by the bad query
finishing.)
I will check the isolation level but I believe it is whatever was set out of
the box (five years ago.)
Thanks,
Carl
----- Original Message -----
From: "Perrin Harkins" <perrin@stripped>
To: "Carl" <carl@stripped>
Cc: <mysql@stripped>
Sent: Wednesday, March 04, 2009 1:49 PM
Subject: Re: Select query locks tables in Innodb
> 2009/3/4 Carl <carl@stripped>:
>> However, when I had all the pieces in the query
>> (copy attached), I could easily see it was locking tables using the
>> Server
>> Monitor in Navicat.
>
> I don't know what that is, but I think you'd better look at something
> closer to the bone, like SHOW INNODB STATUS.
>
>> Explain (copy as text and copy as Excel attached) seems to indicate that
>> it
>> is fairly good although the first step does get quite a few rows.
>
> EXPLAIN isn't really relevant to table locking. InnoDB tables should
> never let readers block writers for a simple SELECT.
>
>> Does anyone have any ideas?
>
> Did you check that your tables are InnoDB? Are you running some kind
> of crazy isolation level?
>
> - Perrin
>
