From owner-freebsd-amd64@FreeBSD.ORG  Thu May 20 14:01:25 2004
Return-Path: <owner-freebsd-amd64@FreeBSD.ORG>
Delivered-To: freebsd-amd64@freebsd.org
Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125])
	by hub.freebsd.org (Postfix) with ESMTP id 141F016A4CE
	for <freebsd-amd64@freebsd.org>; Thu, 20 May 2004 14:01:25 -0700 (PDT)
Received: from ojoink.com (center.ojoink.com [216.65.123.180])
	by mx1.FreeBSD.org (Postfix) with ESMTP id E212B43D46
	for <freebsd-amd64@freebsd.org>; Thu, 20 May 2004 14:01:24 -0700 (PDT)
	(envelope-from amd64list@jpgsworld.com)
Received: (qmail 17920 invoked by uid 89); 20 May 2004 21:05:38 -0000
Received: from unknown (HELO MAINBX.jpgsworld.com)
	(amd64list@jpgsworld.com@24.10.96.33)
	by center.ojoink.com with SMTP; 20 May 2004 21:05:38 -0000
Message-Id: <5.2.0.9.2.20040520135814.015d8d70@mail.ojoink.com>
X-Sender: amd64list@jpgsworld.com@mail.ojoink.com
X-Mailer: QUALCOMM Windows Eudora Version 5.2.0.9
Date: Thu, 20 May 2004 14:01:10 -0700
To: freebsd-amd64@freebsd.org
From: JG <amd64list@jpgsworld.com>
In-Reply-To: <200405202235.46755.Gregor.Bittel@GMX.de>
References: <5.2.0.9.2.20040520122752.015eec60@mail.ojoink.com>
 <Pine.LNX.4.53.0405201129570.22287@sql01.internal.mikehost.net>
 <5.2.0.9.2.20040520122752.015eec60@mail.ojoink.com>
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"; format=flowed
Subject: Re: Why is MySQL nearly twice as fast on Linux/AMD64 Vs. 
  FreeBSD/AMD64?
X-BeenThere: freebsd-amd64@freebsd.org
X-Mailman-Version: 2.1.1
Precedence: list
List-Id: Porting FreeBSD to the AMD64 platform <freebsd-amd64.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-amd64>,
	<mailto:freebsd-amd64-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-amd64>
List-Post: <mailto:freebsd-amd64@freebsd.org>
List-Help: <mailto:freebsd-amd64-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-amd64>,
	<mailto:freebsd-amd64-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Thu, 20 May 2004 21:01:25 -0000


>
>and this are the results of mybench:
>Generating 500000 records...
>Creation of 500000 records took 50 seconds.
>Average of 10000 records per second.
>Creating records for 10 seconds...
>Created 94526 records in 10 seconds.
>Average of 9452.6 records per second.
>Creating random 50000 md5 hash records.
>Creation of 50000 random md5 hash inserts took 6 seconds.
>Average of 8333.33333333 records per second.
>Creating random md5 hash records for 10 seconds...
>Created 77027 random records in 10 seconds.
>Average of 7702.7 records per second.
>Your databases overall average score is 8872.15833333 records per
>second.

I'd guess that you're running MyBench on the same machine that MySQL is on?

All of my benchmarks have been ran from a separate server on the LAN connecting
to the MySQL server.

Mike got an overall average score of 12,000+ testing it locally.

Test from another box on the LAN and let me know how it goes ;)


- Jeremy