List:General Discussion« Previous MessageNext Message »
From:Johan De Meersman Date:November 24 2009 11:35am
Subject:Re: How normal mysql server 5.1 uses multiple cores
View as plain text  
the command 'top -H' will show you the individual threads with their CPU
use, but I'm afraid I don't know how to link that up with a MySQL 'show
processlist'.


On Tue, Nov 24, 2009 at 12:22 PM, Manasi Save <
manasi.save@stripped> wrote:

> 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
> >>
> >>
> >
>
>
>
> --
> 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