Re: MySQL on an SMP system - exploiting it
Date: Fri, 02 Jun 2017 07:54:00 -0700
Message-ID: <umu2jctlfpmmfgdqkitis8n3v2gs5cpf3h_at_4ax.com>
On Fri, 2 Jun 2017 00:33:19 -0700 (PDT), bit-naughty_at_hotmail.com wrote in comp.databases.mysql:
>> If there are fewer active threads than CPU cores, then
>> adding cores will have (nearly) no effect.
>
>
>Yeah yeah - my site
What site? You were talking about MySQL. You do know that SQL servers and Web Servers are very different animals and are doing very different jobs, don't you?
>ain't gonna get ONE hit, will it?! :) So - how do BIG-ass sites like E-comm sites or whatever, run, then?
As for Web Servers: they use e.g. server farms, load balancing, and a whole slew of other techniques. None of them have anything to do with (My)SQL.
>At some point they will surely overshoot the load of 1 CPU or even, at some point, 1 whole server....?
No idea what that sentence is supposed to mean.
jue Received on Fri Jun 02 2017 - 16:54:00 CEST