"Jennifer Horne" <[EMAIL PROTECTED]> wrote: > 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.
By default SQL_BIG_SELECTS=1 for new connections. If you use MySQL control center check value of SQL_BIG_SELECTS among Query Options listed in the Query Configuration Dialog windows -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
