Force MySQL to use all Cores
Friends,
We have a Dell PowerEdge R710 with Xeon process for our web application.
We are using MySQL database. and Ubunto 64bit Server edition.
My problem is that, while running a large query it takes merely 45 secs to 60 secs to complete the query.
It seems that the MySQL is not using more than one core. just using only one cpu.
The mysql process is using 100% of cpu, while running the query.
How to tweak/ force / configure MySQL to use mutiple cpus/cores. so that the query runs faster.
Thanks in Advance
We have a Dell PowerEdge R710 with Xeon process for our web application.
We are using MySQL database. and Ubunto 64bit Server edition.
My problem is that, while running a large query it takes merely 45 secs to 60 secs to complete the query.
It seems that the MySQL is not using more than one core. just using only one cpu.
The mysql process is using 100% of cpu, while running the query.
How to tweak/ force / configure MySQL to use mutiple cpus/cores. so that the query runs faster.
Thanks in Advance
Replies
You are reading an archived discussion.
Related Posts
Walk-Ins for 2010 Batch Engineers (IT/ CS) / MCA
at Noida on Sunday, 28th November 2010
Experience
Freshers (2010 batch only)
Qualification
BE/ B.Tech/ MCA- Computer Sc/ IT
Eligibility...
[video=youtube;bgzjaJP_-Sk]https://www.youtube.com/watch?v=bgzjaJP_-Sk[/video]
Today's CrazyEngineers Day and all engineers are hooked to their computers to celebrate it with fellow CEans from over 180 countries :smile:
Here's official Chit-Chat thread for the CrazyEngineers Day....
How can I add a picture to a mail in gmail. I'm not talking about the attachment.
A picture file between the words in the composer. How do I add...
Celebrating 5 Crazy, Awesome Years of CrazyEngineers Community with candles...
We lit candles yesterday few hours before midnight to mark 5 successful years of CE. What say you?