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

In the last episode (Jul 29), Asif Iqbal said:
> 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)

The only thing that will improve that specific query is a faster CPU. 
The number of CPUs and the amount of RAM is unimportant.

-- 
	Dan Nelson
	dnelson@stripped