> you never have hosted a large site Check my email address before saying that.
20 may be low, but 100 is rather high. > -----Original Message----- > From: Reindl Harald [mailto:h.rei...@thelounge.net] > Sent: Monday, March 18, 2013 1:36 PM > To: mysql@lists.mysql.com > 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.rei...@thelounge.net] > >> Sent: Monday, March 18, 2013 12:15 PM > >> To: mysql@lists.mysql.com > >> 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