List:General Discussion« Previous MessageNext Message »
From:Igor Shevtsov Date:March 16 2013 8:44am
Subject:Re: How to change max simultaneous connection parameter in mysql.
View as plain text  
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.
>
>
>
>

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