Hi!
A minor bug managed to slip by 0.9.1 where the "Register Server" screen
didn't set the correct defaults for some newly introduced features....
That's why you're getting that error message; the problem is some mysql
variables are being initialized too small for actual usage.
To fix this you can either
a) wait for 0.9.2
or
b) Edit your server 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. That should fix these problems.
Regards,
Jorge
--
For technical support contracts, visit https://order.mysql.com/?ref=mjdc
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Jorge del Conde <jorge@stripped>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer
/_/ /_/\_, /___/\___\_\___/ Mexico City, Mexico
<___/ www.mysql.com
MySQL Users Conference and Expo
http://www.mysql.com/events/uc2003/
----- Original Message -----
From: "Keith Strickland" <keith@stripped>
To: <mysqlcc@stripped>
Sent: Tuesday, April 01, 2003 5:13 PM
Subject: ERROR 1104
> I'm having problems with displaying the contents of a
> table or rather any table in mysqlcc. When I double click
> the table I get the following error:
>
> "[server] 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"
>
> How should I correct this, as the only documentation I can
> find on SET OPTION SQL_BIG_SELECTS=0|1 is Session
> specific.
> I'm running mysqlcc version 0.9.1-beta on a Windows XP
> machine.
>
> Thanks in advance,
> Keith Strickland
> http://www.keithstric.com
>
>
>
> --
> MySQL Control Center Mailing List
> For list archives: http://lists.mysql.com/mysqlcc
> To unsubscribe: http://lists.mysql.com/mysqlcc?unsub=1
>
