Thanks! I will try the -set again to see if it works. I seem to remember that was the first one I tried and had no luck. I might have had the wrong syntax. I will try again tomorrow morning and see how this works. I am pushing the users to upgrade to 4.1 for now and then 5.x when the dust settles. Thanks!
-----Original Message----- From: Gleb Paharenko [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 06, 2005 7:03 AM To: mysql@lists.mysql.com Subject: Re: max_connections in 3.23.49 Hello. For such an old version of MySQL use --set-variable syntax. See: http://dev.mysql.com/doc/refman/4.1/en/program-variables.html I'm not sure if it supports dynamic system variables through the SET syntax, according to the manual they have appeared in 4.0.3. In the future, instead of 'set @variable' syntax for system variables, use 'set @@global.variable' or 'set global variable=...'. See: http://dev.mysql.com/doc/refman/4.1/en/system-variables.html I strongly recommend you to upgrade. Douglas B. Jones wrote: > How do you up max_connections on 3.23.29 mysql? I > have tried in the my.cnf file, command line and > in mysql (set @max_connections=200). Thanks for > any help! > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]