ERROR 1104: The SELECT would examine too many records.....

[Impothster]

I am a little new to MYSQL but can someone please advise me of whether my problem is a bug? I have created a table in a database thorugh the command prompt and can use queries to examine the data. However, when I try to view the table in the Control Centre (0.9.1 beta), I get the following error: "[Localhost] 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". I constructed another table of only 3 rows and the same occurred. In fact I was only able to view the table if it only had 1 row. I followed the suggestion in the error message (SET OPTION SQL_BIG_SELECTS=1) but the same still ocurrs.

I would value any advice as this is driving me mad. Many thanks.

 

[Schroeder]

I'm beginning to consider this a bug. I am entirely unable to get past it and have to view my data through Access using MyODBC.

thread436-522211

 

[Zimoo]

Forward from MySQLCC mailing list:

From: Tracy Peterson <tracyp@*****.com>
To: dclark@*********.com
Date: Wednesday, April 16, 2003, 10:46:07 AM
Subject: Results more than one row.

----8<-----------Original message text------------------
With as many questions as this mailing list has seen about this
specific issue, I'm surprised that a release hasn't been issued that
changes this default. Would someone please do that? Please please?
Or make it way more obvious where to change this option? Soon?

David,

As per many previous emails:

/* Quoted from someone nice:

One thing to add to help others: When Xxxx said &quot;edit the properties of
the
connection (server) in MySQL CC. Go under MySQL Options and set the
&quot;Automatically limit SELECT queries to&quot; to your desired limit.&quot;

He means :
1 - go to the far left window pane labeled &quot;&quot;MySQL Servers&quot;
2 - right-click on the server name (mine is root@localhost:3306)
3 - select &quot;Edit&quot;. This brings up a window with tabs, the 2nd of which
is
labeled &quot;MySQL Options&quot;
4 - On this tab is the option &quot;Automatically limit SELECT queries to&quot;
and
the default = 1. (WHO thought up this default?)

I set my limit to 10000, since some of my queries return more than 1000
records...

End quote. */

Hope that helps

----8<-----------End of original message text-----------

 

[jpnrd]

I did the fix and restared MysqlCC but I still get the 1104 error. Has anyone else fixed this?

 

[Schroeder]

Yeah, I've tried all kinds of values for that setting. No dice.

 

[iwanlloyd]

I solved the problem by increasing the number of records returned and the maximum number of joins allowed.

This is also set on the MySQL options screen for a connection.

I hope this helps

 

[Schroeder]

Still isn't working for me. I set both &quot;Automatically limit SELECT queries to&quot; and &quot;Maximum Join Size&quot; to 10000 and restarted MySQLCC.

What version of MySQLCC have you got there? I'm running 0.9.1-beta.

 

[christoffersonrobb]

Perhaps it is a little too late and you already know the answer, but try increasing 'Connect timeout' under Mysql Options. If you ranning a query over slow network, Mysql &quot;thinks&quot; that the query is too big when it waits long time for the results.

-Oleg

 

[Schroeder]

Still won't show me anything. I tried increasing it to as much as 40 seconds. The server is on the same subnet of a 100Mb low-traffic network.
Thanks though.