List:General Discussion« Previous MessageNext Message »
From:Reindl Harald Date:March 18 2013 8:35pm
Subject:Re: How to change max simultaneous connection parameter in mysql.
View as plain text  

Am 18.03.2013 21:01, schrieb Rick James:
> 20 is plenty if your pages run fast enough

it is not
you never have hosted a large site

> Excess clients after MaxClients are queued in Apache

so what - it doe snot help you
been there, done that

if you have some hundret USERS at the same time
any every of them is requesting the same page with
a lot of images you are simply DEAD with a limit of
20 in your configuration

> If the 20 are consuming resources (eg cpu/disk) it is better to queue the excess 
> than to have everybody stumbling over each other.

if your server can not serve more than 20 simultaionous
requests you are not doing any serious things

sorry, 20 can be done with any crappy notebook these days

> In MySQL, the excess clients beyond max_connections are give an error.
> 
>> -----Original Message-----
>> From: Reindl Harald [mailto:h.reindl@stripped]
>> Sent: Monday, March 18, 2013 12:15 PM
>> To: mysql@stripped
>> Subject: Re: How to change max simultaneous connection parameter in
>> mysql.
>>
>>
>>
>> Am 18.03.2013 19:26, schrieb Rick James:
>>> If you are running Apache with MaxClients set too high, that can
>> cause the problem.
>>
>> "too high" is relative
>>
>>> That Apache setting should be something like 20.  (Other web servers
>>> have similar settings.)
>>
>> 20 is a laughable value as long you are not hosting only sites with no
>> users at all
>>
>> i have seen "MaxClients 500" be critical while the hardware was not
>> overloaded and we had THOUSANDS of users which liked to get the website
>> with all it's images, no way with stupid settings of 20 which means
>> only ONE USER at the same time can fetch a single page with images and
>> stylesheets


Attachment: [application/pgp-signature] OpenPGP digital signature signature.asc
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