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
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
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
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)) |
[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
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/
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.
--
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
|
+--+
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
|
+--+
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
: 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.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
)) |
+--+
|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
]
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
PROTECTED]
Assunto: 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.92 sec)
mysql
Julio
-Mensagem original-
De: Bryan Koenig [mailto:[EMAIL PROTECTED]
Enviada em: quarta-feira, 23 de julho de 2003 11:46
Para: [EMAIL PROTECTED]
Assunto: RE: What is a good benchmark
.
- 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
snip
On my p4 2gig
mysql SELECT BENCHMARK(100,ENCODE(hello,goodbye));
+--+
| BENCHMARK(100,ENCODE(hello,goodbye)) |
+--+
|0 |
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)) |
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
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
: 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
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
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
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
:[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
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
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
[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
29 matches
Mail list logo