Re: MySQL on an SMP system - exploiting it

From: Jerry Stuckle <>
Date: Fri, 2 Jun 2017 09:21:16 -0400
Message-ID: <ogrohc$r0s$>

On 6/2/2017 3:33 AM, wrote:

>> If there are fewer active threads than CPU cores, then
>> adding cores will have (nearly) no effect.

> Yeah yeah - my site ain't gonna get ONE hit, will it?! :) So - how do BIG-ass sites like E-comm sites or whatever, run, then? At some point they will surely overshoot the load of 1 CPU or even, at some point, 1 whole server....?

You haven't shown any analysis as to why adding a core to your system will improve MySQL performance - or if you even have a performance problem.

There are lots of techniques for big sites to handle heavy traffic, all of which are off-topic in this newsgroup. But they are all based on analyzing performance problems and solving the cause of the performance problems.

Remove the "x" from my email address
Jerry Stuckle
Received on Fri Jun 02 2017 - 15:21:16 CEST

Original text of this message