From owner-freebsd-questions@FreeBSD.ORG Thu Feb 10 23:15:00 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 413D816A4CE for ; Thu, 10 Feb 2005 23:15:00 +0000 (GMT) Received: from prosporo.hedron.org (hedron.org [66.11.182.60]) by mx1.FreeBSD.org (Postfix) with ESMTP id CB47443D1F for ; Thu, 10 Feb 2005 23:14:59 +0000 (GMT) (envelope-from ean@hedron.org) Received: from localhost.hedron.org (localhost.hedron.org [127.0.0.1]) by prosporo.hedron.org (Postfix) with ESMTP id 9DD4FC0C5 for ; Thu, 10 Feb 2005 18:15:07 -0500 (EST) From: Ean Kingston To: freebsd-questions@freebsd.org Date: Thu, 10 Feb 2005 18:15:06 -0500 User-Agent: KMail/1.7.1 References: <20050209162202.I31921@knight.ixsystems.net> <1108005975.683.47.camel@zircon.zircon.seattle.wa.us> <420BD7DD.5000304@fastclick.com> In-Reply-To: <420BD7DD.5000304@fastclick.com> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200502101815.07092.ean@hedron.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 23:15:00 -0000 On February 10, 2005 04:53 pm, Jeff Behl wrote: > >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 You will get significant speed increase out of your filesystem(s) if you mount them async. BUT if you don't unmount them properly you will have corrupted filesystems. I do this with /tmp. -- Ean Kingston E-Mail: ean AT hedron DOT org URL: http://www.hedron.org/