From owner-freebsd-questions@FreeBSD.ORG Thu Feb 10 21:52:37 2005 Return-Path: Delivered-To: freebsd-questions@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 User-Agent: Mozilla Thunderbird 0.8 (Windows/20040913) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Joe Kelsey 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: Matt Olander cc: freebsd-questions@freebsd.org Subject: Re: FreeBSD 5.3 MySQL Performance X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-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