Re: MySQL on an SMP system - exploiting it
From: Luuk <luuk_at_invalid.lan>
Date: Sun, 21 May 2017 17:22:36 +0200
Message-ID: <5921b0ba$0$748$e4fe514c_at_news.xs4all.nl>
>> 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,
>>
>> ;)
Date: Sun, 21 May 2017 17:22:36 +0200
Message-ID: <5921b0ba$0$748$e4fe514c_at_news.xs4all.nl>
On 21-05-17 16:05, The Natural Philosopher wrote:
> 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? > >
fine, thankk you! Received on Sun May 21 2017 - 17:22:36 CEST