Re: What is a good benchmark?
In the last episode (Jul 29), Asif Iqbal said:
> 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)
The only thing that will improve that specific query is a faster CPU.
The number of CPUs and the amount of RAM is unimportant.
--
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=get&search=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?
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?
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?
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=get&search=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?
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?
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?
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=get&search=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 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)
> 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 down).
> 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?
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)
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 down).
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]
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?
>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 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?
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?
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?
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?
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?
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?
+--+
| 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 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?
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
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 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?
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 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?
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]
