From owner-freebsd-stable@FreeBSD.ORG  Mon Jun 20 07:29:50 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 AD33A16A41C
	for <freebsd-stable@freebsd.org>; Mon, 20 Jun 2005 07:29:50 +0000 (GMT)
	(envelope-from decibel@decibel.org)
Received: from flake.decibel.org (flake.decibel.org [67.100.216.10])
	by mx1.FreeBSD.org (Postfix) with ESMTP id 4AAF743D48
	for <freebsd-stable@freebsd.org>; Mon, 20 Jun 2005 07:29:50 +0000 (GMT)
	(envelope-from decibel@decibel.org)
Received: by flake.decibel.org (Postfix, from userid 1001)
	id 066AF15230; Mon, 20 Jun 2005 02:29:46 -0500 (CDT)
Date: Mon, 20 Jun 2005 02:29:46 -0500
From: "Jim C. Nasby" <decibel@decibel.org>
To: Greg Barniskis <nalists@scls.lib.wi.us>
Message-ID: <20050620072946.GL5113@decibel.org>
Mail-Followup-To: "Jim C. Nasby" <decibel@decibel.org>,
	Greg Barniskis <nalists@scls.lib.wi.us>,
	"J. T. Farmer" <jfarmer@goldsword.com>, uzi@bmby.com,
	freebsd-stable@freebsd.org
References: <6.2.1.2.2.20050617103807.058c6fa8@mail.distrust.net>
	<005c01c57354$3e877900$fe00a8c0@uzi>
	<42B2E9B5.7090803@goldsword.com> <42B2EC91.8070800@scls.lib.wi.us>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <42B2EC91.8070800@scls.lib.wi.us>
X-Operating-System: FreeBSD 4.11-RELEASE i386
X-Distributed: Join the Effort!  http://www.distributed.net
User-Agent: Mutt/1.5.9i
Cc: uzi@bmby.com, freebsd-stable@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: Mon, 20 Jun 2005 07:29:51 -0000

On Fri, Jun 17, 2005 at 10:30:25AM -0500, Greg Barniskis wrote:
> I think he meant comparing 36,000 on CentOS (async) to 24,000 on 
> CURRENT (sync). I wondered that myself, and having searched out the 
> answer I find that it is declared in
> 
> http://www.freebsd.org/doc/en_US.ISO8859-1/books/handbook/configtuning-disk.html
> 
> that async provides fast writes at the cost of "no guarantee at all 
> for a consistent state of the filesystem". So, you choose: fast but 
> not so reliable writes, or slower writes with fast, reliable 
> disaster recovery.
> 
> Thanks to the FreeBSD team for choosing the sensible default, even 
> if it results in the occasional "Linux is faster!" debate. Dang 
> smirky penguins... you're flightless I tell ya, flightless. =)

Note that it's very easy to accidentally configure MySQL in such a
manner that you don't have any data integrity anyway. For example, if
you fat-finger 'innodb' as 'innodd' or something MySQL siletly creates a
MyISAM table for you. So if you care about data integrity, you should
probably look beyond MySQL in the first place.
-- 
Jim C. Nasby, Database Consultant               decibel@decibel.org 
Give your computer some brain candy! www.distributed.net Team #1828

Windows: "Where do you want to go today?"
Linux: "Where do you want to go tomorrow?"
FreeBSD: "Are you guys coming, or what?"