Hi Richard, Correct. A single thread can only run on 1 CPU at any given time, even though the OS may switch the thread between CPUs over time.
Matt ----- Original Message ----- From: "Richard Bewley" Sent: Saturday, November 01, 2003 9:48 PM Subject: RE: mySQL with a quad processor system > Thanks for the response. The CPU's are 450MHz each, and the system has 3 GB > RAM. It works pretty nicely. But, they would have to be separate queries > to span the 4 CPU's? I guess one thread can't span across them... > > Thanks, > Richard > > -----Original Message----- > From: Matt W [mailto:[EMAIL PROTECTED] > Sent: Saturday, November 01, 2003 10:34 PM > To: Richard Bewley; [EMAIL PROTECTED] > Subject: Re: mySQL with a quad processor system > > Hi Richard, > > Nope, since your OS can run the threads on different CPUs (unlike > FreeBSD w/o LinuxThreads for example). You just need 4+ threads > (clients) running queries at once. :-) > > BTW, what kind of system? How fast are those 4 CPUs? ;-) > > > Matt > > > ----- Original Message ----- > From: "Richard Bewley" > Sent: Saturday, November 01, 2003 7:58 PM > Subject: mySQL with a quad processor system > > > > Hi, > > > > I'm setting up a machine that will have a rather heavy load on it, > with > > mysql that has 4 processors. It's running RedHat Linux 9.0, with a > kernel > > with SMP to support the multiple processors. Is there anything > special I > > need to do with mySQL to get it to take advantage of the multiple > CPU's? > > > > Thanks, > > Richard -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]