List:General Discussion« Previous MessageNext Message »
From:Dan Nelson Date:July 29 2003 2:40pm
Subject:Re: What is a good benchmark?
View as plain text  
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
Thread
What is a good benchmark?Jake Johnson23 Jul
  • RE: What is a good benchmark?Bryan Koenig23 Jul
    • Re: What is a good benchmark?Yves Goergen23 Jul
    • RES: What is a good benchmark?julio23 Jul
      • RES: What is a good benchmark?julio23 Jul
      • Re: RES: What is a good benchmark?NTLUG23 Jul
  • RE: What is a good benchmark?artem23 Jul
  • RE: What is a good benchmark?Christopher Knight23 Jul
    • Re: What is a good benchmark?Andrew Edwards23 Jul
      • RE: What is a good benchmark?Christopher Knight23 Jul
        • RE: What is a good benchmark?mos23 Jul
          • RE: What is a good benchmark?Jeff Shapiro26 Jul
    • Re: What is a good benchmark?David Griffiths23 Jul
RE: What is a good benchmark?John Griffin23 Jul
RE: What is a good benchmark?Dan Hubbard23 Jul
  • Re: What is a good benchmark?Jim Dickenson23 Jul
    • Re: What is a good benchmark?Chris Knipe23 Jul
    • EXPLAIN - Question..Tom O'Neill \(MySQL User\)23 Jul
RE: What is a good benchmark?John May23 Jul
  • RE: What is a good benchmark?Asif Iqbal29 Jul
    • Re: What is a good benchmark?Jeremy Zawodny29 Jul
      • Re: What is a good benchmark?daniel29 Jul
    • Re: What is a good benchmark?Dan Nelson29 Jul
      • Re: What is a good benchmark?Asif Iqbal29 Jul
        • Re: What is a good benchmark?Dan Nelson29 Jul
          • Re: What is a good benchmark?Asif Iqbal29 Jul
            • Re: What is a good benchmark?Dan Nelson29 Jul
RE: What is a good benchmark?Mark Graves23 Jul
RE: What is a good benchmark?Andrew Braithwaite23 Jul
  • Re-attaching DB to mysqlHenrik Schmiediche23 Jul
    • Re: Re-attaching DB to mysqlEgor Egorov24 Jul
  • Re: What is a good benchmark?Gustavo A. Baratto23 Jul
RE: Re-attaching DB to mysqlAndrew Braithwaite23 Jul
  • RE: Re-attaching DB to mysqlHenrik Schmiediche23 Jul
    • Re: Re-attaching DB to mysqlNils Valentin24 Jul
RE: Re-attaching DB to mysqlAndrew Braithwaite23 Jul
  • RE: Re-attaching DB to mysqlHenrik Schmiediche23 Jul
RE: Re-attaching DB to mysqlAndrew Braithwaite23 Jul
RE: Re-attaching DB to mysqlAndrew Braithwaite23 Jul
RE: RES: What is a good benchmark?Ow Mun Heng24 Jul
RE: RES: What is a good benchmark?Ow Mun Heng24 Jul
Re: Re-attaching DB to mysqlNils Valentin24 Jul