Re: MySQL on an SMP system - exploiting it

[Quoted] On Monday, May 22, 2017 at 6:59:42 PM UTC-5, Jerry Stuckle wrote:

> What exactly is your performance problem? Is it the query itself? Is
> it the processing of that query? Or is it something else?
>
> You can't guarantee which core will be used when a request comes in.
> Basically it will be whatever core is free at the time. It would be
> quite inefficient to wait for core 2 to free up from some other
> operation if core 1 is waiting for I/O, for instance.
>

Right - so, if there are 2 cores, and core 1 is busy serving hit no. 1, then when the 2nd hit comes in, it WILL go to core 2, right? Received on Tue May 23 2017 - 22:03:52 CEST