From owner-freebsd-threads@FreeBSD.ORG Mon May 24 07:14:27 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 0CE9E16A4CE for ; Mon, 24 May 2004 07:14:27 -0700 (PDT) Received: from mail.pcnet.com (mail.pcnet.com [204.213.232.4]) by mx1.FreeBSD.org (Postfix) with ESMTP id 3342F43D1D for ; Mon, 24 May 2004 07:14:26 -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 i4OEDa8Q004986; Mon, 24 May 2004 10:13:38 -0400 (EDT) Date: Mon, 24 May 2004 10:13:36 -0400 (EDT) From: Daniel Eischen X-Sender: eischen@pcnet5.pcnet.com To: Petri Helenius In-Reply-To: <40B19F2E.8010804@he.iki.fi> 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:14:27 -0000 On Mon, 24 May 2004, Petri Helenius wrote: > Thomas Hurst wrote: > > > > >Only if you're only using one table. While this is true in this > >benchmark, it isn't really relevent because we're only testing selects, > >which are pure reads. There should be no table locking getting in the > >way; Linux's performance would seem to confirm this. > > > > 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)? What did you do to change the test (got a diff)? -- Dan