Re: MySQL on an SMP system - exploiting it

From: The Natural Philosopher <tnp_at_invalid.invalid>
Date: Sun, 21 May 2017 15:05:08 +0100
Message-ID: <ofs6k8$7sv$1_at_dont-email.me>


On 21/05/17 14:25, Luuk wrote:
> On 20-05-17 20:33, The Natural Philosopher wrote:

>> 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?
>>
>> 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,
>>>
>>
>>

>
>
> Question:
>> how do I get MySQL to use both CPUs to speed up its processing

>
> Answer (from the Natural Philosopher):
>> you install as much RAM as your system will take and use an SSD

>
> So, installing more RAM and an SSD wil make MySQL use both processors?
>
> Thanks,
>
> ;)
Fucking pedant. How are you doin' Luuk?
-- 
To ban Christmas, simply give turkeys the vote.
Received on Sun May 21 2017 - 16:05:08 CEST

Original text of this message