From owner-freebsd-current@FreeBSD.ORG Fri Apr 30 08:05:31 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 2E073106566C for ; Fri, 30 Apr 2010 08:05:31 +0000 (UTC) (envelope-from p.massat@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 C95438FC0A for ; Fri, 30 Apr 2010 08:05:30 +0000 (UTC) Received: by vws4 with SMTP id 4so1433258vws.13 for ; Fri, 30 Apr 2010 01:05:21 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:mime-version:sender:received :in-reply-to:references:from:date:x-google-sender-auth:message-id :subject:to:cc:content-type; bh=ASPsBki6/62Q+bH0tXy7zkLISIcR+CrgV0zGGScvp/k=; b=mBNyzePABjzp8DeSeaaadDqWTeiKMTo9Z8enHkaEbVsBN46wxld69Jm1HU+JDFUze1 uborIgr0Y+cXCVwzkfI9cU19CCIw5059uz6Rlkg+C6rqMELpaM0QUlgzLkOGLDOzLAcq GptDunr1DJIn+UHoJOhRiTbl4UB7Zl8FV8N+A= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:sender:in-reply-to:references:from:date :x-google-sender-auth:message-id:subject:to:cc:content-type; b=p/0bvgZybam0C9opnbd5a/NlmYiUC9go9iPh4vdJ2O1FQGUee3W7P38APJ4ZYhvR6j tjtMCl62S1nsOgGHkLCmOKyY0o9AkeKoJs3NZYM9aB4sSQmRdbHGsnSgE/2cQTE6jd+P Z/MNPe3RztWTGGYqX9Vn39mMEFmInIj8j+oYU= Received: by 10.150.119.37 with SMTP id r37mr1463804ybc.341.1272614719437; Fri, 30 Apr 2010 01:05:19 -0700 (PDT) MIME-Version: 1.0 Sender: p.massat@gmail.com Received: by 10.100.165.19 with HTTP; Fri, 30 Apr 2010 01:04:59 -0700 (PDT) In-Reply-To: References: From: Pierre Massat Date: Fri, 30 Apr 2010 10:04:59 +0200 X-Google-Sender-Auth: 66891277d03fef40 Message-ID: To: "Jason J. W. Williams" Content-Type: text/plain; charset=UTF-8 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, 30 Apr 2010 08:05:31 -0000 Hi everybody, On Thu, Apr 29, 2010 at 4:31 PM, Jason J. W. Williams wrote: > 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? I'm running MySQL 5.5 (Server version: 5.5.1-m2-log FreeBSD port: mysql-server-5.5.1) on FreeBSD 8.0 with a quite recent kernel (FreeBSD 8.0-STABLE (GENERIC) #0: Tue Feb 23 12:38:58 UTC 2010). I've done some tweaks to ZFS, like limiting ARC size, followed advices like recordsize matching InnoDB page size (i'm using InnoDB on my 4Go database). We have 11% of reads and 89% of writes and we make around 300 queries per second. The thing is it runs well except that once, I had a very big slowdown on MySQL : UPDATE queries were taking 30 seconds (which is actually the timeout in my.cnf) to complete. I can't tell if it was a MySQL problem (as i'm using something which is not release yet i think) or if it's due to ZFS. However, after a restart, everything was back to normal and things are running well. We have a lot of memory, 32 Go (yes, the box is actually oversize for what we're doing right now), and we don't stress the server so much (it has 2x XeonQuand X55xx), and that might be a reason why it runs well (we don't push ZFS and the server to the limits). I hope it's useful for you. If you need anything more, please ask. -- Pierre Massat