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:nixofort...@gmail.com] > Sent: Saturday, March 16, 2013 1:45 AM > To: mysql@lists.mysql.com > Subject: Re: How to change max simultaneous connection parameter in > mysql. > > 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 > Cheers, > Igor > > > > On 16/03/13 07:39, Manuel Arostegui wrote: > > 2013/3/16 Kevin Peterson <qh.res...@gmail.com> > > > >> 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
