List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:May 11 2001 4:41am
Subject:Re: set variable for max_connections
View as plain text  
At 10:31 AM +0800 5/11/01, Mark Lo wrote:
>Hi,
>
>      I have make a my.cnf file in /etc and the permission is set to 644 and
>the ownership is set to root.  When I try to restart MySQL.  I got the
>following error.
>
>error: Found option without preceding group in config file: /etc/my.cnf at
>line: 1
>Program aborted
>
>Would you please tell me what I did wrong.

You have to specify a group name before any options or there is no
way for programs to know whether or not the option applies to them.
In this case, you probably want to use the [mysqld] group:

[mysqld]
set-variable = max_connections=xxx


>Thank You
>
>Mark
>----- Original Message -----
>From: "John Barton" <jbarton@stripped>
>To: "Mark Lo (3)" <mark@stripped>
>Cc: "ComMysql@Lists. Mysql." <mysql@stripped>
>Sent: Friday, May 11, 2001 12:53 AM
>Subject: Re: set variable for max_connections
>
>
>>  Try putting a line like the following in your my.cnf file:
>>  This has always worked for me, including 3.23.37
>>
>>  set-variable = max_connections=xxxx
>>
>>  John Barton
>>  Unix Systems Administrator
>>  Primary Networks, Inc.
>>  jbarton@stripped
>>
>>  On Thu, 10 May 2001, Mark Lo (3) wrote:
>>
>>  > Hi,
>>  >
>>  >      I would like to set a higher values in max_connections for mysql.
>>  >
>>  > I have tried to use the following command "mysqld --set-variables
>>  > max_connections=900 -u root -ppassword".  Then, it shows that I have
>>  > successfully changed the variable of max_connections.  But, when I check
>it
>>  > with the command of "mysqladmin variables -u root -ppassword".  The
>>  > max_connections return to 100 which is the default value.  I wonder what
>is
>>  > wrong with mysql3.23.37.  Is this a bug, or I am using the wrong
>command.
>>  >
>>  > In additions, Can I set the max_connections values higher than 5000.
>>  >
>>  > Thank you
>>  >
>  > > Mark
>  > >

-- 
Paul DuBois, paul@stripped
Thread
set variable for max_connectionsMark Lo \(3\)10 May
  • Re: set variable for max_connectionsJohn Barton10 May
    • Re: set variable for max_connectionsJoseph Bueno10 May
    • Re: set variable for max_connectionsMark Lo11 May
      • Re: set variable for max_connectionsPaul DuBois11 May