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