If you are running Apache with MaxClients set too high, that can cause the problem. That
Apache setting should be something like 20. (Other web servers have similar settings.)
> -----Original Message-----
> From: Igor Shevtsov [mailto:nixofortune@stripped]
> Sent: Saturday, March 16, 2013 1:45 AM
> To: mysql@stripped
> Subject: Re: How to change max simultaneous connection parameter in
> Hi Kevin,
> In your MySQL client pls execute:
> SET GLOBAL max_connections = 200;
> To Make the change permanent you can edit /etc/my.cnf or whatever MySQL
> config file you you've got in your system Look for this line
> max_connections under [mysqld] secction, add it if it's not in the
> config. make sure it looks like:
> max_connections = 200
> No MySQL restart required
> On 16/03/13 07:39, Manuel Arostegui wrote:
> > 2013/3/16 Kevin Peterson <qh.resu01@stripped>
> >> I am using PHP along with mysql. Mysql default configuration allows
> >> to have 100 simultaneous connection which I want to chane to 200.
> Please help.
> > If you're reaching too many connections quite often, this change can
> > imply memory problems in your server. If you are close to get your
> > server to swap...be careful with this parameter as any swapping will
> > affect your performance.
> > Manuel.
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql