Re: How normal mysql server 5.1 uses multiple cores

2009-11-24 Thread mos
At 06:44 AM 11/24/2009, you wrote: 2009/11/24 Johan De Meersman : > 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. [offtopic] Probably is something stupid, but could t

Re: How normal mysql server 5.1 uses multiple cores

2009-11-24 Thread Jaime Crespo Rincón
2009/11/24 Johan De Meersman : > 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. [offtopic] Probably is something stupid, but could that be done with ndb cluster on a sin

Re: How normal mysql server 5.1 uses multiple cores

2009-11-24 Thread Johan De Meersman
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.

Re: How normal mysql server 5.1 uses multiple cores

2009-11-24 Thread Manasi Save
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 m

Re: How normal mysql server 5.1 uses multiple cores

2009-11-24 Thread Johan De Meersman
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

How normal mysql server 5.1 uses multiple cores

2009-11-24 Thread Manasi Save
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 Fo