Re: MySQL Benchmark. OT and beyond...

2004-05-31 Thread Jesse Sheidlower
On Thu, May 27, 2004 at 02:20:46PM -0400, RV Tec wrote: 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

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 5.x

Re: MySQL Benchmark.

2004-05-29 Thread JG
At 11:57 AM 5/27/2004 -0700, you wrote: At 11:02 AM 5/27/2004 -0700, you wrote: 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

RE: MySQL Benchmark.

2004-05-29 Thread Donny Simonton
: Re: MySQL Benchmark. At 11:57 AM 5/27/2004 -0700, you wrote: At 11:02 AM 5/27/2004 -0700, you wrote: 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

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 much

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,

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

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 would

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 that

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 issues is with benchmark numbers,

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

Re: MySQL Benchmark.

2004-05-27 Thread JG
At 11:02 AM 5/27/2004 -0700, you wrote: 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

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

Mysql benchmark

2002-04-24 Thread Lorenzo De Vito
There are tools for benchmark on win32 via ODBC ? I would like to test sql query in my VB6 application. Thank you. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

RE: mysql benchmark

2002-01-27 Thread Michael Widenius
hi! jon-david == jon-david schlough [EMAIL PROTECTED] writes: jon-david thanks christopher and monty ! got perl into my path and it's working... jon-david another ? tho: i also want to benchmark postgreSQL living on another 2K jon-david machine, does the mysql benchmark have to run locally

benchmarking pgsql with mysql benchmark suite

2002-01-24 Thread jon-david schlough
hi. i'm trying to benchmark pgsql living in cygwin on a 2K box with mysql installed normaly on windows. i get: C:\mysql\benchperl run-all-tests --host=PAVILION --server=Pg --user=n --password=x --log --comment 2x Pentium II 400mz, 256M, under vmware Got error:

RE: mysql benchmark

2002-01-22 Thread Michael Widenius
hi! jon-david == jon-david schlough [EMAIL PROTECTED] writes: jon-david Christopher Thompson wrote: jon-david Have you installed perl? You need it (and the Perl MySQL drivers) jon-david installed before you can benchmark. yep. perl is all good - got activestate perl fer windoze and the

RE: mysql benchmark

2002-01-22 Thread jon-david schlough
thanks christopher and monty ! got perl into my path and it's working... another ? tho: i also want to benchmark postgreSQL living on another 2K machine, does the mysql benchmark have to run locally or can i specify an ip with a username and password in the batch file? i'm searching for some

mysql benchmark

2002-01-21 Thread jon-david schlough
greetings. i am trying to use the benchmarking suite...got the perl dbi and dbd fine - but: C:\mysql\benchrun C:\mysql\bench\mysql\bin\mysqladmin refresh \mysql\bin\mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'ODBC@localhost' (Using password: NO)'

Re: mysql benchmark

2002-01-21 Thread Christopher Thompson
Have you installed perl? You need it (and the Perl MySQL drivers) installed before you can benchmark. Also, you'll want to modify the batch files such that it uses a different user (possibly the root user if you haven't changed the password on that yet). Note that running the benchmark

RE: mysql benchmark

2002-01-21 Thread jon-david schlough
Christopher Thompson wrote: Have you installed perl? You need it (and the Perl MySQL drivers) installed before you can benchmark. yep. perl is all good - got activestate perl fer windoze and the dbi and the dbd - everything went fine as i went thru the tutorial in the manual...i was able

RE: mysql benchmark

2002-01-21 Thread Christopher Thompson
At 02:41 PM 1/21/2002 -0600, jon-david schlough wrote: yep. perl is all good - got activestate perl fer windoze and the dbi and the dbd - everything went fine as i went thru the tutorial in the manual...i was able to: perl -v and get the version info... Great. So perl is in your path? I

Can't install MySQL-benchmark RPM

2001-12-07 Thread brice
Description: Attempting to install the MySQL-benchmark RPM for 4.0.0 yields an RPM message requiring MySQL-DBI-perl-bin. Downloading the 'Mysql-DBI-perl-bin' package (v 1.1825-1) from a mirror (/Downloads/RPMS/i386) does *not* satisfy the dependency - probably a case mismatch between