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.s...@artificialmachines.com> 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.s...@artificialmachines.com> 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=vegiv...@tuxera.be > >> > >> > > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql?unsub=vegiv...@tuxera.be > >
