List:General Discussion« Previous MessageNext Message »
From:Andrew Braithwaite Date:July 23 2003 6:36pm
Subject:RE: What is a good benchmark?
View as plain text  
I get the following on dual Athlon MP 1666MHz 1GB RAM which is 40% cpu
loaded

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

This result doesn't take into account disk speed I/O etc - so this test will
only be relevent for cpu speed.

However, If you're worried about performance and want to speed it up a bit,
use abbreviated english in your queries like this:

mysql> SELECT BENCHMARK(1000000,ENCODE("hi","bye"));
+---------------------------------------+
| BENCHMARK(1000000,ENCODE("hi","bye")) |
+---------------------------------------+
|                                     0 |
+---------------------------------------+
1 row in set (0.32 sec)

Only kidding about the abbreviations ;)

Andrew

-----Original Message-----
From: Jake Johnson [mailto:jake@stripped] 
Sent: Wednesday 23 July 2003 15:34
To: Mysql
Subject: What is a good benchmark? 


I ran this benchmark on my pIII 500 and was wondering what everyone else was
getting?

mysql> SELECT BENCHMARK(1000000,ENCODE("hello","goodbye"));

+----------------------------------------------+
| BENCHMARK(1000000,ENCODE("hello","goodbye")) |
+----------------------------------------------+
|                                            0 |
+----------------------------------------------+
1 row in set (2.59 sec)


Regards,
Jake Johnson
jake@stripped

______________________________________________________________________
Plutoid - http://www.plutoid.com - Shop Plutoid for the best prices on Rims,
Car Audio, and Performance Parts.


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=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