MySQL Forums
Forum List  »  Performance

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


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?


Options: ReplyQuote

Written By
Utilization of multiple processors?
November 10, 2005 10:35AM
February 17, 2006 12:01PM
February 20, 2006 08:49PM
February 21, 2006 06:45PM
February 28, 2006 03:17PM
December 18, 2007 01:55PM
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.