We've recently started using MySQL for customers with a large number of
records on their systems.
For the first time, one of our customers has gone over the 4 million
record mark, and we're running into some problems with the MAX_JOIN_SIZE
and the SQL_BIG_SELECTS. Using the control center, or command line
option, we can successfully 'Set SQL_BIG_SELECTS=1' and solve the
problem.
So the question is, is there a way to set the server so that the default
is SQL_BIG_SELECTS=1? Setting it as a variable in the my.cnf file
doesn't seem to work, it causes the server to be unable to start. Is it
something that needs to be set through the application accessing the
database each time it opens a new connection? Or can we set it through
the application globally? Forgive me if this is an obvious answer, I
have spent a long time searching the documentation and other places
online, but can't seem to find the solution.
Thanks in advance for any assistance,
Jen
Jennifer Horne, Software Developer
[EMAIL PROTECTED]
Panda Voice Systems Inc.
1.888.767.2632 ext 23
