From owner-freebsd-stable@FreeBSD.ORG Thu Sep 16 10:42:41 2010 Return-Path: Delivered-To: stable@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id A5A1D1065670; Thu, 16 Sep 2010 10:42:41 +0000 (UTC) (envelope-from mad@madpilot.net) Received: from megatron.madpilot.net (megatron.madpilot.net [88.149.173.206]) by mx1.freebsd.org (Postfix) with ESMTP id 41F908FC24; Thu, 16 Sep 2010 10:42:40 +0000 (UTC) Received: from megatron.madpilot.net (localhost [127.0.0.1]) by megatron.madpilot.net (Postfix) with ESMTP id 16B4A147A; Thu, 16 Sep 2010 12:42:40 +0200 (CEST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=madpilot.net; h= user-agent:in-reply-to:content-disposition:content-type :content-type:mime-version:references:message-id:subject:subject :from:from:date:date:received:received; s=mail; t=1284633757; x= 1286448157; bh=oL1kYV4GBF6GJFZHxYg7hlrV5YFOcETCEGdS9Uumofc=; b=a Gxg7dMIRq4mDX4ZFp62UKaBbNuqhp+D4olZMfzmMLw/Smmu9EYA1t/KM0REBMBqv EGouWUu22hhMw+KLfZAYWRGHKjrRzcY4w1vcgKaK8XxUPlOCwKS2RYEVV1O2GDh1 YNedCiQxPAGtEyK0y112Q9Nk+KrMJ67ZWqLy1jIzGo= X-Virus-Scanned: amavisd-new at madpilot.net Received: from megatron.madpilot.net ([127.0.0.1]) by megatron.madpilot.net (megatron.madpilot.net [127.0.0.1]) (amavisd-new, port 10026) with ESMTP id 3kWCjKPexTZR; Thu, 16 Sep 2010 12:42:37 +0200 (CEST) Received: by megatron.madpilot.net (Postfix, from userid 1000) id 1FE501472; Thu, 16 Sep 2010 12:42:37 +0200 (CEST) Date: Thu, 16 Sep 2010 12:42:36 +0200 From: Guido Falsi To: Marian Hettwer Message-ID: <20100916104236.GB33879@megatron.madpilot.net> References: <201009152007.17320.Pascal.Stumpf@cubes.de> <201009151830.o8FIUWEZ021844@lava.sentex.ca> <4C911AB0.6090901@delphij.net> <4C91AEBF.50502@FreeBSD.org> <20100916084240.GA33879@megatron.madpilot.net> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: X-Operating-System: FreeBSD 8.1-STABLE User-Agent: Mutt/1.5.20 (2009-06-14) Cc: d@delphij.net, Pascal Stumpf , stable@freebsd.org, Xin LI , Martin Matuska Subject: Re: MFC of ZFSv15 X-BeenThere: freebsd-stable@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Production branch of FreeBSD source code List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Thu, 16 Sep 2010 10:42:41 -0000 On Thu, Sep 16, 2010 at 10:53:02AM +0100, Marian Hettwer wrote: > On Thu, 16 Sep 2010 10:42:40 +0200, Guido Falsi > wrote: > > On Thu, Sep 16, 2010 at 07:44:31AM +0200, Martin Matuska wrote: > >> I have fixed the missing bits in r212688. > >> > >> Thanks for the notice. > > > > Just a thank you message for the v15 development, MFS and this fast > > fix. Maybe this is just noise on the lists, but I think that too > > little thanks get to the FreeBSD developers, so a little noise like > > this may be beneficial. > > Agreed to that! Thanks for all the efforts in bringing ZFS to FreeBSD. > I'm running 8.1-Release with v15 without any problems. > > I just copied a 21GB MySQL datadir from a linux box to my FreeBSD/zfs > workstation. Thanks to zfs compression the 21GB only consume 10GB on > zfs. > That's massive compression :-) Related to this, I have a question. Is it convenient to put databases on a compresed filesystem? Apart from the space advantage, does it give any speed advantage/penalty? Anyone has some benchmark or objective data about this? Also are we talking about MyISAM or InnoDB tables? Or a mix of those? -- Guido Falsi