MySQL Forums
Forum List  »  Performance

Utilization of multiple processors?
Posted by: Mark Modrall
Date: November 10, 2005 10:35AM

Hi...

I have MySql 4.1.14 running on a quad-proc x86/linux machine; I downloaded the straight rpm from the website.. I've noticed when I'm executing my queries that the load seems to be carried entirely on one processor. i.e. when I run top and watch the processes and cpu load distribution, one of the processors will be running at 98% and the other 3 almost completely idle.

I figured if you have a 2 or 3 table join, it might be able to utilize the other processors to help the throughput, but it doesn't appear to be the case.

Is there a configuration option I need to check, or build from source with a flag? Or when you submit a sql statement, is the work going to stick with 1 thread per connection and likely one processor?

Thanks
_Mark

Options: ReplyQuote


Subject
Views
Written By
Posted
Utilization of multiple processors?
18983
November 10, 2005 10:35AM
8903
February 17, 2006 12:01PM
8156
February 20, 2006 08:49PM
8202
February 21, 2006 06:45PM
7486
February 28, 2006 03:17PM
6792
December 18, 2007 01:55PM
5700
September 14, 2008 08:08PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.