Re: MySQL on an SMP system - exploiting it
Date: Tue, 23 May 2017 14:43:07 -0700
Message-ID: <q2b9icdgqkvmm7us5tddlqu2qhsbfqgqfb_at_4ax.com>
On Tue, 23 May 2017 13:03:52 -0700 (PDT), bit-naughty_at_hotmail.com wrote in comp.databases.mysql:
>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?
If half a gazillion conditions in your OS and OS configuration, web server and web server configuration, SQL and its configuration, etc, etc, etc are met, then yes.
jue Received on Tue May 23 2017 - 23:43:07 CEST