Hi Miki, in linux there is still no way for the user to chose the CPU a process is to be ran on; no way for the user to chose the affinity of the process. The scheduler takes care of that (quite well if I might add). Single process cannot run at the same time on more then one CPU, that is where threading comes in handy. A single process can have more then one thread, and each one will be scheduled to a different CPU when needed. MySQL is a threaded applications and it will make full use of your other CPUs when loaded enough. You should make sure you have tuned your MySQL install to achieve best performance and suck the most out of your box.
Kind regards, Alex Behar On Thursday 14 April 2005 11:48, Miki Lewinger wrote: > Hi there. I'm running a bioinformatics server with RH 9.0 on a dual-xeon > machine with a mobo intel 7505 motherboard on 2 GB RAM. mysql refuses to > use both CPUs at once for any given process, and even if I run 2 mysql > queries at once, both are run on the same CPU. I've googled for this and > couldn't find any relevant response regarding why and how to fix this > single X dual CPU issue for mysql ? > > Additional info: > > mysql version 3.23.58-1.9 > kernel version 2.4.20-31.9smp > > Thanks in advance, > > Miki Lewinger > Ben-Gurion University > > ================================================================= > To unsubscribe, send mail to [EMAIL PROTECTED] with > the word "unsubscribe" in the message body, e.g., run the command > echo unsubscribe | mail [EMAIL PROTECTED] -- The difference between theory and practice, is that in theory, there is no difference between theory and practice. ================================================================= To unsubscribe, send mail to [EMAIL PROTECTED] with the word "unsubscribe" in the message body, e.g., run the command echo unsubscribe | mail [EMAIL PROTECTED]
