How to benchmark OpenBSD for Mysql .

2010-02-28 Thread Andres Salazar
Hello, Iam a OpenBSD user. I would like to know if there is any technique specific to the US to be able to benchmark the IO for this OS. Also, what result would be considered acceptable and what is not. Thanks!! Andres -- MySQL General Mailing List For list archives: http://lists.mysql.com

Re: MySQL TPC benchmark

2008-10-13 Thread Xuekun Hu
You may try DBT2 (TPC-C like) workload. On Sat, Oct 11, 2008 at 6:31 AM, Sachin Gaikwad <[EMAIL PROTECTED]> wrote: > On Fri, Oct 10, 2008 at 6:29 PM, Martin Gainty <[EMAIL PROTECTED]> wrote: >> Hello Sachin >> >> have you looked at using Benchmark Suite? >>

Re: MySQL TPC benchmark

2008-10-10 Thread Sachin Gaikwad
On Fri, Oct 10, 2008 at 6:29 PM, Martin Gainty <[EMAIL PROTECTED]> wrote: > Hello Sachin > > have you looked at using Benchmark Suite? > http://dev.mysql.com/doc/refman/5.0/en/mysql-benchmarks.html Yes, I am looking at it now. But still I need TPC benchmark which is standard in

MySQL TPC benchmark

2008-10-10 Thread Sachin Gaikwad
Hi all Is there a MySQL TPC benchmark available to download ? If someone is aware of such a thing, let me know. Thanks, Sachin -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Relational Databasing on busy webserver (Benchmark of Enum?!)

2008-09-23 Thread Micah Stevens
On 09/23/2008 02:42 PM, Ben A.H. wrote: I figured that was what you meant... I guess my table didn't work (see above message...don't ya' love plaintext :-O)... Has anyone ever tried to benchmark the difference between utilizing ENUMs vs. traditional relational databasing? I w

Re: Relational Databasing on busy webserver (Benchmark of Enum?!)

2008-09-23 Thread Ben A.H.
I figured that was what you meant... I guess my table didn't work (see above message...don't ya' love plaintext :-O)... Has anyone ever tried to benchmark the difference between utilizing ENUMs vs. traditional relational databasing? I would think ENUM is ideal for items I s

Disk Benchmark Tool

2008-01-31 Thread Ben Clewett
Dear List, I am after a tool which benchmarks a file system in the same way that a MySql InnoDB system is likely to access it. That is, small random reads and writes in a very large file. For instance, the tool 'bonnie++' is no good for this as is concentrates too much on sequential read and

Suggested tools to benchmark configuration changes

2007-09-11 Thread Rob Wultsch
I have a server that has several hundred table in a few different databases comprising almost a gig of data, all running on a rather old (3.23) version of mysql. I have used the slow query log to identify queries and have optimized the queries significantly. At this point the entries in the slow-q

Re: interesting benchmark at tweakers.net

2006-12-19 Thread David Sparks
Jochem van Dieten wrote: > On 12/19/06, David Sparks wrote: >> I noticed an interesting benchmark at tweakers.net that shows mysql not >> scaling very well on hyperthreading and multicore cpus (see links at end >> of email). >> >> Does anyone know what engi

Re: interesting benchmark at tweakers.net

2006-12-19 Thread Jochem van Dieten
On 12/19/06, David Sparks wrote: I noticed an interesting benchmark at tweakers.net that shows mysql not scaling very well on hyperthreading and multicore cpus (see links at end of email). Does anyone know what engine they are using for their tests? (Innodb, myisam, berkdb heheh) InnoDB, the

interesting benchmark at tweakers.net

2006-12-18 Thread David Sparks
I noticed an interesting benchmark at tweakers.net that shows mysql not scaling very well on hyperthreading and multicore cpus (see links at end of email). Does anyone know what engine they are using for their tests? (Innodb, myisam, berkdb heheh) In fact they seem to show that postgres is a

Re: Benchmark()

2005-12-15 Thread Gleb Paharenko
Hello. In your query BENCHMARK() doesn't execute the query, it is passed just like a string to the second argument of the BENCHMARK(). Raimundo Sierra wrote: > It is not clear to me what benchmark really does. Example: > > SELECT SQL_NO_CACHE * FROM mytable where myV

