Re: RES: What is a good benchmark?
snip On my p4 2gig mysql SELECT BENCHMARK(100,ENCODE(hello,goodbye)); +--+ | BENCHMARK(100,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(100,ENCODE(hello,goodbye)); +--+ | BENCHMARK(100,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(100,ENCODE(hello,goodbye)); +--+ | BENCHMARK(100,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(100,ENCODE(hello,goodbye)); +--+ | BENCHMARK(100,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]
RE: RES: What is a good benchmark?
Had Free Time.. hehe.. AMD 1900+ (512RAM) 0.61 P4 2*2.8(2GB RAM) 0.66 P4 2GHz(? RAM) 0.86 P4 1.8G(512 RAM)0.91 1G Mac Pbook(1GB RAM) 1.07 AMD 1GHZ1.21 Celeron 733(win2k) 1.63 P3 850Mhz 1.91 G3 333Mhz 2.78 PII 300Mhz (512MB) 4.27--- This is MINE Based on Above Results, AMD Tops the list.. Why is that?? the Dual P4 2.8Ghz losses out to the AMD. Floating point performance AMD 1900+ and P4 2Ghz diff by 0.25 secs. Hmm.. seems like I'm the slowest of the lot.. (hang on.. I've yet to test it on my Laptop, my 5 1/2 yr old Dell Latitude 166MMX with 72MB Ram) I'm sure It's BLAZING slow..:) 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(100,ENCODE(hello,goodbye)); +--+ | BENCHMARK(100,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(100,ENCODE(hello,goodbye)); +--+ | BENCHMARK(100,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(100,ENCODE(hello,goodbye)); +--+ | BENCHMARK(100,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(100,ENCODE(hello,goodbye)); +--+ | BENCHMARK(100,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]
RE: RES: What is a good benchmark?
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 1GHZ1.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(100,ENCODE(hello,goodbye)); +--+ | BENCHMARK(100,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(100,ENCODE(hello,goodbye)); +--+ | BENCHMARK(100,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(100,ENCODE(hello,goodbye)); +--+ | BENCHMARK(100,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(100,ENCODE(hello,goodbye)); +--+ | BENCHMARK(100,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]