473,327 Members | 2,112 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,327 software developers and data experts.

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/my***********...ie.nctu.edu.tw

Jul 19 '05 #1
1 5780
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.
Apr 25 '06 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Richard Sumilang | last post by:
Where do I go to set the max_connections settings so I can have over 100? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: ...
2
by: Sami | last post by:
I keep getting the famous 'Too Many Connection' Error, and don't know how to change my variables, so they persist even if i have to restart mysql service. Platform: Windows 2003 Server My...
44
by: Mariusz Jedrzejewski | last post by:
Hi, I'll be very grateful if somebody can explain me why my Opera 7.23 (runing under linux) doesn't show me inner tables. Using below code I can see only "inner table 1". There is no problem with...
0
by: Jay donnell | last post by:
Hi all, I can't seem to change my max_connections variable in mysql. If I try to do it through the client I get this. mysql> set global max_connections=500; ERROR 1064: You have an error in...
1
by: konf | last post by:
Hallo, I am using PostgreSQL 7.4 on UltraSparc machine and I have a touble with max_connections param. I must set only max_connections to 8, when I set more, I got error for shared memory. ...
149
by: Christopher Benson-Manica | last post by:
(Followups set to comp.std.c. Apologies if the crosspost is unwelcome.) strchr() is to strrchr() as strstr() is to strrstr(), but strrstr() isn't part of the standard. Why not? --...
1
by: KC | last post by:
Hi, I created a new event log source and log and user WriteEntry to enter the log as follows: ' Create the source, if it does not already exist. If Not EventLog.SourceExists("MySource") Then...
13
by: P | last post by:
Hi, I'm trying to acquire the parameter MAX_CONNECTIONS by using the API. The following is the code segment I used: struct sqlfupd paramItem; paramItem.token = SQLF_DBTN_MAX_CONNECTIONS;...
35
by: mwelsh1118 | last post by:
Why doesn't C# allow incremental compilation like Java? Specifically, in Java I can compile single .java files in isolation. The resulting individual .class files can be grouped into .jar files....
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.