List:General Discussion« Previous MessageNext Message »
From:Rick James Date:March 18 2013 6:26pm
Subject:RE: How to change max simultaneous connection parameter in mysql.
View as plain text  
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
> 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.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

Thread
How to change max simultaneous connection parameter in mysql.Kevin Peterson16 Mar
  • Re: How to change max simultaneous connection parameter in mysql.Reindl Harald16 Mar
  • Re: How to change max simultaneous connection parameter in mysql.Manuel Arostegui16 Mar
    • Re: How to change max simultaneous connection parameter in mysql.Igor Shevtsov16 Mar
      • RE: How to change max simultaneous connection parameter in mysql.Rick James18 Mar
        • Re: How to change max simultaneous connection parameter in mysql.Reindl Harald18 Mar
          • RE: How to change max simultaneous connection parameter in mysql.Rick James18 Mar
            • Re: How to change max simultaneous connection parameter in mysql.Reindl Harald18 Mar
              • Re: How to change max simultaneous connection parameter in mysql.Noel Butler18 Mar
              • RE: How to change max simultaneous connection parameter in mysql.Rick James19 Mar
                • Re: How to change max simultaneous connection parameter in mysql.Reindl Harald19 Mar
                • Re: How to change max simultaneous connection parameter in mysql.spameden24 Mar
                  • Re: How to change max simultaneous connection parameter in mysql.Reindl Harald24 Mar
                    • Re: How to change max simultaneous connection parameter in mysql.Manuel Arostegui24 Mar
                    • Re: How to change max simultaneous connection parameter in mysql.spameden2 Apr
                      • Re: How to change max simultaneous connection parameter in mysql.Reindl Harald2 Apr
                        • RE: How to change max simultaneous connection parameter in mysql.Rick James2 Apr
                          • Re: How to change max simultaneous connection parameter in mysql.Reindl Harald2 Apr
                      • RE: How to change max simultaneous connection parameter in mysql.Rick James2 Apr
                        • Re: How to change max simultaneous connection parameter in mysql.Reindl Harald2 Apr
                          • RE: How to change max simultaneous connection parameter in mysql.Rick James2 Apr
                            • Re: How to change max simultaneous connection parameter in mysql.Reindl Harald2 Apr
                            • Re: How to change max simultaneous connection parameter in mysql.spameden2 Apr