Re: MySQL on an SMP system - exploiting it
From: J.O. Aho <user_at_example.net>
Date: Sat, 20 May 2017 16:03:25 +0200
Message-ID: <eob0leF7i9cU1_at_mid.individual.net>
Date: Sat, 20 May 2017 16:03:25 +0200
Message-ID: <eob0leF7i9cU1_at_mid.individual.net>
On 05/20/17 15: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?
Install an OS which has SMP capabilities.
> 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?
Really depends on the work to de done, if it can be broken up into different threads, then you may see a time gain, if it's just a single threaded job then it will take the same amount of time as on an uniprocessor platform with the same OS.
The main benefit you will easily see is that you can do more queries at the same time.
-- //AhoReceived on Sat May 20 2017 - 16:03:25 CEST