RE: max_connections in 3.23.49

2005-12-06 Thread Douglas B. Jones

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]



Re: max_connections in 3.23.49

2005-12-06 Thread Gleb Paharenko
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]



max_connections in 3.23.49

2005-12-05 Thread Douglas B. Jones

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!


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]