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,
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 clu
ificial 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
y 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 f
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 f
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
single thread, hence can never use more than one core.
So if your workload is dominated by 1 long-running query after
another, it may seem like it's using only one core.
Periodically check the output of "mysqladmin status"... if the thread
counter is > 1, you're using multipl
Kunal Jain schrieb:
> How we can configure Mysql in such a way so that i start using all the cores
> of CPU. I Have a QuadCore server but somehow mysql use only single core
> whose usage percentage goes upto 99% while other three cores remains idle.
>
> Any Idea or Multiple Core/CPU is wastage.
How we can configure Mysql in such a way so that i start using all the cores
of CPU. I Have a QuadCore server but somehow mysql use only single core
whose usage percentage goes upto 99% while other three cores remains idle.
Any Idea or Multiple Core/CPU is wastage.
--
Kunal Jain, burrp!
http://b
