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>


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.

-- 

 //Aho
Received on Sat May 20 2017 - 16:03:25 CEST

Original text of this message