Re: MySQL on an SMP system - exploiting it

On 26/05/17 14:13, bit-naughty_at_hotmail.com wrote:
> Guys... what I'm asking is, if I add in another chip, will it increase the performance of my server - it's a simple question really...? (MySQL and other things included, but naturally, in THIS group, it's MySQL I'm concerned about!). I mean, why else would someone purchase an SMP system?? Right?
>
> When MySQL goes to do a SELECT, can it TELL that the core it's trying to do it on is overloaded, and switch to a different core? - I guess that's the question I'm trying to ask.....
>

The answer is probably not unless the chip in question is a RAM chip or an SSD chip :-=)

IF you are on a *nix system run 'top' whilst executing your worst query.

If the machine shows low memory availability and high wait percentages, its disk/memory bound, not CPU bound

-- 
The biggest threat to humanity comes from socialism, which has utterly 
diverted our attention away from what really matters to our existential 
survival, to indulging in navel gazing and faux moral investigations 
into what the world ought to be, whilst we fail utterly to deal with 
what it actually is.