List:General Discussion« Previous MessageNext Message »
From:Manasi Save Date:November 24 2009 11:22am
Subject:Re: How normal mysql server 5.1 uses multiple cores
View as plain text  
Hi Johan,

Thanks for the quick response.

Is there any command available in mysql using which I can check how much
CPU is being used by each mysql thread. Or any article where how mysql
multi-threading works.

-- 
Thanks and Regards,
Manasi Save
Artificial Machines Pvt Ltd.

> MySQL is already a multithreaded process, even though you only see a
> single
> process. Note that it doesn't scale very well above eight or so cores,
> especially InnoDB iirc.
>
> If you are wondering about parallel query execution (that is, splitting a
> single query over multiple cores for faster execution), that is currently
> not supported by MySQL.
>
>
> On Tue, Nov 24, 2009 at 12:02 PM, Manasi Save <
> manasi.save@stripped> wrote:
>
>> Hi All,
>>
>> Can anyone provide me any input on How to make mysql use multiple CPU
>> cores avaliable.
>>
>> I am sorry if I am souding very unclear with this. Let me know if you
>> have
>> any questions.
>>
>> Thanks in advance.
>>
>> --
>> Regards,
>> Manasi Save
>> Artificial Machines Pvt Ltd.
>>
>>
>>
>>
>> --
>> MySQL General Mailing List
>> For list archives: http://lists.mysql.com/mysql
>> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
>>
>>
>


Thread
How normal mysql server 5.1 uses multiple coresManasi Save24 Nov
  • Re: How normal mysql server 5.1 uses multiple coresJohan De Meersman24 Nov
    • Re: How normal mysql server 5.1 uses multiple coresManasi Save24 Nov
      • Re: How normal mysql server 5.1 uses multiple coresJohan De Meersman24 Nov
    • Re: How normal mysql server 5.1 uses multiple coresJaime Crespo Rinc√≥n24 Nov
      • Re: How normal mysql server 5.1 uses multiple coresmos24 Nov