RE: Benchmark()

2005-12-15 Thread emierzwa
ssage- From: Raimundo Sierra [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 14, 2005 9:37 PM To: mysql@lists.mysql.com Subject: Benchmark() It is not clear to me what benchmark really does. Example: SELECT SQL_NO_CACHE * FROM mytable where myVarcharRow like 'sometext%'

Benchmark()

2005-12-14 Thread Raimundo Sierra
It is not clear to me what benchmark really does. Example: SELECT SQL_NO_CACHE * FROM mytable where myVarcharRow like 'sometext%' or otherVarcharRow like 'someothertext'; takes approx. 0.3 seconds. If you benchmark this query, which to my understanding should run and not

Re: How to benchmark performans

2005-10-02 Thread Gleb Paharenko
Hello. See: http://dev.mysql.com/doc/mysql/en/mysql-benchmarks.html OKAN ARI wrote: > How can I test the performans benchmark of my MYSQL? > For instance how can I learn query per second information? And any other > informatioin? > > Thanks > > --

How to benchmark performans

2005-09-19 Thread OKAN ARI
How can I test the performans benchmark of my MYSQL? For instance how can I learn query per second information? And any other informatioin? Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Benchmark of MyISAM vs Innodb vs Innod without FKs?!

2005-09-13 Thread Gleb Paharenko
Hello. Usually only benchmarks will show a real picture for you. Create foreign keys, perform some tests. Then temporary disable FKs using SET FOREIGN_KEY_CHECKS=0 and repeat the performance measurement. Super Smack is a good tool for such kind of analysis. See: http://dev.mysql.com/doc/

Benchmark of MyISAM vs Innodb vs Innod without FKs?!

2005-09-12 Thread Kevin Burton
Here's some thing I've been thinking about. I want to use INNODB without FKs. I don't need or want referential integrity in my app (due to a schema and performance issue). Basically I just create FKs in my OR layer and my app enforces the rules. The column is still an _ID column so I visually k

Re: MySQL Benchmark. OT and beyond...

2004-05-31 Thread RV Tec
Folks, > FreeBSD 5.x does a lot of things really well, and it can be very > fast too, but there's no stable release of 5.x yet, and the 5.x > code is clearly hampered speedwise by the presence of loads of > debugging code. From the 5.x documentation: > > --- > NOTE TO PEOPLE WHO THINK THAT FreeBSD

Re: MySQL Benchmark. OT and beyond...

2004-05-31 Thread Jesse Sheidlower
#x27;t yet feel comfortable with using on production > > machines. Only one of those issues is with benchmark numbers, but that > > is certainly one of them. > > If you don't feel comfortable with 5_branch on production, that's fine, I > respect your choice.

RE: MySQL Benchmark.

2004-05-29 Thread JG
At 05:12 PM 5/29/2004 -0500, you wrote: Now the fun part becomes which linux distro do you use? Which is faster? Because trust me, each distro will benchmark differently. Let the games begin! Donny I've seen benchmarks from people who did different linux distros, and they were all pretty

RE: MySQL Benchmark.

2004-05-29 Thread Donny Simonton
Now the fun part becomes which linux distro do you use? Which is faster? Because trust me, each distro will benchmark differently. Let the games begin! Donny > -Original Message- > From: JG [mailto:[EMAIL PROTECTED] > Sent: Saturday, May 29, 2004 4:34 PM > To: [EMA

Re: MySQL Benchmark.

2004-05-29 Thread JG
ng on production machines. Only one of those issues is with benchmark numbers, but that is certainly one of them. Thank you, Eric I'll try FreeBSD 4.x later (with LinuxThreads) but I don't see how it will do much better. - Jeremy I tried 4.10 FreeBSD with LinuxThreads using default mysq

Re: MySQL Benchmark.

2004-05-27 Thread JG
those issues is with benchmark numbers, but that is certainly one of them. Thank you, Eric Eric, The FreeBSD dev team sure isn't saying this. We have/had lengthy threads going in FreeBSD-threads and other mailing lists regarding this problem, nobody brought up running 4.x there. The FreeBS

Re: MySQL Benchmark. OT and beyond...

2004-05-27 Thread RV Tec
Err... I guess I owe Jeremy Zawodny an apology for mistyping his name. I promise next time I won't type without reading. His site is at http://jeremy.zawodny.com/. And I really recommend his book "High Performance MySQL". Sorry for the typo, Zawodny! RV Tec -- MySQL General Mailing List For li

Re: MySQL Benchmark. OT and beyond...

2004-05-27 Thread RV Tec
Eric, > I am sure all FreeBSD users are sick and tired of saying this. USE > 4.10 > Lots of people blindly follow version numbers but 5.x is a lot different > than 4.x in ways I don't yet feel comfortable with using on production > machines. Only one of those issu

Re: MySQL Benchmark. OT and beyond...

2004-05-27 Thread Eric
Hi, I am sure all FreeBSD users are sick and tired of saying this. USE 4.10 Lots of people blindly follow version numbers but 5.x is a lot different than 4.x in ways I don't yet feel comfortable with using on production machines. Only one of those issues is with benchmark numbers, but

Re: MySQL Benchmark.

2004-05-27 Thread RV Tec
JG, > I am a FreeBSD user, but after having run benchmarks for > the past 2 weeks, I think you'll be surprised when you see > the results from Linux. > > Linux will outperform *BSD by nearly double when it comes to > MySQL. That's what I expect and hope for. Although, I thought that FreeBSD wou

Re: MySQL Benchmark.

2004-05-27 Thread JG
Facing this new scenario, I am going to give Linux a shot -- definitively, this one is going to outperform OpenBSD. Using the same hardware, and the same options (as possible). Does anyone have a hint for this? Again, thanks a lot! Best regards, RV Tec I am a FreeBSD user, but after

MySQL Benchmark.

2004-05-27 Thread RV Tec
Folks, Following some advices, I have decided to give FreeBSD a shot. So, I got one test machine (P4 2.0GHz, 512MB), installed FreeBSD 5.2.1 on one disk, and OpenBSD 3.5 on the other (both 40GB 7200RPM IDE disks) -- so I could compare the results. MySQL (4.0.20) is compiled from source, u

Re: Innodb multiple tablespaces benchmark

2003-12-17 Thread Heikki Tuuri
Carlos, - Original Message - From: ""Carlos Proal"" <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Friday, December 12, 2003 4:09 AM Subject: Innodb multiple tablespaces benchmark > > > Hi all, specially to Heikki. > > Its rea

Innodb multiple tablespaces benchmark

2003-12-11 Thread Carlos Proal
Hi all, specially to Heikki. Its really amazing that multiple tablespaces are available before 2004, congratulations to Innodb Oy Inc. Right now im migrating from 4.1.0 to 4.1.1 but im figuring out if there is a downgrade in performance in order to use multiple tablespaces, obviously it must

Possible benchmark for mySQL?

2003-12-04 Thread beacker
Hello, I'm in the midst of using mySQL for some genetic information searching based upon the GenBank data from the NCBI, National Center for Biotechnology Information. In doing some testing on using mySQL, and began to wonder if this data set would be of interest as a benchmark fo

Re: Benchmark differences: Mac OS X - Linux

2003-11-07 Thread Gabriel Ricard
On Friday, November 7, 2003, at 09:05 AM, David Steinbrunner wrote: The Mac was HFS+ journaled. Disk: the stock Apple-supplied one. The Linux machine was a default SuSE 8.0 installation. ext2 as the filesystem? No idea about journaling. No SCSI or RAID, just an internal IDE disk. Both machines a

Re: Benchmark differences: Mac OS X - Linux

2003-11-07 Thread David Steinbrunner
The Mac was HFS+ journaled. Disk: the stock Apple-supplied one. The Linux machine was a default SuSE 8.0 installation. ext2 as the filesystem? No idea about journaling. No SCSI or RAID, just an internal IDE disk. Both machines are really consumer-level machines, no heavy-duty server hardware. That

Re: Benchmark differences: Mac OS X - Linux

2003-11-06 Thread Jeremy Zawodny
usr 0.00 sys + 0.00 > cusr 0.00 csys = 881.86 CPU) > > Does that mean anything in this regard? Run the benchmark again. Notice if the CPU is consistently around 100% or not. If not, it's disk bound. Otherwise, it's CPU bound. > >What are the filesystems like on each

Re: Benchmark differences: Mac OS X - Linux

2003-11-06 Thread Jan Pieter Kunst
I just installed Panther on my G5 at home. Unfortunately, for some reason I can't get the Perl module DBD::mysql to install (using CPAN, had no problems doing this in Jaguar) so I can't run the benchmark suite for now. JP I had similar issues, but I was also using a custom buil

Re: Benchmark differences: Mac OS X - Linux

2003-11-06 Thread Jan Pieter Kunst
Jeremy D. Zawodny: > I was wondering if there is something I can do, configuration-wise, to do something about those very slow 'inserts' (and 'updates') on the Mac? Thanks in advance for any insight, Did it appear to be disk or CPU bound? Sorry, newbie here. I don't know how I can tell. The RU

Re: Benchmark differences: Mac OS X - Linux

2003-11-06 Thread Gabriel Ricard
;t get the Perl module DBD::mysql to install (using CPAN, had no problems doing this in Jaguar) so I can't run the benchmark suite for now. JP I had similar issues, but I was also using a custom build of MySQL, which was not in a standard location. Try this: perl Makefile.PL --cflags=-I/p

Re: Benchmark differences: Mac OS X - Linux

2003-11-06 Thread Jeremy Zawodny
On Thu, Nov 06, 2003 at 10:19:59AM -0700, Van wrote: > > Jeremy: > > I believe that's what I was attempting to convey. My suggestion was that the > G4 should not be disk bound (limited by disk bandwidth). The CPU on my DEC > Alpha is a meagerly 300, but the disk can stream faster than my PIII t

Re: Benchmark differences: Mac OS X - Linux

2003-11-06 Thread Van
Jeremy: I believe that's what I was attempting to convey. My suggestion was that the G4 should not be disk bound (limited by disk bandwidth). The CPU on my DEC Alpha is a meagerly 300, but the disk can stream faster than my PIII true Intel 733MHz. That's why I suggested he look at the disk / c

Re: Benchmark differences: Mac OS X - Linux

2003-11-06 Thread Jeremy Zawodny
On Thu, Nov 06, 2003 at 09:56:22AM -0700, Van wrote: > > I can't imagine a G4 would be disk bound relative to an Intel machine, unless > there is something very wrong with the disk or controller. Also, you might want > to defrag your disk on the Mac. > > G4s have much more disk bandwidth than an

Re: Benchmark differences: Mac OS X - Linux

2003-11-06 Thread Van
te: > On Wed, Nov 05, 2003 at 07:57:00PM +0100, Jan Pieter Kunst wrote: > > Hi everyone, > > > > I recently ran the MySQL benchmark suite on a Dual 1 GHz G4 running Mac > > OS X Server 10.2.8, and an 800 MHz Intel machine running SuSE Linux 8.0. > > Both instal

Re: Benchmark differences: Mac OS X - Linux

2003-11-06 Thread Jan Pieter Kunst
s doing this in Jaguar) so I can't run the benchmark suite for now. JP -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Benchmark differences: Mac OS X - Linux

2003-11-06 Thread Jeremy Zawodny
On Wed, Nov 05, 2003 at 07:57:00PM +0100, Jan Pieter Kunst wrote: > Hi everyone, > > I recently ran the MySQL benchmark suite on a Dual 1 GHz G4 running Mac > OS X Server 10.2.8, and an 800 MHz Intel machine running SuSE Linux 8.0. > Both installations used the same my.cnf file. &

Re: Benchmark differences: Mac OS X - Linux

2003-11-05 Thread Gabriel Ricard
roughput you would get in OS9. I'd be curious what kind of numbers Panther shows. Once I get my xServe setup, just arrived, I'll try running some tests myself. On Wednesday, November 5, 2003, at 01:57 PM, Jan Pieter Kunst wrote: Hi everyone, I recently ran the MySQL benchmark suite o

Re: Benchmark differences: Mac OS X - Linux

2003-11-05 Thread Brent Baisley
ve setup, just arrived, I'll try running some tests myself. On Wednesday, November 5, 2003, at 01:57 PM, Jan Pieter Kunst wrote: Hi everyone, I recently ran the MySQL benchmark suite on a Dual 1 GHz G4 running Mac OS X Server 10.2.8, and an 800 MHz Intel machine running SuSE Linux 8.0. Bot

Re: Benchmark differences: Mac OS X - Linux

2003-11-05 Thread Gabriel Ricard
I'm not entirely sure what to do about the slow insert results, they are the slowest part no matter how you configure it, it seems. I've attached some benchmark results I ran on a dual 2GHz G5 for comparison. Both MyISAM and InnoDB. Here are the insert results though: MyISAM: ins

Benchmark differences: Mac OS X - Linux

2003-11-05 Thread Jan Pieter Kunst
Hi everyone, I recently ran the MySQL benchmark suite on a Dual 1 GHz G4 running Mac OS X Server 10.2.8, and an 800 MHz Intel machine running SuSE Linux 8.0. Both installations used the same my.cnf file. The results are comparable in all benchmarks except one: the 'insert'. In that on

Re: That eWeek benchmark...

2003-10-16 Thread Heikki Tuuri
Hi! Mark Matthews, the author of Connector/J commented on the speed improvements of JDBC since the eWeek benchmark. Best regards, Heikki - Alkuperäinen viesti - Lähettäjä: "Mark Matthews" Vastaanottaja: "Heikki Tuuri" <[EMAIL PROTECTED]> Lähetetty: Thursday

Re: That eWeek benchmark...

2003-10-16 Thread Heikki Tuuri
Chris, - Original Message - From: "Chris Nolan" <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Wednesday, October 15, 2003 2:43 PM Subject: That eWeek benchmark... > Hi all, > > Looking back over the eWeek benchmark that's linked to from ww

That eWeek benchmark...

2003-10-15 Thread Chris Nolan
Hi all, Looking back over the eWeek benchmark that's linked to from www.innodb.com (where MySQL is a match for Oracle), I made a few observations. Firstly, both MySQL and Oracle achieved basically identical performance levels. This puzzles me as many tests I have seen online show MySQL to

Benchmark

2003-08-14 Thread mixo
and they usually login to the system at the begining of the the day and remain connected untill they knock of. I have setup two test machines, one with Pg and the other with Mysql. Both machine have the same data (sample). I am looking for a benchmark utilty that the simulate a user session. For

re: MySQL benchmark test

2003-07-30 Thread Jon Miller
Does anyone know how or better still can point me in the right direction on testing a newly install MySQL application server. We would like to run some tests to see what needs tweaking if any. Thanks Jon L. Miller, MCNE, CNS Director/Sr Systems Consultant MMT Networks Pty Ltd http://www.mmtnet

Re: What is a good benchmark?

2003-07-29 Thread Dan Nelson
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(&

Re: What is a good benchmark?

2003-07-29 Thread Asif Iqbal
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,

Re: What is a good benchmark?

2003-07-29 Thread Dan Nelson
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 > -

Re: What is a good benchmark?

2003-07-28 Thread daniel
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

Re: What is a good benchmark?

2003-07-28 Thread Asif Iqbal
e 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 a

Re: What is a good benchmark?

2003-07-28 Thread Dan Nelson
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

Re: What is a good benchmark?

2003-07-28 Thread Jeremy Zawodny
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.c

RE: What is a good benchmark?

2003-07-28 Thread Asif Iqbal
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

RE: What is a good benchmark?

2003-07-25 Thread Jeff Shapiro
; 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 di

RE: RES: What is a good benchmark?

2003-07-23 Thread Ow Mun Heng
70 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? > On my p4 2gig > > mysql> SELECT BENCHMARK(100,ENCODE("hello","goodbye")); > +

RE: RES: What is a good benchmark?

2003-07-23 Thread Ow Mun Heng
IL PROTECTED] Sent: Thursday, July 24, 2003 12:11 AM To: [EMAIL PROTECTED] Subject: Re: RES: What is a good benchmark? > On my p4 2gig > > mysql> SELECT BENCHMARK(100,ENCODE("hello","goodbye")); > +--

RE: What is a good benchmark?

2003-07-23 Thread mos
ing 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> selec

Re: What is a good benchmark?

2003-07-23 Thread Gustavo A. Baratto
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,

RE: What is a good benchmark?

2003-07-23 Thread Christopher Knight
>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 n

RE: What is a good benchmark?

2003-07-23 Thread Andrew Braithwaite
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,

Re: What is a good benchmark?

2003-07-23 Thread David Griffiths
Dual P3 933, 2 gig RAM, IDE RAID-5 +--+ | BENCHMARK(100,ENCODE("hello","goodbye")) | +--+ |0 | +

Re: What is a good benchmark?

2003-07-23 Thread Andrew Edwards
ql" <[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: Wedn

RE: What is a good benchmark?

2003-07-23 Thread Christopher Knight
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

RE: What is a good benchmark?

2003-07-23 Thread artem
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

RE: What is a good benchmark?

2003-07-23 Thread Mark Graves
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")); +-----

Re: RES: What is a good benchmark?

2003-07-23 Thread NTLUG
> On my p4 2gig > > mysql> SELECT BENCHMARK(100,ENCODE("hello","goodbye")); > +--+ > | BENCHMARK(100,ENCODE("hello","goodbye")) | > +---

Re: What is a good benchmark?

2003-07-23 Thread Chris Knipe
+--+ | BENCHMARK(100,ENCODE("hello","goodbye")) | +--+ |0 | +--+ 1 row in set (1.91 sec) PI

RES: What is a good benchmark?

2003-07-23 Thread julio
Hello Guys, AlphaServer EV6 processor 500mhz/1Gm memory with Linux mysql> SELECT BENCHMARK(100,ENCODE("hello","goodbye")); +------+ | BENCHMARK(100,

RES: What is a good benchmark?

2003-07-23 Thread julio
PROTECTED] Assunto: RE: What is a good benchmark? On my p4 2gig mysql> SELECT BENCHMARK(100,ENCODE("hello","goodbye")); +------+ | BENCHMARK(100,

Re: What is a good benchmark?

2003-07-23 Thread Jim Dickenson
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,

RE: What is a good benchmark?

2003-07-23 Thread John May
Xserve 1ghz - 1.08 sec G3 333mhz - 2.78 sec - John On my p4 2gig mysql> SELECT BENCHMARK(100,ENCODE("hello","goodbye")); +------+ | BENCHMARK(100,

RE: What is a good benchmark?

2003-07-23 Thread Hubbard, Dan
On my 2 * 2.8Ghz 2GB RAM, Redhat 8: mysql> SELECT BENCHMARK(100,ENCODE("hello","goodbye")); +------+ | BENCHMARK(100,ENCODE("hello","goodbye")) | +--+ |

Re: What is a good benchmark?

2003-07-23 Thread Yves Goergen
uli 2003 16:45 Betreff: RE: What is a good benchmark? > On my p4 2gig > > mysql> SELECT BENCHMARK(100,ENCODE("hello","goodbye")); > +

RE: What is a good benchmark?

2003-07-23 Thread John Griffin
On my 1.8GHz p4 with 512Gig of RAM I get: mysql> SELECT BENCHMARK(100,ENCODE("hello","goodbye")); +------+ | BENCHMARK(100,ENCODE("hello","goodbye")) | +--+ |

RE: What is a good benchmark?

2003-07-23 Thread Bryan Koenig
On my p4 2gig mysql> SELECT BENCHMARK(100,ENCODE("hello","goodbye")); +------+ | BENCHMARK(100,ENCODE("hello","goodbye")) | +--+ |

What is a good benchmark?

2003-07-23 Thread Jake Johnson
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,

Re: URGENT : Benchmark

2003-07-22 Thread Phil Bitis
nt: Tuesday, July 22, 2003 9:54 PM Subject: URGENT : Benchmark > Help me ... > > Antonio Jose Rodrigues Neto <[EMAIL PROTECTED]> wrote:Hi All, > > I almost finish my MSC Thesis and my thesis is iSCSI Performance. I would like to make tests using Fibre Channel and iSCSI with MYS

URGENT : Benchmark

2003-07-22 Thread Antonio Jose Rodrigues Neto
Help me ... Antonio Jose Rodrigues Neto <[EMAIL PROTECTED]> wrote:Hi All, I almost finish my MSC Thesis and my thesis is iSCSI Performance. I would like to make tests using Fibre Channel and iSCSI with MYSQL. Please I will need informations (cookbook) how does implement tunning on MySQL - Linu

Re: Benchmark Results or MySQL Articles Needed!

2002-10-03 Thread Mark Wong
On Wed, 2002-10-02 at 20:51, mos wrote: > At 09:40 PM 10/2/2002, you wrote: > >For science fair I'm doing a project on MySQL. For my introduction, I > >need some articles, benchmarks, or anything else credible that I can put > >in the bibliography. If anyone can help me out, I'd be extremely > >ap

Re: Benchmark Results or MySQL Articles Needed!

2002-10-02 Thread mos
At 09:40 PM 10/2/2002, you wrote: >For science fair I'm doing a project on MySQL. For my introduction, I >need some articles, benchmarks, or anything else credible that I can put >in the bibliography. If anyone can help me out, I'd be extremely >appreciative! Thanks. SS, Benchmarks are no

Benchmark Results or MySQL Articles Needed!

2002-10-02 Thread SpamSucks86
For science fair I'm doing a project on MySQL. For my introduction, I need some articles, benchmarks, or anything else credible that I can put in the bibliography. If anyone can help me out, I'd be extremely appreciative! Thanks.

re: I can not install the benchmark module for SQL

2002-09-17 Thread Egor Egorov
root, Saturday, September 14, 2002, 9:55:54 AM, you wrote: >Description: r> I want to install MySQL-bench-3.23.52.1.i386.rpm with KDE RPM r> I get as answer: MySQL-DBI-perl-bin needed. r> I already had downloaded and installed this module: r> Mysql

Re: benchmark to my MySQL

2002-08-04 Thread Luuk de Boer
if you have downloaded the src of mysql and installed it you can find the mysql benchmark in your /usr/local/sql-bench Else you also have downloads seperately on the mysql site for only the benchmark (in rpm and others). Grtz. Luuk On 4 Aug 2002, at 1:58, savaidis wrote: > > Is the

benchmark to my MySQL

2002-08-03 Thread savaidis
Is there any standard method or benchmark to run localy or remotly to my host to help me to setup MySQL better or to check various computer/configurations? I could find anything on http://www.mysql.com/information/benchmarks.html links. Only at third part software but it is in C++, not .sql

Re: Benchmark

2002-07-30 Thread Brent Baisley
, July 30, 2002, at 09:09 AM, Daniel Kiss wrote: > Hi, > > Where can I find some benchmark test result documentation. > First of all, I'm interested in comparing MySQL, Oracle and MSSQL speed > in different situations. > &

Re: Benchmark

2002-07-30 Thread Egor Egorov
Daniel, Tuesday, July 30, 2002, 4:09:00 PM, you wrote: DK> Where can I find some benchmark test result documentation. DK> First of all, I'm interested in comparing MySQL, Oracle and MSSQL speed in DK> different situations. Check some links in the manual: http://www.mys

Benchmark

2002-07-30 Thread Daniel Kiss
Hi, Where can I find some benchmark test result documentation. First of all, I'm interested in comparing MySQL, Oracle and MSSQL speed in different situations. Thanks, Daniel - Before posting, please check:

RE: object pool benchmark over 100mbit lan

2002-06-18 Thread Anthony Johnston . Antix
PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: object pool benchmark over 100mbit lan Hello! To be fair with the marvellous mysql, I like to post new benchmarks of the my object pooling over 100mbit LAN. Previous post are about a Mysql server running into the same machine where the

Innodb Memory use for a Benchmark in MySQL...

2002-06-13 Thread Rogger
> We are developing a benchmark (only querying) between > MySQL, SQLServer2000, and Access 2000 > We are using as base, the Database propose by TPC.org (www.tpc.org)... > With the records they propose and the indexes they proposed > > But for the testing we are using I

Innodb Memory use for a Benchmark...

2002-06-13 Thread Rogger
We are developing a benchmark (only querying) between MySQL, SQLServer2000, and Access 2000 We are using as base, the Database propose by TPC.org (www.tpc.org)... With the records they propose and the indexes they proposed But for the testing we are using INNODB tables, with the

Re: a very odd benchmark question

2002-05-28 Thread Jeremy Zawodny
On Tue, May 28, 2002 at 10:04:26PM -0600, Tyler Spivey wrote: > ok - this might seem unbelieveable but: > why are the benchmarks: > shell> cd sql-benchmarks #or whatever it is > shel> perl run-all-tests --user=root --password=password > and then on another screen i have mysql up - > and a \s say q

  1   2   >