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>
>
>
> Question:
>
> Answer (from the Natural Philosopher):
>
> So, installing more RAM and an SSD wil make MySQL use both processors?
>
> Thanks,
>
> ;)
Fucking pedant. How are you doin' Luuk?
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