I am cluless, I need help

[ajp18]

I am new to MySQL.

I am unable to figure out this error.
Error :" [Inhouse linux box] ERROR 1104: The SELECT would examine more rows than MAX_JOIN_SIZE. Check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is ok "

I have edited the MySQL options:

Connect Timeout(sec) : 5
Automatically limit SQL Queries to: 16777215
Net Buffer Lenght : 16384
Maximum Allowed Packates: 16777216
Maximum join size: 16777215

I need help to overcome this error.
Any suggestions? I am cluless.

Thanks for your help

 

[QatQat]

read this

http://www.mysql.com/doc/en/SET_OPTION.html

in order to understand how to change the system variables.

Setting SQL_big_selects=1 will not solve a problem originated by a badly formulated query. So before putting your system through unnecessary stress, check your query, index your tables properly, check that your database is well designed.
I have been using MySQL for quite a while and I never enabled that option.


bye

Qatqat



Life is what happens when you are making other plans.