From owner-freebsd-advocacy@FreeBSD.ORG  Thu Feb 10 21:52:37 2005
Return-Path: <owner-freebsd-advocacy@FreeBSD.ORG>
Delivered-To: freebsd-advocacy@freebsd.org
Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125])
	by hub.freebsd.org (Postfix) with ESMTP
	id C819416A4CE; Thu, 10 Feb 2005 21:52:37 +0000 (GMT)
Received: from sb.santaba.com (sb.santaba.com [207.154.84.26])
	by mx1.FreeBSD.org (Postfix) with ESMTP
	id 6A2F743D46; Thu, 10 Feb 2005 21:52:37 +0000 (GMT)
	(envelope-from jbehl@fastclick.com)
Received: from [192.168.3.100] (unknown [205.180.85.193])
	(using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits))
	(No client certificate requested)
	by sb.santaba.com (Postfix) with ESMTP id 3471C28433;
	Thu, 10 Feb 2005 13:52:37 -0800 (PST)
Message-ID: <420BD7DD.5000304@fastclick.com>
Date: Thu, 10 Feb 2005 13:53:33 -0800
From: Jeff Behl <jbehl@fastclick.com>
User-Agent: Mozilla Thunderbird 0.8 (Windows/20040913)
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: Joe Kelsey <joe@zircon.seattle.wa.us>
References: <20050209162202.I31921@knight.ixsystems.net>
	<20050210005856.GC818@thened.net> <20050209164359.J31921@knight.ixsystems.net>
	<1108005975.683.47.camel@zircon.zircon.seattle.wa.us>
In-Reply-To: <1108005975.683.47.camel@zircon.zircon.seattle.wa.us>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
cc: freebsd-advocacy@freebsd.org
cc: freebsd-questions@freebsd.org
Subject: Re: FreeBSD 5.3 MySQL Performance
X-BeenThere: freebsd-advocacy@freebsd.org
X-Mailman-Version: 2.1.1
Precedence: list
List-Id: FreeBSD Evangelism <freebsd-advocacy.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-advocacy>,
	<mailto:freebsd-advocacy-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-advocacy>
List-Post: <mailto:freebsd-advocacy@freebsd.org>
List-Help: <mailto:freebsd-advocacy-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-advocacy>,
	<mailto:freebsd-advocacy-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Thu, 10 Feb 2005 21:52:37 -0000


>Any so-called "benchmark" comparing Linux to anything else (especially
>windoze) has been polluted by the tradition in the linux/windoze world
>of running their disks in the completely unsafe "asynchronous" mode so
>popular with the ATA disk drive manufacturers.  This method means that
>you never actually know whether or not the drive ever writes your data
>on the disk.  It could just sit in the cache waiting for a power failure
>so that you lose everything.  This "async" mode means that the
>benchmarks "look" fast but are completely unsafe.
>
>  
>

so by this logic, if i re-mount my partitions async i can get the same 
performance?  this isn't meant as a rub, i would seriously consider 
doing this if it were the case. i'd like to know any and all ways i can 
make mysql faster.  we have fleats of mysql servers with redundant 
data.  the loss of a server due to corruption is not problematic