List:General Discussion« Previous MessageNext Message »
From:Asif Iqbal Date:July 29 2003 2:55pm
Subject:Re: What is a good benchmark?
View as plain text  
On my E420R with 4 x 450MHz and 4 gb mem what mysql variables should I need to
play with to improve the following output

mysql> SELECT BENCHMARK(1000000,ENCODE("hello","goodbye"));
+----------------------------------------------+
| BENCHMARK(1000000,ENCODE("hello","goodbye")) |
+----------------------------------------------+
|                                            0 |
+----------------------------------------------+
1 row in set (2.89 sec)

Sorry for newbie question

On Tue, 29 Jul 2003, Dan Nelson wrote:

> 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.
>
>

-- 
Asif Iqbal
http://pgpkeys.mit.edu:11371/pks/lookup?op=get&search=0x8B686E08
There's no place like 127.0.0.1

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