From owner-freebsd-amd64@FreeBSD.ORG Wed May 19 05:29:53 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 942B016A4CE for ; Wed, 19 May 2004 05:29:53 -0700 (PDT) Received: from ojoink.com (center.ojoink.com [216.65.123.180]) by mx1.FreeBSD.org (Postfix) with ESMTP id 1D20843D46 for ; Wed, 19 May 2004 05:29:53 -0700 (PDT) (envelope-from amd64list@jpgsworld.com) Received: (qmail 47577 invoked by uid 89); 19 May 2004 12:33:54 -0000 Received: from unknown (HELO MAINBX.jpgsworld.com) (amd64list@jpgsworld.com@24.10.96.33) by center.ojoink.com with SMTP; 19 May 2004 12:33:54 -0000 Message-Id: <5.2.0.9.2.20040519052743.04365f78@mail.ojoink.com> X-Sender: amd64list@jpgsworld.com@mail.ojoink.com X-Mailer: QUALCOMM Windows Eudora Version 5.2.0.9 Date: Wed, 19 May 2004 05:29:39 -0700 To: freebsd-amd64@freebsd.org From: JG In-Reply-To: <5.2.0.9.2.20040519044815.0156fbb8@mail.ojoink.com> References: <5.2.0.9.2.20040518170424.03c42748@mail.ojoink.com> <200405181359.18291.peter@wemm.org> <5.2.0.9.2.20040518103357.04c6cbb8@mail.ojoink.com> <5.2.0.9.2.20040518103357.04c6cbb8@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 List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 19 May 2004 12:29:53 -0000 Also tried with the MySQL 5.0.0a port, same results basically: ----------------------------------------------------------------------------- FreeBSD 5.2-CURRENT FreeBSD 5.2-CURRENT #0: Tue May 18 07:17:39 PDT 2004 With SCHED_ULE & debugging turned off in kernel. amd64f# ldd /usr/local/libexec/mysqld /usr/local/libexec/mysqld: libpthread.so.1 => /usr/lib/libpthread.so.1 (0x2009ab000) libz.so.2 => /lib/libz.so.2 (0x200ad5000) libcrypt.so.2 => /lib/libcrypt.so.2 (0x200be4000) libstdc++.so.4 => /usr/lib/libstdc++.so.4 (0x200cfe000) libm.so.2 => /lib/libm.so.2 (0x200ee5000) libc.so.5 => /lib/libc.so.5 (0x201005000) amd64f# /usr/local/libexec/mysqld --version Ver 5.0.0-alpha for portbld-freebsd5.2 on amd64 (FreeBSD port: mysql-server-5.0.0_2) From the ports Makefile: CONFIGURE_ARGS= --localstatedir=${DB_DIR} \ --without-debug \ --without-readline \ --without-libedit \ --without-bench \ --without-extra-tools \ --without-libwrap \ --with-mysqlfs \ --with-vio \ --with-low-memory \ --with-comment='FreeBSD port: ${PKGNAME}' \ --enable-thread-safe-client Benchmark Results: Generating 500000 records... Creation of 500000 records took 167 seconds. Average of 2994.0119760479 records per second. Creating records for 10 seconds... Created 32912 records in 10 seconds. Average of 3291.2 records per second. Creating random 50000 md5 hash records. Creation of 50000 random md5 hash inserts took 16 seconds. Average of 3125 records per second. Creating random md5 hash records for 10 seconds... Created 29294 random records in 10 seconds. Average of 2929.4 records per second. Your databases overall average score is 3084.902994012 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: Your databases overall average score is 5328.6582709114 records per second -----------------------------------------------------------------------------