Re: MySQL on an SMP system - exploiting it

From: (wrong string) ürgen Exner <>
Date: Fri, 02 Jun 2017 07:54:00 -0700
Message-ID: <>

On Fri, 2 Jun 2017 00:33:19 -0700 (PDT), 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

Original text of this message