List:General Discussion« Previous MessageNext Message »
From:Ow Mun Heng Date:July 24 2003 2:22am
Subject:RE: RES: What is a good benchmark?
View as plain text  
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:ntlug@stripped]
Sent: Thursday, July 24, 2003 12:11 AM
To: mysql@stripped
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?

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