From owner-freebsd-current@FreeBSD.ORG Thu Apr 29 14:36:25 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 58BF11065672 for ; Thu, 29 Apr 2010 14:36:25 +0000 (UTC) (envelope-from jasonjwwilliams@gmail.com) Received: from mail-pv0-f182.google.com (mail-pv0-f182.google.com [74.125.83.182]) by mx1.freebsd.org (Postfix) with ESMTP id 32DD38FC19 for ; Thu, 29 Apr 2010 14:36:24 +0000 (UTC) Received: by pvh1 with SMTP id 1so21800pvh.13 for ; Thu, 29 Apr 2010 07:36:24 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:received:date:message-id :subject:from:to:content-type; bh=IqniAL/ucJ1+2tvWFvgPS5QQcxMsHsgS5h9e6Tyoaa0=; b=Z3uxcagGG/cdDtY3GHCDJHOMR1fO4APGTAXAZWcWU2Bs9WgbpU0aXgqV8mIYNfPI1d jeCuEJ5PZxB8SarDW+ZTBXF7iuum6JpU0gzAYxQHddqopic/Im12Ph0UZ15GT/zpwb/C VjMzDmZbaXHi3Du7mkl15ooYuFBDy7feObnPQ= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:date:message-id:subject:from:to:content-type; b=qlYldcI9x2TLw2KqFlhcNhdL8pUhYcTp60UKHXG88PIEg+EpiEBZzudJQt7+1IdsLJ yfFAgJkCLNEyLRWTBDIgsT394IHA8GX2iz7vo8OTZlgaooA4rzBTPPRHb4EaN0vnBIqu hAjb3WNNr2WHIdYIFoYQHZs4JT4UwnrHA2wJo= MIME-Version: 1.0 Received: by 10.141.214.35 with SMTP id r35mr3290847rvq.264.1272551473166; Thu, 29 Apr 2010 07:31:13 -0700 (PDT) Received: by 10.141.27.20 with HTTP; Thu, 29 Apr 2010 07:31:12 -0700 (PDT) Date: Thu, 29 Apr 2010 08:31:12 -0600 Message-ID: From: "Jason J. W. Williams" To: freebsd-current@freebsd.org Content-Type: text/plain; charset=ISO-8859-1 Subject: 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:36:25 -0000 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. -J