Had Free Time.. hehe.. (MORE included I'm Still Slowest!! Where's
HyperThreading??)
P4 2.4GHz (1GB RAM) 0.53 (on Win2K) Maybe cpu no loaded??
2x Athlon2100(2GB RAM) 0.54 <--FASTEST -> Tuning parameters below
AMD 1900+ (512RAM) 0.61
AMD 1666Mhz(1GB RAM) 0.64
P4 2*2.8(2GB RAM) 0.66
P4 2.8 (@GB RAM) 0.68
P4 2GHz(? RAM) 0.86
P4 1.8G(512 RAM) 0.91
1G Mac Pbook(1GB RAM) 1.07
Xeon 2*2Ghz(2GB RAM) 1.10
AMD 1GHZ 1.21
P3 2*933mhz(2GB RAM) 1.40
Celeron 733(win2k) 1.63
P3 850Mhz 1.91
G3 333Mhz 2.78
PII 300Mhz (512MB) 4.27 <--- This is MINE
<----Chris's comments--->
I ran it on one of our servers (not idle... running apache w/ CGIs and db
calls ~ 140,000 scripts/day )
We are using as many tricks as we can.
0. mysql 4.0 binary from mysql.com
1. we set the nice to -15 in safe_mysqld (good trick.. be must be
carefull not to over do it)
2. my.cnf
skip-locking
set-variable = lower_case_table_names=1
set-variable = sort_buffer=50M
set-variable = record_buffer=2M
set-variable = key_buffer=64M
set-variable = query_cache_size=5M
set-variable = thread_stack=2K
set-variable = thread_cache=8
set-variable = thread_concurrency=4
3. Kernel is custom compiled with minimal drivers. Only
what hardware is on the system is compiled. No modules.
4. I think the Athlns just preform better too.
<-----ENd Chris comments--->
Cheers,
Mun Heng, Ow
H/M Engineering
Western Digital M'sia
DID : 03-7870 5168
-----Original Message-----
From: NTLUG [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 24, 2003 12:11 AM
To: [EMAIL PROTECTED]
Subject: Re: RES: What is a good benchmark?
<snip>
> On my p4 2gig
>
> mysql> SELECT BENCHMARK(1000000,ENCODE("hello","goodbye"));
> +----------------------------------------------+
> | BENCHMARK(1000000,ENCODE("hello","goodbye")) |
> +----------------------------------------------+
> | 0 |
> +----------------------------------------------+
> 1 row in set (0.86 sec)
<snip>
> 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)
>
Dual Athlon 1900+ RedHat 8 512MB RAN (Mysql 3.23.56-log - development
box so only 1 user)
mysql> select BENCHMARK(1000000,ENCODE("hello","goodbye"));
+----------------------------------------------+
| BENCHMARK(1000000,ENCODE("hello","goodbye")) |
+----------------------------------------------+
| 0 |
+----------------------------------------------+
1 row in set (0.61 sec)
Dual P3-600 Redhat 7.3 1GB RAM(Mysql 3.23.56-log - busy server)
mysql> select BENCHMARK(1000000,ENCODE("hello","goodbye"));
+----------------------------------------------+
| BENCHMARK(1000000,ENCODE("hello","goodbye")) |
+----------------------------------------------+
| 0 |
+----------------------------------------------+
1 row in set (2.61 sec)
--
Woody
In a world without boundaries why
do we need Gates and Windows?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
