From owner-freebsd-stable@FreeBSD.ORG  Fri Jun 17 15:03:00 2005
Return-Path: <owner-freebsd-stable@FreeBSD.ORG>
X-Original-To: freebsd-stable@freebsd.org
Delivered-To: freebsd-stable@freebsd.org
Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125])
	by hub.freebsd.org (Postfix) with ESMTP id BCBE016A428;
	Fri, 17 Jun 2005 15:03:00 +0000 (GMT)
	(envelope-from steve@lonres.com)
Received: from anchor-post-30.mail.demon.net (anchor-post-30.mail.demon.net
	[194.217.242.88])
	by mx1.FreeBSD.org (Postfix) with ESMTP id 78D4243D4C;
	Fri, 17 Jun 2005 15:03:00 +0000 (GMT)
	(envelope-from steve@lonres.com)
Received: from mail.lonres.com ([194.70.153.187])
	by anchor-post-30.mail.demon.net with esmtp (Exim 4.42)
	id 1DjIMy-000M9a-2C; Fri, 17 Jun 2005 15:02:57 +0000
Received: from bibipentium.lonres.com (bibipentium.lonres.com [10.10.10.225])
	by mail.lonres.com (Postfix) with SMTP id 870832E09F;
	Fri, 17 Jun 2005 16:02:56 +0100 (BST)
Received: by bibipentium.lonres.com (sSMTP sendmail emulation);
	Fri, 17 Jun 2005 16:03:04 +0100
Date: Fri, 17 Jun 2005 16:03:04 +0100
From: Steve Roome <steve@lonres.com>
To: David Sze <dsze@distrust.net>
Message-ID: <20050617150304.GE34777@bibipentium.lonres.com>
References: <746fd037f6ca8131a8fb8938f1e346e9@lonres.com>
	<20050610170537.GA67849@bibipentium.lonres.com>
	<20050611085604.J75625@fledge.watson.org>
	<20050616161506.GB28794@bibipentium.lonres.com>
	<6.2.1.2.2.20050617091736.05949298@mail.distrust.net>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <6.2.1.2.2.20050617091736.05949298@mail.distrust.net>
User-Agent: Mutt/1.4.2.1i
X-Mailman-Approved-At: Sat, 18 Jun 2005 13:10:58 +0000
Cc: freebsd-stable@freebsd.org, Guy Helmer <ghelmer@palisadesys.com>,
	Kris Kennaway <kris@obsecurity.org>,
	Greg 'groggy' Lehey <grog@freebsd.org>, Robert Watson <rwatson@freebsd.org>
Subject: Re: FreeBSD MySQL still WAY slower than Linux
X-BeenThere: freebsd-stable@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
List-Id: Production branch of FreeBSD source code <freebsd-stable.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-stable>, 
	<mailto:freebsd-stable-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-stable>
List-Post: <mailto:freebsd-stable@freebsd.org>
List-Help: <mailto:freebsd-stable-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-stable>,
	<mailto:freebsd-stable-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Fri, 17 Jun 2005 15:03:00 -0000

I've posted a longer reply, with a trimmed cc list on the -performance
mailing list if anyone is still interested and I'll leave it off
-stable as it's probably become somewhat off topic now.

Sadly, I don't think simply having an async FS is going to solve our
problem though. :(

Ta,

        Steve Roome

For refernce:
On Fri, Jun 17, 2005 at 09:28:54AM -0400, David Sze wrote:
> At 05:15 PM 16/06/2005 +0100, Steve Roome wrote this to All:
> It turns out that the problem was the same thing everyone usually points 
> the finger at, but no one actually mentioned this time:  Linux mounts its 
> partitions async by default.  I don't have the exact numbers in front of me 
> right now, but these were the ballpark figures (I'm not going to separate 
> out results for all of the different threading libraries for FreeBSD 
> because the deltas weren't huge):

...