From owner-freebsd-performance@FreeBSD.ORG  Wed Jun 29 09:45:23 2005
Return-Path: <owner-freebsd-performance@FreeBSD.ORG>
X-Original-To: performance@freebsd.org
Delivered-To: freebsd-performance@FreeBSD.ORG
Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125])
	by hub.freebsd.org (Postfix) with ESMTP id F0BA216A41C
	for <performance@freebsd.org>; Wed, 29 Jun 2005 09:45:23 +0000 (GMT)
	(envelope-from tataz@tataz.chchile.org)
Received: from postfix3-1.free.fr (postfix3-1.free.fr [213.228.0.44])
	by mx1.FreeBSD.org (Postfix) with ESMTP id B710343D48
	for <performance@freebsd.org>; Wed, 29 Jun 2005 09:45:23 +0000 (GMT)
	(envelope-from tataz@tataz.chchile.org)
Received: from tatooine.tataz.chchile.org
	(vol75-8-82-233-239-98.fbx.proxad.net [82.233.239.98])
	by postfix3-1.free.fr (Postfix) with ESMTP id 9E6C31734D4;
	Wed, 29 Jun 2005 11:45:22 +0200 (CEST)
Received: by tatooine.tataz.chchile.org (Postfix, from userid 1000)
	id 98C02405B; Wed, 29 Jun 2005 11:45:34 +0200 (CEST)
Date: Wed, 29 Jun 2005 11:45:33 +0200
From: Jeremie Le Hen <jeremie@le-hen.org>
To: Michael Vince <mv@roq.com>
Message-ID: <20050629094533.GA49933@obiwan.tataz.chchile.org>
References: <20050623145041.GC64879@bibipentium.lonres.com>
	<42BD64F1.4080001@roq.com>
	<20050627134146.GA626@bibipentium.lonres.com>
	<42C1FA31.3050806@roq.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <42C1FA31.3050806@roq.com>
User-Agent: Mutt/1.5.9i
Cc: Steve Roome <steve@pepcross.com>, performance@freebsd.org
Subject: Re: FreeBSD MySQL still WAY slower than Linux
X-BeenThere: freebsd-performance@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
List-Id: Performance/tuning <freebsd-performance.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-performance>,
	<mailto:freebsd-performance-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-performance>
List-Post: <mailto:freebsd-performance@freebsd.org>
List-Help: <mailto:freebsd-performance-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-performance>,
	<mailto:freebsd-performance-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Wed, 29 Jun 2005 09:45:24 -0000

Hi Michael, hi Steve,

> For me this is as fast as I need my database to be but I can understand 
> there is a difference here between FreeBSD and Linux that would make you 
> prefer it as the db OS choice.

Could you try mounting the filesystem where the database lives with
the noatime option, and re-run your tests ?  IIRC from previous threads
on this subject, Linux doesn't really honor this while FreeBSD does,
which pulls down the performances.

Regards,
-- 
Jeremie Le Hen
< jeremie at le-hen dot org >< ttz at chchile dot org >