Re: EXPLAIN says DEPENDENT SUBQUERY despite no free variables

[Baron Schwartz]

Hello,

On Wed, Feb 24, 2010 at 10:11 AM, Yang Zhang <yanghatespam@stripped> wrote:
> I have the following query. Note that the nested query has no
> dependencies on the outer one, yet mysql reports it as dependent.

Do an EXPLAIN EXTENDED followed by SHOW WARNINGS.  You will see the
"optimization" that mysqld applies to the subquery, to try to help it
by adding a dependency on the outer query.

There's nothing you can do about this :-(  You have to use a JOIN in most cases.

BTW, the general log is itself a performance killer when logged to
tables.  If I were you I'd use the slow query log and mk-query-digest
from Maatkit.