List:General Discussion« Previous MessageNext Message »
From:spameden Date:March 24 2013 4:20am
Subject:Re: How to change max simultaneous connection parameter in mysql.
View as plain text  
2013/3/19 Rick James <rjames@stripped>:
>> you never have hosted a large site
> Check my email address before saying that.

:D

>
> 20 may be low, but 100 is rather high.

Never use apache2 it has so many problems under load..

The best combo is php5-fpm+nginx.

Handles loads of users at once if well tuned.

>
>> -----Original Message-----
>> From: Reindl Harald [mailto:h.reindl@stripped]
>> Sent: Monday, March 18, 2013 1:36 PM
>> To: mysql@stripped
>> Subject: Re: How to change max simultaneous connection parameter in
>> mysql.
>>
>>
>>
>> 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
>
>
> --
> 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