Re: MySQL on an SMP system - exploiting it
From: Luuk <luuk_at_invalid.lan>
Date: Sun, 21 May 2017 15:25:27 +0200
Message-ID: <59219546$0$821$e4fe514c_at_news.xs4all.nl>
>
> 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
>
>
>
Date: Sun, 21 May 2017 15:25:27 +0200
Message-ID: <59219546$0$821$e4fe514c_at_news.xs4all.nl>
[Quoted] [Quoted] 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
[Quoted] Answer (from the Natural Philosopher):
> you install as much RAM as your system will take and use an SSD
[Quoted] [Quoted] So, installing more RAM and an SSD wil make MySQL use both processors?
Thanks,
;) Received on Sun May 21 2017 - 15:25:27 CEST