SELECT is not performed in the same thread as nginx; it is performed in another process, or even (in big web setups) in a different host. Therefore, nginx would be in some form of "wait" state, thereby not really using the CPU.
> -----Original Message----- > From: Reindl Harald [mailto:h.rei...@thelounge.net] > Sent: Tuesday, April 02, 2013 2:00 PM > To: mysql@lists.mysql.com > Subject: Re: How to change max simultaneous connection parameter in > mysql. > > > > Am 02.04.2013 22:56, schrieb Rick James: > > I hear that nginx is very fast for a certain class of web serving. > > yes > > > But what happens if a web page needs to do a SELECT? > > what should happen? > > > Is nginx single-threaded, thereby sitting "idle" waiting for the > SELECT? > > why should it do that? > > > And, should you run 8 nginx web servers on an 8-core box? > > why should you do that? > > http://en.wikipedia.org/wiki/Nginx > nginx uses an asynchronous event-driven approach to handling requests > > >> -----Original Message----- > >> From: spameden [mailto:spame...@gmail.com] > >> Sent: Tuesday, April 02, 2013 7:10 AM > >> To: Reindl Harald > >> Cc: mysql@lists.mysql.com > >> Subject: Re: How to change max simultaneous connection parameter in > >> mysql. > >> > >> 2013/3/24 Reindl Harald <h.rei...@thelounge.net> > >> > >>> > >>> > >>> Am 24.03.2013 05:20, schrieb spameden: > >>>> 2013/3/19 Rick James <rja...@yahoo-inc.com>: > >>>>>> you never have hosted a large site > >>>>> Check my email address before saying that. > >>>> > >>>> :D > >>> > >>> as said, big company does not have only geniusses > >>> > >> > >> I do not judge only on 1 parameter, Rick has been constantly helping > >> here and I'm pretty sure he has more knowledge on MySQL than you. > >> > >> > >>> > >>>>> 20 may be low, but 100 is rather high. > >>>> Never use apache2 it has so many problems under load.. > >>> > >>> if you are too supid to configure it yes > >>> > >> > >> Ever heard about Slow HTTP DoS attack? > >> > >> > >>> > >>>> The best combo is php5-fpm+nginx. > >>>> Handles loads of users at once if well tuned > >>> > >>> Apache 2.4 handles the load of 600 parallel executed php-scripts > >>> from our own CMS-system > >>> > >> > >> Nginx serves static content way better than apache2 (did few > >> benchmarks already). > >> > >> nginx+php5-fpm handles better load than apache2-prefork+mod_php > >> > >> you can google benchmarks if you dont trust me > >> > >> also nginx eats much less memory than apache2 > >> > >> php5-fpm can be tuned as well to suit your needs if you have lots of > >> dynamic content > >> > >> > >>> maybe you guys should learn what a opcode-cache is and how to > >>> compile and optimize software (binaries and config) > >>> > >>> o'rly? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
