max_connections doesn't change

Hi,
I'm trying to change the value of max_connections variable but mysqld
doesn't accept that.
I use mysql 3.23.54 and my config file /etc/my.cnf looks like:

[mysql.server]
....
....
set-variable max_connections=200

After a newstart of mysqld the value of max_connections is unchanged and
equals 100.

PLS help

Regards
Jan Josefowicz


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=m...ie.nctu.edu.tw

re: max_connections doesn't change

I know this is really late to reply, but for the benefit of others who may face the same problem:

The line:
set-variable=max_connections=<new value>

should be moved under the [mysqld] section of the config file my.cnf for the change to take effect. By default this variable setting is under the [mysqld_safe] section (for MySQL 4.1) or under [mysql.server] for 3.23.54 as Jan mentioned and if it is placed there, MySQL will ignore this setting and any changes made to it.