Re: MySQL on an SMP system - exploiting it

[Quoted] On 20/05/17 14:29, bit-naughty_at_hotmail.com wrote:
> If I have a server with say, 2 CPUs on it, how do I get MySQL to use both CPUs to speed up its processing? If my db search takes 2 secs, and I double the chip capacity (say get another of the same Ghz), will the search now be done in 1 sec? How do I do that?

[Quoted] [Quoted] you install as much RAM as your system will take and use an SSD

in may case most big mysql searches are limited by disk access. Ram to cache it and a faster disk makes a massive difference

>
>
> Thanks,
>

-- 
Future generations will wonder in bemused amazement that the early 
twenty-first century’s developed world went into hysterical panic over a 
globally average temperature increase of a few tenths of a degree, and, 
on the basis of gross exaggerations of highly uncertain computer 
projections combined into implausible chains of inference, proceeded to 
contemplate a rollback of the industrial age.

Richard Lindzen