How to set SQL_BIG_SELECTS via ISPManager?

Question

MySQL

The script in which the "big" query gave an error:
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
Please tell me how to change MySQL settings using ISPmanager so that everything goes "like clockwork"?

Answer 1

And hands to make her fate?
just before this "big" query do
and better
... well it if PHP, obviously.
But, it is not clear what does ISPManager have to do with it? It's only about MySQL queries.
Try to rebuild SELECT.
JOIN are you using?