MYSQL Control Center and large queries

I just moved from mysqlcc 0.8.10 to 0.9.1, and I've begun having a
problem with large queries.

I have a query that selects six columns but involves a join against 11
tables with WHERE conditions involving each table. Under 0.8.10, this
query ran fine. Now, I get the following error:

ERROR 1104: The SELECT would examine too many records and probably take a
very long time. Check your WHERE and use SET OPTION SQL_BIG_SELECTS=1 if
the SELECT is ok

If I then set the option (either via the GUI or by using SET directly in
the query interface), the query returns only one row.

This is particularly interesting considering that the query works fine
(and returns the correct number of rows) via the mysql command-line
interface.

I use mysqlcc with mysql 3.23.x databases, but it has worked fine for a
while. It still works on more modest queries.

-tfo

--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs@m.gmane.org

Re: MYSQL Control Center and large queries

Hi,

> I just moved from mysqlcc 0.8.10 to 0.9.1, and I've begun having a
> problem with large queries.
>=20
> I have a query that selects six columns but involves a join against 11
> tables with WHERE conditions involving each table. Under 0.8.10, this
> query ran fine. Now, I get the following error:
>=20
> ERROR 1104: The SELECT would examine too many records and probably take a
> very long time. Check your WHERE and use SET OPTION SQL_BIG_SELECTS=3D1 if
> the SELECT is ok

This is a known problem, that slipped into 0.9.1. To fix this, edit your
server connection and in the "MySQL Options" tab, set a reasonable value
for "Automatically limit SELECT queries to" and set the value for "Maximum
Join Size" to 1000000.

The default values will be returned to a reasonable size in 0.9.2.

Sorry for the inconvenience.


Rgds,
Indrek

--=20
MySQL Users Conference and Expo: http://www.mysql.com/events/uc2003/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Indrek Siitan
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, The Support Guy
/_/ /_/\_, /___/\___\_\___/ Uuem=F5isa, Haapsalu, Estonia
<___/ www.mysql.com



--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=3Dgcdmb-bugs@m.gmane.org