From owner-freebsd-current@FreeBSD.ORG Thu Apr 29 17:03:47 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 55362106566C for ; Thu, 29 Apr 2010 17:03:47 +0000 (UTC) (envelope-from jasonjwwilliams@gmail.com) Received: from mail-vw0-f54.google.com (mail-vw0-f54.google.com [209.85.212.54]) by mx1.freebsd.org (Postfix) with ESMTP id 050688FC1A for ; Thu, 29 Apr 2010 17:03:46 +0000 (UTC) Received: by vws4 with SMTP id 4so876276vws.13 for ; Thu, 29 Apr 2010 10:03:39 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:received:in-reply-to :references:date:message-id:subject:from:to:cc:content-type :content-transfer-encoding; bh=L8qkFjGFdhHmhJ8vX/RvebVvQdeMhIqsX+ueCPEBaNA=; b=lm6WeNYxAPBda+uie61zU+DorJHOkFb3uHPqSRvfwzqpPZnJAb/ljAv/EgsrIn31eE GacWSZOXamFY5SY+MZy3HkLxMcbUDi+yRxbzSq2Cj3ltRWpSUo/Jb2/POiwtajhgCD19 wuoyHZ1CB6IrHdaW4/1h9XCsJJxxw0Cp1FUB4= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc:content-type:content-transfer-encoding; b=XG1lxsbxP6unysj5oCZcU/N+TObdgtuDmGyRPIFd3XBTY0ClPtZLZ0swkj9W7JodTX rtFzZOVlz4+SGwQAZ6tmksRQJRPQt97Q5Qm6KuJncNOkqzO4M4DZPhZIoxruYNy/1GgN xzFd+NOX/cuQSklcsCy6Wdi89R4J1CAEr/zqM= MIME-Version: 1.0 Received: by 10.224.17.149 with SMTP id s21mr2912163qaa.46.1272560618940; Thu, 29 Apr 2010 10:03:38 -0700 (PDT) Received: by 10.224.28.138 with HTTP; Thu, 29 Apr 2010 10:03:38 -0700 (PDT) In-Reply-To: References: Date: Thu, 29 Apr 2010 11:03:38 -0600 Message-ID: From: "Jason J. W. Williams" To: =?ISO-8859-1?Q?Micka=EBl_Maillot?= Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Cc: Olivier Smedts , 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 17:03:47 -0000 Hi Mickael, Thank you for the detailed response! By "wait 8.1 to have all recent zfs enhancement for prod" are you referring to the ZFS enhancements they've made over the past year in that regard, or enhancements the FreeBSD committers are making to make ZFS on FreeBSD work better? I've got to stand up some additional infrastructure within a short time commitment, so I might not be able to wait for 8.1. (I assume it's not due in the next 30 days.) -J On Thu, Apr 29, 2010 at 10:50 AM, Micka=EBl Maillot wrote: > i have two freebsd running MySQL 5.1 on ZFS: > - first: a 7-STABLE build (7.2, 2 month after zfs v13 import) > the machine crash recently after a 130 day uptime beceause i dont > limit arc size (so 4Gb by default) and i think they run oom. > even with vfs.zfs.cache_flush_disable=3D1, no data loose, innodb redo > the log and the mysql is fine. > - second: a 8-STABLE > FreeBSD db4.security-mail.net 8.0-STABLE FreeBSD 8.0-STABLE #2: Mon > Apr 19 12:48:20 CEST 2010 > root@db4.security-mail.net:/usr/obj/usr/src/sys/GENERIC =A0amd64) > updated recently, no problem at all. > > i follow all opensolaris databases recommendation but there is some > diff between freebsd and osol. > like primarycache=3Dmetadata > > we have a realy big table (~ 1,5 To) in innodb split with mysql > partition (compress ration ~ x2) and it's works pretty well. > > i would recommend you to wait 8.1 to have all recent zfs enhancement > for prod unless you follow all mailing list and commit. > > > 2010/4/29 Jason J. W. Williams : >> Hi Olivier, >> >> We've actually been running MySQL on ZFS on Solaris for quite some >> time. :) We're very comfortable with that setup. >> >> My question is more specific to live experience with doing the same >> thing on FreeBSD. We know where the sabots are on MySQL/ZFS/Solaris. >> Would like to find out where the landmines are when you swap Solaris >> for FreeBSD in that equation. >> >> Thank you again. >> >> -J >> >> On Thu, Apr 29, 2010 at 8:48 AM, Olivier Smedts wrote= : >>> 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 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 = =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 _ >>> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0= =A0 =A0ASCII ribbon campaign ( ) >>> e-mail: olivier@gid0.org =A0 =A0 =A0 =A0- against HTML email & vCards = =A0X >>> www: http://www.gid0.org =A0 =A0- against proprietary attachments / \ >>> >>> =A0"Il y a seulement 10 sortes de gens dans le monde : >>> =A0ceux qui comprennent le binaire, >>> =A0et ceux qui ne le comprennent pas." >>> >> _______________________________________________ >> freebsd-current@freebsd.org mailing list >> http://lists.freebsd.org/mailman/listinfo/freebsd-current >> To unsubscribe, send any mail to "freebsd-current-unsubscribe@freebsd.or= g" >> >