From owner-freebsd-current@FreeBSD.ORG Thu Apr 29 16:50:18 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 51642106566B for ; Thu, 29 Apr 2010 16:50:18 +0000 (UTC) (envelope-from mickael.maillot@gmail.com) Received: from mail-wy0-f182.google.com (mail-wy0-f182.google.com [74.125.82.182]) by mx1.freebsd.org (Postfix) with ESMTP id A43258FC12 for ; Thu, 29 Apr 2010 16:50:17 +0000 (UTC) Received: by wyb36 with SMTP id 36so464432wyb.13 for ; Thu, 29 Apr 2010 09:50:10 -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=GWTv7A6hN67RExsJ6cW2QuMuYlMBPN0W4ayvr6E+zF0=; b=kXkLo3WxHWE/SKHIVZyijIE+XM0syEYUf60uDxuB30PuoRDnKSfNlAZ17paLzb6odv oTobi7fh78HGJdCwIUrfYskPunog026DRmWyCsLi/rovFLev6Rf1ZbW1dgv1ytvRAsLZ FAmeu+SX5IHd6jLfSPbkbKMRTARZ2kShSuPWc= 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=ICFqkaIW6+dPQKBpT/zuVzpkyU2Pm2WxUvrSEWRZ1W+BB/KlUxdn0ZlrMuIA7GU20J DD8E37K8MxpURwgrj5ykxetzmMY2nL+tg2qeGZjxZUxKE0/zmhPNT6Chw80YE9/ThS0z iOFKHREnZVbv0pqxh/q8MBBRUHHmHKWzP3gYM= MIME-Version: 1.0 Received: by 10.216.154.145 with SMTP id h17mr517490wek.103.1272559809813; Thu, 29 Apr 2010 09:50:09 -0700 (PDT) Received: by 10.216.51.12 with HTTP; Thu, 29 Apr 2010 09:50:09 -0700 (PDT) In-Reply-To: References: Date: Thu, 29 Apr 2010 18:50:09 +0200 Message-ID: From: =?ISO-8859-1?Q?Micka=EBl_Maillot?= To: "Jason J. W. Williams" 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 16:50:18 -0000 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 amd64) 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.o= rg" >>> >> >> >> >> -- >> 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.org= " >