From owner-freebsd-current@FreeBSD.ORG Fri May 7 17:54:28 2010 Return-Path: Delivered-To: freebsd-current@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [69.147.83.52]) by hub.freebsd.org (Postfix) with ESMTP id DE9F3106564A for ; Fri, 7 May 2010 17:54:28 +0000 (UTC) (envelope-from ltning@anduin.net) Received: from mail.anduin.net (mail.anduin.net [213.225.74.249]) by mx1.freebsd.org (Postfix) with ESMTP id 9FD508FC15 for ; Fri, 7 May 2010 17:54:28 +0000 (UTC) Received: from [212.62.248.146] (helo=[192.168.2.100]) by mail.anduin.net with esmtpsa (TLSv1:AES128-SHA:128) (Exim 4.71 (FreeBSD)) (envelope-from ) id 1OARkn-000HPF-VK; Fri, 07 May 2010 19:54:26 +0200 Mime-Version: 1.0 (Apple Message framework v1078) Content-Type: text/plain; charset=us-ascii From: =?iso-8859-1?Q?Eirik_=D8verby?= In-Reply-To: Date: Fri, 7 May 2010 19:54:25 +0200 Content-Transfer-Encoding: quoted-printable Message-Id: References: To: Jason J. W. Williams X-Mailer: Apple Mail (2.1078) Cc: freebsd-current@freebsd.org Subject: Re: ZFS Stability & MySQL (Comments Requested) X-BeenThere: freebsd-current@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Discussions about the use of FreeBSD-current List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Fri, 07 May 2010 17:54:28 -0000 Hi, just chirping in; we've upgraded a bunch of old 6.x servers to 8.0 with = ZFS. This is a pair of HP DL385 G1s (dual opteron, old stuff) with = SmartArray controllers, which had absolutely horrible performance in = both 6.0 and 8.0. The drive array gave us ~25 mbyte/s sustained, which = is obviously abysmal for U320/15k SCSI drives backed by hardware RAID = and cache. We ended up splitting the hardware RAID into single drives, and using = ZFS/RaidZ. We suddenly got around 45 mbye/s (still bad) per channel, = adding up nicely when benchmarking the RaidZ volume. MySQL now performs much better than before, and we've enabled = compression (gzip-2) and fixed block sizes. Compression ratio is about = 1.7:1, transaction latency on the database (as seen from application) = has gone down by about 65% on average. We see anything between 300 and 2000 queries/second throughout the day, = and our active dataset is about 500GB. The servers have 8GB of memory. /Eirik On Apr 29, 2010, at 4:31 PM, Jason J. W. Williams wrote: > Hi Y'all, >=20 > I've written before that we're considering moving to FreeBSD 8 from > OpenSolaris and are heavily reliant on ZFS. Has anyone used FreeBSDs > ZFS implementation for a high reliability environment like a database? > If so, what are your experiences? >=20 > Basically, I'm curious how stable the implementation is and whether > it's ready for a critical production environment. Also, any gotchas > particularly with running it with MySQL or anything else that utilizes > a lot of memory. On Solaris, we cap the max ARC size to keep it from > grabbing all the system RAM and competing with MySQL. >=20 > Any thoughts or comments are greatly appreciated. >=20 > -J > _______________________________________________ > freebsd-current@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-current > To unsubscribe, send any mail to = "freebsd-current-unsubscribe@freebsd.org" >=20