From: Dan Nelson
Date: July 29 2003 2:40pm
Subject: Re: What is a good benchmark?
List-Archive: http://lists.mysql.com/mysql/146407
Message-Id: <20030729144051.GF3058@dan.emsphone.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

In the last episode (Jul 29), Asif Iqbal said:
> Now I am running these processes for my mysql serever
> 
> /bin/sh /usr/local/mysql/bin/safe_mysqld --datadir=/usr/local/mysql/data
> --pid-file=/usr/local/mysql/data/webrt.pid
> 
> /usr/local/mysql-standard-4.0.13-sun-solaris2.8-sparc/bin/mysqld
> --defaults-extra-file=/usr/local/mysql-standard-4.0.13-sun-solaris2.8-sparc/data/my.cnf
> --basedir=/usr/local/mysql-standard-4.0.13-sun-solaris2.8-sparc
> --datadir=/usr/local/mysql/data --user=mysql
> --pid-file=/usr/local/mysql/data/webrt.pid
> 
> 
> Now on the same logic if I run 4 pair ( the above two processes )
> will it imporve my mysql query performance done through my
> DBIx::SeacrhBuilder ?

No; the server will use as many CPUs as you have automatically.  To
take advantage of multiple CPUs you need multiple clients working in
parallel.  Oracle can split complicated queries into sections and let
different processors work on each part (Parallel Query option), but
mysql will only use one processor per query.

-- 
	Dan Nelson
	dnelson@stripped