One of my web application gets below error.
“Syntax error or access violation: 1104 The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay.”
Apparently it runs a query which requires processing large amount of data. I checked in mysql MAX_JOIN_SIZE is 5,000,000 instead of default value which is
I tried to increase value from phpmyadmin, but it gives error I need at least one super priviledges. I don’t understand how can I fix this.
Can you please explain how can I fix this?