From owner-freebsd-amd64@FreeBSD.ORG Wed May 19 06:30:30 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 9615F16A4CE for ; Wed, 19 May 2004 06:30:30 -0700 (PDT) Received: from ojoink.com (center.ojoink.com [216.65.123.180]) by mx1.FreeBSD.org (Postfix) with ESMTP id 6EB7743D1F for ; Wed, 19 May 2004 06:30:30 -0700 (PDT) (envelope-from amd64list@jpgsworld.com) Received: (qmail 49638 invoked by uid 89); 19 May 2004 13:34:22 -0000 Received: from unknown (HELO MAINBX.jpgsworld.com) (amd64list@jpgsworld.com@24.10.96.33) by center.ojoink.com with SMTP; 19 May 2004 13:34:22 -0000 Message-Id: <5.2.0.9.2.20040519062848.04332d00@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 06:30:07 -0700 To: freebsd-amd64@freebsd.org From: JG In-Reply-To: <00f301c43d9e$c0eea950$b3db87d4@multiplay.co.uk> 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> <5.2.0.9.2.20040519052743.04365f78@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 13:30:30 -0000 At 01:42 PM 5/19/2004 +0100, you wrote: >Something silly to try on both linux and FreeBSD disable the >second processor / use a none SMP kernel. >Do you then see similar results? > > Steve Steve, Good idea. I just tried this & the results were in the same range. The actual results are below: ----------------------------------------------------------------------------- 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. ** WITHOUT SMP ** option in kernel (just testing single CPU results) 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 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 166 seconds. Average of 3012.0481927711 records per second. Creating records for 10 seconds... Created 31882 records in 10 seconds. Average of 3188.2 records per second. Creating random 50000 md5 hash records. Creation of 50000 random md5 hash inserts took 18 seconds. Average of 2777.7777777778 records per second. Creating random md5 hash records for 10 seconds... Created 27658 random records in 10 seconds. Average of 2765.8 records per second. Your databases overall average score is 2935.9564926372 records per second.