Re: What is a good benchmark?
Now I am running these processes for my mysql serever /bin/sh /usr/local/mysql/bin/safe_mysqld --datadir=/usr/local/mysql/data --pid-file=/usr/local/mysql/data/webrt.pid /usr/local/mysql-standard-4.0.13-sun-solaris2.8-sparc/bin/mysqld --defaults-extra-file=/usr/local/mysql-standard-4.0.13-sun-solaris2.8-sparc/data/my.cnf --basedir=/usr/local/mysql-standard-4.0.13-sun-solaris2.8-sparc --datadir=/usr/local/mysql/data --user=mysql --pid-file=/usr/local/mysql/data/webrt.pid Now on the same logic if I run 4 pair ( the above two processes ) will it imporve my mysql query performance done through my DBIx::SeacrhBuilder ? Thanks On Tue, 29 Jul 2003, Dan Nelson wrote: In the last episode (Jul 29), Asif Iqbal said: Solaris SPARC 420R 4 * 450 MHz, 4GB - 2.93 secs ... Yikes.. Any suggestion on how to improve it ? Run it 4 times simultaneously in separate windows. You got 4 CPUs, use them :) All that benchmark query does is tell you how fast one cpu is. -- Asif Iqbal http://pgpkeys.mit.edu:11371/pks/lookup?op=getsearch=0x8B686E08 There's no place like 127.0.0.1 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: What is a good benchmark?
i got 0.96 on a dual XEON 2G 1G ram , its a dell box On Tue, Jul 29, 2003 at 01:41:00AM -0400, Asif Iqbal wrote: Solaris SPARC 420R 4 * 450 MHz, 4GB - 2.93 secs ... Yikes.. Any suggestion on how to improve it ? Get a faster CPU. -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 4.0.13: up 19 days, processed 575,681,006 queries (346/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: What is a good benchmark?
In the last episode (Jul 29), Asif Iqbal said: Now I am running these processes for my mysql serever /bin/sh /usr/local/mysql/bin/safe_mysqld --datadir=/usr/local/mysql/data --pid-file=/usr/local/mysql/data/webrt.pid /usr/local/mysql-standard-4.0.13-sun-solaris2.8-sparc/bin/mysqld --defaults-extra-file=/usr/local/mysql-standard-4.0.13-sun-solaris2.8-sparc/data/my.cnf --basedir=/usr/local/mysql-standard-4.0.13-sun-solaris2.8-sparc --datadir=/usr/local/mysql/data --user=mysql --pid-file=/usr/local/mysql/data/webrt.pid Now on the same logic if I run 4 pair ( the above two processes ) will it imporve my mysql query performance done through my DBIx::SeacrhBuilder ? No; the server will use as many CPUs as you have automatically. To take advantage of multiple CPUs you need multiple clients working in parallel. Oracle can split complicated queries into sections and let different processors work on each part (Parallel Query option), but mysql will only use one processor per query. -- Dan Nelson [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: What is a good benchmark?
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(100,ENCODE(hello,goodbye)); +--+ | BENCHMARK(100,ENCODE(hello,goodbye)) | +--+ |0 | +--+ 1 row in set (2.89 sec) Sorry for newbie question On Tue, 29 Jul 2003, Dan Nelson wrote: In the last episode (Jul 29), Asif Iqbal said: Now I am running these processes for my mysql serever /bin/sh /usr/local/mysql/bin/safe_mysqld --datadir=/usr/local/mysql/data --pid-file=/usr/local/mysql/data/webrt.pid /usr/local/mysql-standard-4.0.13-sun-solaris2.8-sparc/bin/mysqld --defaults-extra-file=/usr/local/mysql-standard-4.0.13-sun-solaris2.8-sparc/data/my.cnf --basedir=/usr/local/mysql-standard-4.0.13-sun-solaris2.8-sparc --datadir=/usr/local/mysql/data --user=mysql --pid-file=/usr/local/mysql/data/webrt.pid Now on the same logic if I run 4 pair ( the above two processes ) will it imporve my mysql query performance done through my DBIx::SeacrhBuilder ? No; the server will use as many CPUs as you have automatically. To take advantage of multiple CPUs you need multiple clients working in parallel. Oracle can split complicated queries into sections and let different processors work on each part (Parallel Query option), but mysql will only use one processor per query. -- Asif Iqbal http://pgpkeys.mit.edu:11371/pks/lookup?op=getsearch=0x8B686E08 There's no place like 127.0.0.1 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: What is a good benchmark?
Solaris SPARC 420R 4 * 450 MHz, 4GB - 2.93 secs ... Yikes.. Any suggestion on how to improve it ? On Wed, 23 Jul 2003, John May wrote: Xserve 1ghz - 1.08 sec G3 333mhz - 2.78 sec - John On my p4 2gig mysql SELECT BENCHMARK(100,ENCODE(hello,goodbye)); +--+ | BENCHMARK(100,ENCODE(hello,goodbye)) | +--+ |0 | +--+ 1 row in set (0.86 sec) -Original Message- From: Jake Johnson [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 23, 2003 8:34 AM 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(100,ENCODE(hello,goodbye)); +--+ | BENCHMARK(100,ENCODE(hello,goodbye)) | +--+ |0 | +--+ 1 row in set (2.59 sec) Regards, Jake Johnson [EMAIL PROTECTED] -- Asif Iqbal http://pgpkeys.mit.edu:11371/pks/lookup?op=getsearch=0x8B686E08 There's no place like 127.0.0.1 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: What is a good benchmark?
On Tue, Jul 29, 2003 at 01:41:00AM -0400, Asif Iqbal wrote: Solaris SPARC 420R 4 * 450 MHz, 4GB - 2.93 secs ... Yikes.. Any suggestion on how to improve it ? Get a faster CPU. -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 4.0.13: up 19 days, processed 575,681,006 queries (346/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: What is a good benchmark?
In the last episode (Jul 29), Asif Iqbal said: Solaris SPARC 420R 4 * 450 MHz, 4GB - 2.93 secs ... Yikes.. Any suggestion on how to improve it ? Run it 4 times simultaneously in separate windows. You got 4 CPUs, use them :) All that benchmark query does is tell you how fast one cpu is. -- Dan Nelson [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: What is a good benchmark?
I have only a G3 400 Mhz machine while not that fastest around I discovered something interesting. Here's numbers for a 20 run average using different terminal applications: Apple Terminal.app 2.8145 sec X-11 xterm 2.597 sec. The X-11 terminal was consistently faster than Apple's Terminal.app. Only 25% of the runs in xterm were slower than the fastest time in Terminal.app. I'm running MySQL 4.0.13. Just thought that it was interesting. On Wed, 23 Jul 2003 14:00:48 -0500, mos spoke thusly: At 01:45 PM 7/23/2003, you wrote: Is it me or do these dual athlons seem rather responsive! Yay!! I win (so far... heh)! Beat you by a nose. (Of course I had to run it 2 or 3 times to shave a couple hundreds of a second off the times)g A single P4 2.4 Ghz 1g RAM running MySQL 4.1.0 Alpha running on Win2k no less. Yes, you were beaten by a single horse CPU running on a Windoze machine (how are you going to live it downg). I'm surprised no one has 3ghz CPU's out there. I never thought my computer was that fast. Maybe it was the wind direction? Mike mysql select BENCHMARK(100,ENCODE(hello,goodbye)); +--+ | BENCHMARK(100,ENCODE(hello,goodbye)) | +--+ |0 | +--+ 1 row in set (0.53 sec) --- Listserv only address. Jeff Shapiro -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: What is a good benchmark?
On my p4 2gig mysql SELECT BENCHMARK(100,ENCODE(hello,goodbye)); +--+ | BENCHMARK(100,ENCODE(hello,goodbye)) | +--+ |0 | +--+ 1 row in set (0.86 sec) -Original Message- From: Jake Johnson [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 23, 2003 8:34 AM 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(100,ENCODE(hello,goodbye)); +--+ | BENCHMARK(100,ENCODE(hello,goodbye)) | +--+ |0 | +--+ 1 row in set (2.59 sec) Regards, Jake Johnson [EMAIL PROTECTED] __ 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/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: What is a good benchmark?
On my 1.8GHz p4 with 512Gig of RAM I get: mysql SELECT BENCHMARK(100,ENCODE(hello,goodbye)); +--+ | BENCHMARK(100,ENCODE(hello,goodbye)) | +--+ |0 | +--+ 1 row in set (0.91 sec) mysql John -Original Message- From: Bryan Koenig [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 23, 2003 10:46 AM To: [EMAIL PROTECTED] Subject: RE: What is a good benchmark? On my p4 2gig mysql SELECT BENCHMARK(100,ENCODE(hello,goodbye)); +--+ | BENCHMARK(100,ENCODE(hello,goodbye)) | +--+ |0 | +--+ 1 row in set (0.86 sec) -Original Message- From: Jake Johnson [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 23, 2003 8:34 AM 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(100,ENCODE(hello,goodbye)); +--+ | BENCHMARK(100,ENCODE(hello,goodbye)) | +--+ |0 | +--+ 1 row in set (2.59 sec) Regards, Jake Johnson [EMAIL PROTECTED] __ 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/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: What is a good benchmark?
Celeron 733 Windows 2000 MySQL 3.23.56-nt 1.63s 1.58s 1.58s Athlon 1GHz Debian 3 inside VMWare 3 (WinXP) MySQL 4.0.14 1.21s 1.22s 1.18s -yves -Ursprüngliche Nachricht- Von: Bryan Koenig [EMAIL PROTECTED] An: [EMAIL PROTECTED] Gesendet: Mittwoch, 23. Juli 2003 16:45 Betreff: RE: What is a good benchmark? On my p4 2gig mysql SELECT BENCHMARK(100,ENCODE(hello,goodbye)); +--+ | BENCHMARK(100,ENCODE(hello,goodbye)) | +--+ |0 | +--+ 1 row in set (0.86 sec) -Original Message- From: Jake Johnson [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 23, 2003 8:34 AM 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(100,ENCODE(hello,goodbye)); +--+ | BENCHMARK(100,ENCODE(hello,goodbye)) | +--+ |0 | +--+ 1 row in set (2.59 sec) Regards, Jake Johnson [EMAIL PROTECTED] __ 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/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: What is a good benchmark?
On my 2 * 2.8Ghz 2GB RAM, Redhat 8: mysql SELECT BENCHMARK(100,ENCODE(hello,goodbye)); +--+ | BENCHMARK(100,ENCODE(hello,goodbye)) | +--+ |0 | +--+ 1 row in set (0.66 sec) -Original Message- From: John Griffin [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 23, 2003 8:02 AM To: Bryan Koenig; [EMAIL PROTECTED] Subject: RE: What is a good benchmark? On my 1.8GHz p4 with 512Gig of RAM I get: mysql SELECT BENCHMARK(100,ENCODE(hello,goodbye)); +--+ | BENCHMARK(100,ENCODE(hello,goodbye)) | +--+ |0 | +--+ 1 row in set (0.91 sec) mysql John -Original Message- From: Bryan Koenig [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 23, 2003 10:46 AM To: [EMAIL PROTECTED] Subject: RE: What is a good benchmark? On my p4 2gig mysql SELECT BENCHMARK(100,ENCODE(hello,goodbye)); +--+ | BENCHMARK(100,ENCODE(hello,goodbye)) | +--+ |0 | +--+ 1 row in set (0.86 sec) -Original Message- From: Jake Johnson [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 23, 2003 8:34 AM 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(100,ENCODE(hello,goodbye)); +--+ | BENCHMARK(100,ENCODE(hello,goodbye)) | +--+ |0 | +--+ 1 row in set (2.59 sec) Regards, Jake Johnson [EMAIL PROTECTED] __ 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/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: What is a good benchmark?
Xserve 1ghz - 1.08 sec G3 333mhz - 2.78 sec - John On my p4 2gig mysql SELECT BENCHMARK(100,ENCODE(hello,goodbye)); +--+ | BENCHMARK(100,ENCODE(hello,goodbye)) | +--+ |0 | +--+ 1 row in set (0.86 sec) -Original Message- From: Jake Johnson [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 23, 2003 8:34 AM 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(100,ENCODE(hello,goodbye)); +--+ | BENCHMARK(100,ENCODE(hello,goodbye)) | +--+ |0 | +--+ 1 row in set (2.59 sec) Regards, Jake Johnson [EMAIL PROTECTED] -- --- John May : President http://www.pointinspace.com Point In Space Internet Solutions [EMAIL PROTECTED] LPA Corporate Partner / FSA Associate / ACN Member Lasso 5 + 6 / PHP / MySQL / FileMaker Pro Hosting Now Available! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: What is a good benchmark?
On my 1Ghz Mac PowerBook with 1GB RAM using version 4.0.13 with OS 10.2.6 mysql SELECT BENCHMARK(100,ENCODE(hello,goodbye)); +--+ | BENCHMARK(100,ENCODE(hello,goodbye)) | +--+ |0 | +--+ 1 row in set (1.07 sec) -- Jim Dickenson mailto:[EMAIL PROTECTED] Computers for Marketing Corporation http://www.cfmc.com/ From: Hubbard, Dan [EMAIL PROTECTED] Date: Wed, 23 Jul 2003 08:39:01 -0700 To: [EMAIL PROTECTED] Subject: RE: What is a good benchmark? On my 2 * 2.8Ghz 2GB RAM, Redhat 8: mysql SELECT BENCHMARK(100,ENCODE(hello,goodbye)); +--+ | BENCHMARK(100,ENCODE(hello,goodbye)) | +--+ |0 | +--+ 1 row in set (0.66 sec) -Original Message- From: John Griffin [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 23, 2003 8:02 AM To: Bryan Koenig; [EMAIL PROTECTED] Subject: RE: What is a good benchmark? On my 1.8GHz p4 with 512Gig of RAM I get: mysql SELECT BENCHMARK(100,ENCODE(hello,goodbye)); +--+ | BENCHMARK(100,ENCODE(hello,goodbye)) | +--+ |0 | +--+ 1 row in set (0.91 sec) mysql John -Original Message- From: Bryan Koenig [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 23, 2003 10:46 AM To: [EMAIL PROTECTED] Subject: RE: What is a good benchmark? On my p4 2gig mysql SELECT BENCHMARK(100,ENCODE(hello,goodbye)); +--+ | BENCHMARK(100,ENCODE(hello,goodbye)) | +--+ |0 | +--+ 1 row in set (0.86 sec) -Original Message- From: Jake Johnson [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 23, 2003 8:34 AM 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(100,ENCODE(hello,goodbye)); +--+ | BENCHMARK(100,ENCODE(hello,goodbye)) | +--+ |0 | +--+ 1 row in set (2.59 sec) Regards, Jake Johnson [EMAIL PROTECTED] __ 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/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: What is a good benchmark?
+--+ | BENCHMARK(100,ENCODE(hello,goodbye)) | +--+ |0 | +--+ 1 row in set (1.91 sec) PIII 850, with 1GB Ram. - Original Message - From: Jim Dickenson [EMAIL PROTECTED] To: MySQL Mail List [EMAIL PROTECTED] Sent: Wednesday, July 23, 2003 5:51 PM Subject: Re: What is a good benchmark? On my 1Ghz Mac PowerBook with 1GB RAM using version 4.0.13 with OS 10.2.6 mysql SELECT BENCHMARK(100,ENCODE(hello,goodbye)); +--+ | BENCHMARK(100,ENCODE(hello,goodbye)) | +--+ |0 | +--+ 1 row in set (1.07 sec) -- Jim Dickenson mailto:[EMAIL PROTECTED] Computers for Marketing Corporation http://www.cfmc.com/ From: Hubbard, Dan [EMAIL PROTECTED] Date: Wed, 23 Jul 2003 08:39:01 -0700 To: [EMAIL PROTECTED] Subject: RE: What is a good benchmark? On my 2 * 2.8Ghz 2GB RAM, Redhat 8: mysql SELECT BENCHMARK(100,ENCODE(hello,goodbye)); +--+ | BENCHMARK(100,ENCODE(hello,goodbye)) | +--+ |0 | +--+ 1 row in set (0.66 sec) -Original Message- From: John Griffin [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 23, 2003 8:02 AM To: Bryan Koenig; [EMAIL PROTECTED] Subject: RE: What is a good benchmark? On my 1.8GHz p4 with 512Gig of RAM I get: mysql SELECT BENCHMARK(100,ENCODE(hello,goodbye)); +--+ | BENCHMARK(100,ENCODE(hello,goodbye)) | +--+ |0 | +--+ 1 row in set (0.91 sec) mysql John -Original Message- From: Bryan Koenig [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 23, 2003 10:46 AM To: [EMAIL PROTECTED] Subject: RE: What is a good benchmark? On my p4 2gig mysql SELECT BENCHMARK(100,ENCODE(hello,goodbye)); +--+ | BENCHMARK(100,ENCODE(hello,goodbye)) | +--+ |0 | +--+ 1 row in set (0.86 sec) -Original Message- From: Jake Johnson [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 23, 2003 8:34 AM 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(100,ENCODE(hello,goodbye)); +--+ | BENCHMARK(100,ENCODE(hello,goodbye)) | +--+ |0 | +--+ 1 row in set (2.59 sec) Regards, Jake Johnson [EMAIL PROTECTED] __ 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/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: What is a good benchmark?
On my P3 600MHz 256MB RAM, Redhat 8: 1 row in set (2.01 sec) Hubbard, Dan [EMAIL PROTECTED] 07/23/03 11:39AM On my 2 * 2.8Ghz 2GB RAM, Redhat 8: mysql SELECT BENCHMARK(100,ENCODE(hello,goodbye)); +--+ | BENCHMARK(100,ENCODE(hello,goodbye)) | +--+ |0 | +--+ 1 row in set (0.66 sec) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: What is a good benchmark?
personal Win98 Duron650 128MB Mysql 4.0.13 - 1.37 sec busy server Redhat 7.0 Celeron 333 380MB Mysql 3.23.54 - 3.11 sec -Original Message- From: Jake Johnson [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 23, 2003 5:34 PM 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(100,ENCODE(hello,goodbye)); +--+ | BENCHMARK(100,ENCODE(hello,goodbye)) | +--+ |0 | +--+ 1 row in set (2.59 sec) Regards, Jake Johnson [EMAIL PROTECTED] __ 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/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: What is a good benchmark?
1 row in set (0.54 sec) 2x Athlon2100 2GB Ram Linux 2.4.20 -Original Message- From: Jake Johnson [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 23, 2003 9:34 AM 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(100,ENCODE(hello,goodbye)); +--+ | BENCHMARK(100,ENCODE(hello,goodbye)) | +--+ |0 | +--+ 1 row in set (2.59 sec) Regards, Jake Johnson [EMAIL PROTECTED] __ 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/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: What is a good benchmark?
Is it me or do these dual athlons seem rather responsive! I use mySQL 4.0.13 running on FreeBSD 4.8. Pentium 4 2.8Ghz 2GB DDR400 1 row in set (0.7 sec) | (0.68 sec) | (0.68 sec) Andrew. - Original Message - From: Christopher Knight [EMAIL PROTECTED] To: Mysql [EMAIL PROTECTED] Sent: Wednesday, July 23, 2003 6:46 PM Subject: RE: What is a good benchmark? 1 row in set (0.54 sec) 2x Athlon2100 2GB Ram Linux 2.4.20 -Original Message- From: Jake Johnson [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 23, 2003 9:34 AM 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(100,ENCODE(hello,goodbye)); +--+ | BENCHMARK(100,ENCODE(hello,goodbye)) | +--+ |0 | +--+ 1 row in set (2.59 sec) Regards, Jake Johnson [EMAIL PROTECTED] __ 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/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: What is a good benchmark?
Dual P3 933, 2 gig RAM, IDE RAID-5 +--+ | BENCHMARK(100,ENCODE(hello,goodbye)) | +--+ |0 | +--+ 1 row in set (1.40 sec) - Original Message - From: Christopher Knight [EMAIL PROTECTED] To: Mysql [EMAIL PROTECTED] Sent: Wednesday, July 23, 2003 10:46 AM Subject: RE: What is a good benchmark? 1 row in set (0.54 sec) 2x Athlon2100 2GB Ram Linux 2.4.20 -Original Message- From: Jake Johnson [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 23, 2003 9:34 AM 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(100,ENCODE(hello,goodbye)); +--+ | BENCHMARK(100,ENCODE(hello,goodbye)) | +--+ |0 | +--+ 1 row in set (2.59 sec) Regards, Jake Johnson [EMAIL PROTECTED] __ 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/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: What is a good benchmark?
I get the following on dual Athlon MP 1666MHz 1GB RAM which is 40% cpu loaded mysql SELECT BENCHMARK(100,ENCODE(hello,goodbye)); +--+ | BENCHMARK(100,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(100,ENCODE(hi,bye)); +---+ | BENCHMARK(100,ENCODE(hi,bye)) | +---+ | 0 | +---+ 1 row in set (0.32 sec) Only kidding about the abbreviations ;) Andrew -Original Message- From: Jake Johnson [mailto:[EMAIL PROTECTED] 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(100,ENCODE(hello,goodbye)); +--+ | BENCHMARK(100,ENCODE(hello,goodbye)) | +--+ |0 | +--+ 1 row in set (2.59 sec) Regards, Jake Johnson [EMAIL PROTECTED] __ 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/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: What is a good benchmark?
Is it me or do these dual athlons seem rather responsive! Yay!! I win (so far... heh)! 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 Athlons just preform better too. I use mySQL 4.0.13 running on FreeBSD 4.8. Pentium 4 2.8Ghz 2GB DDR400 1 row in set (0.7 sec) | (0.68 sec) | (0.68 sec) Andrew. 1 row in set (0.54 sec) 2x Athlon2100 2GB Ram Linux 2.4.20 Chris pIII 500 1 row in set (2.59 sec) Jake Johnson -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: What is a good benchmark?
I got disappointing results compared with the ones posted here:with a dual xeon 2Ghz, 2GB ram, freebsd 5.1, mysql mysql SELECT BENCHMARK(100,ENCODE(hello,goodbye)); +--+ | BENCHMARK(100,ENCODE(hello,goodbye)) | +--+ |0 | +--+ 1 row in set (1.10 sec) Any idea how to improve it? The cpu is 90% idle average. following my.cnf and configure options... my.cnf -- [mysqld] log-bin set-variable = max_connections=700 set-variable = max_connect_errors=100 safe-show-database set-variable = wait_timeout=120 set-variable = interactive_timeout=120 set-variable = myisam-recover=BACKUP,FORCE set-variable = key_buffer_size=500MB set-variable = sort_buffer_size=5M set-variable = read_buffer_size=2M set-variable = table_cache=512 set-variable = max_delayed_threads=0 set-variable = max_user_connections=25 set-variable = query_cache_size=50M set-variable = thread_cache_size=100 # INNODB innodb_data_home_dir = /var/mysql/data/INNODB innodb_buffer_pool_size = 80M innodb_additional_mem_pool_size = 5M innodb_log_buffer_size = 20M -- configure: ./configure \ --enable-static \ --with-innodb \ --without-berkeley-db \ --with-mysqld-user=mysql \ --without-debug \ --without-docs \ --without-gemini \ --without-mit-threads \ --without-perl \ --without-readline \ --without-docs \ --with-mysqld-ldflags=-all-static \ --enable-thread-safe-client \ --enable-local-infile \ --enable-assembler \ --with-extra-charsets=complex \ --with-named-thread-libs='-DHAVE_GLIBC2_STYLE_GETHOSTBYNAME_R -D_THREAD_SAFE -I/usr/local/include/pthread/linuxthreads -L/usr/local/lib -llthread -llgcc_r -llstdc++ -llsupc++' \ --with-comment='Superb Mysql Server' \ --localstatedir=/var/mysql/data \ --prefix=/var/mysql/mysql-4.0.13-2003-jul-08 Thanks for any hint... Andrew Braithwaite wrote: I get the following on dual Athlon MP 1666MHz 1GB RAM which is 40% cpu loaded mysql SELECT BENCHMARK(100,ENCODE(hello,goodbye)); +--+ | BENCHMARK(100,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(100,ENCODE(hi,bye)); +---+ | BENCHMARK(100,ENCODE(hi,bye)) | +---+ | 0 | +---+ 1 row in set (0.32 sec) Only kidding about the abbreviations ;) Andrew -Original Message- From: Jake Johnson [mailto:[EMAIL PROTECTED] 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(100,ENCODE(hello,goodbye)); +--+ | BENCHMARK(100,ENCODE(hello,goodbye)) | +--+ |0 | +--+ 1 row in set (2.59 sec) Regards, Jake Johnson [EMAIL PROTECTED] __ Plutoid - http://www.plutoid.com - Shop Plutoid for the best prices on Rims, Car Audio, and Performance Parts. -- -- Gustavo Baratto - Programming and Technical Support [EMAIL PROTECTED] * (604) 638-2525 ext. 408 Technical support web-site: http://support.superb.net Superb Internet Corp. Ahead of the Rest - -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: What is a good benchmark?
At 01:45 PM 7/23/2003, you wrote: Is it me or do these dual athlons seem rather responsive! Yay!! I win (so far... heh)! Beat you by a nose. (Of course I had to run it 2 or 3 times to shave a couple hundreds of a second off the times)g A single P4 2.4 Ghz 1g RAM running MySQL 4.1.0 Alpha running on Win2k no less. Yes, you were beaten by a single horse CPU running on a Windoze machine (how are you going to live it downg). I'm surprised no one has 3ghz CPU's out there. I never thought my computer was that fast. Maybe it was the wind direction? Mike mysql select BENCHMARK(100,ENCODE(hello,goodbye)); +--+ | BENCHMARK(100,ENCODE(hello,goodbye)) | +--+ |0 | +--+ 1 row in set (0.53 sec) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]