From owner-freebsd-threads@FreeBSD.ORG Mon May 24 07:45:42 2004 Return-Path: Delivered-To: freebsd-threads@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 4DC2716A4CE for ; Mon, 24 May 2004 07:45:42 -0700 (PDT) Received: from mail.pcnet.com (mail.pcnet.com [204.213.232.4]) by mx1.FreeBSD.org (Postfix) with ESMTP id DDBDF43D31 for ; Mon, 24 May 2004 07:45:41 -0700 (PDT) (envelope-from eischen@vigrid.com) Received: from mail.pcnet.com (mail.pcnet.com [204.213.232.4]) by mail.pcnet.com (8.12.10/8.12.1) with ESMTP id i4OEio8Q013149; Mon, 24 May 2004 10:44:50 -0400 (EDT) Date: Mon, 24 May 2004 10:44:50 -0400 (EDT) From: Daniel Eischen X-Sender: eischen@pcnet5.pcnet.com To: Chris Elsworth In-Reply-To: <20040524143615.GA12869@shagged.org> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII cc: freebsd-threads@freebsd.org Subject: Re: Why is MySQL nearly twice as fast on Linux? X-BeenThere: freebsd-threads@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: Threading on FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Mon, 24 May 2004 14:45:42 -0000 On Mon, 24 May 2004, Chris Elsworth wrote: > On Mon, May 24, 2004 at 10:13:36AM -0400, Daniel Eischen wrote: > > On Mon, 24 May 2004, Petri Helenius wrote: > > > > > I changed the test to use InnoDB table type and saw 50% performance > > > improvement. > > > > Are you able to run the test using InnoDB under Linux also > > (just to see if Linux also gets a ~50% improvement)? > > I've just done so. It doesn't make much difference. [ ... ] > So, each of the smackfiles used below was changed to have sql_no_cache > in the select. The _i smackfile simply has type=innodb in the create > table statement. > > Here's the numbers: And what kind of improvement do you see using FreeBSD (-current, libpthread)? -- Dan Eischen