From owner-freebsd-current@FreeBSD.ORG Thu Apr 29 14:48:17 2010 Return-Path: Delivered-To: freebsd-current@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 44757106566B for ; Thu, 29 Apr 2010 14:48:17 +0000 (UTC) (envelope-from olivier@gid0.org) Received: from mail-fx0-f54.google.com (mail-fx0-f54.google.com [209.85.161.54]) by mx1.freebsd.org (Postfix) with ESMTP id D80708FC0C for ; Thu, 29 Apr 2010 14:48:16 +0000 (UTC) Received: by fxm15 with SMTP id 15so1158711fxm.13 for ; Thu, 29 Apr 2010 07:48:09 -0700 (PDT) MIME-Version: 1.0 Received: by 10.239.182.193 with SMTP id r1mr846160hbg.210.1272552489332; Thu, 29 Apr 2010 07:48:09 -0700 (PDT) Received: by 10.239.149.141 with HTTP; Thu, 29 Apr 2010 07:48:09 -0700 (PDT) In-Reply-To: References: Date: Thu, 29 Apr 2010 16:48:09 +0200 Message-ID: From: Olivier Smedts To: "Jason J. W. Williams" Content-Type: text/plain; charset=ISO-8859-1 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: Thu, 29 Apr 2010 14:48:17 -0000 2010/4/29 Jason J. W. Williams : > Hi Y'all, > > 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? > > 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. > > Any thoughts or comments are greatly appreciated. No experience with databases on ZFS but I think you should set the recordsize property to a proper (I mean, for your MySQL setup) value on the FS that will hold the data. Have a look at : http://www.solarisinternals.com/wiki/index.php/ZFS_for_Databases Cheers > > -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" > -- Olivier Smedts _ ASCII ribbon campaign ( ) e-mail: olivier@gid0.org - against HTML email & vCards X www: http://www.gid0.org - against proprietary attachments / \ "Il y a seulement 10 sortes de gens dans le monde : ceux qui comprennent le binaire, et ceux qui ne le comprennent pas."