From owner-freebsd-amd64@FreeBSD.ORG Thu May 20 04:21:41 2004 Return-Path: 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 F116B16A4CE for ; Thu, 20 May 2004 04:21:41 -0700 (PDT) Received: from ojoink.com (center.ojoink.com [216.65.123.180]) by mx1.FreeBSD.org (Postfix) with ESMTP id E236343D1F for ; Thu, 20 May 2004 04:21:41 -0700 (PDT) (envelope-from amd64list@jpgsworld.com) Received: (qmail 96201 invoked by uid 89); 20 May 2004 11:25:36 -0000 Received: from unknown (HELO MAINBX.jpgsworld.com) (amd64list@jpgsworld.com@24.10.96.33) by center.ojoink.com with SMTP; 20 May 2004 11:25:36 -0000 Message-Id: <5.2.0.9.2.20040520041642.03db2188@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 04:21:13 -0700 To: freebsd-amd64@freebsd.org From: JG In-Reply-To: <5.2.0.9.2.20040519164844.01521620@mail.ojoink.com> References: <200405191211.25786.peter@wemm.org> <20040519172913.GU601@funkthat.com> <5.2.0.9.2.20040519052743.04365f78@mail.ojoink.com> <5.2.0.9.2.20040519060611.0435f750@mail.ojoink.com> <20040519172913.GU601@funkthat.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 List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Thu, 20 May 2004 11:21:42 -0000 More benchmarks... My hardware is more than adequate for the my-huge.cnf configuration, so this time I used the my-huge.cnf for my /etc/my.cnf ... and my results were the worst I've seen so far. Go figure. ----------------------------------------------------------------------------- FreeBSD 5.2-CURRENT FreeBSD 5.2-CURRENT #0: Tue May 18 07:17:39 PDT 2004 (-CURRENT above has the ULE + KSE patch applied) Kernel compiled with SCHED_ULE & debugging disabled. MySQL Ver 4.0.20 for portbld-freebsd5.2 on amd64 (FreeBSD port: mysql-server-4.0.20) with mysql40-server.diffs patch applied Port options: BUILD_OPTIMIZED=yes BUILD_STATIC=yes Compiled with libpthreads Using my-huge.cnf BENCHMARK RESULTS: Generating 500000 records... Creation of 500000 records took 202 seconds. Average of 2475.2475247525 records per second. Creating records for 10 seconds... Created 21396 records in 10 seconds. Average of 2139.6 records per second. Creating random 50000 md5 hash records. Creation of 50000 random md5 hash inserts took 22 seconds. Average of 2272.7272727273 records per second. Creating random md5 hash records for 10 seconds... Created 21591 random records in 10 seconds. Average of 2159.1 records per second. Your databases overall average score is 2261.6686993699 records per second. VS. ----------------------------------------------------------------------------- LINUX MANDRAKE 10.0 RC1 w/"OUT OF THE BOX" MySQL installation MySQLd Ver 4.0.18 for mandrake-linux-gnu on x86_64 (Source distribution) Linux amd64m 2.6.3-9mdksmp #1 SMP Mon Apr 19 10:48:13 CEST 2004 x86_64 unknown unknown GNU/Linux Benchmark result summary: Generating 500000 records... Creation of 500000 records took 89 seconds. Average of 5617.9775280899 records per second. Creating records for 10 seconds... Created 50547 records in 10 seconds. Average of 5054.7 records per second. Creating random 50000 md5 hash records. Creation of 50000 random md5 hash inserts took 9 seconds. Average of 5555.5555555556 records per second. Creating random md5 hash records for 10 seconds... Created 50864 random records in 10 seconds. Average of 5086.4 records per second. Your databases overall average score is 5328.6582709114 records per second -----------------------------------------------------------------------------