From owner-freebsd-fs@FreeBSD.ORG  Wed Mar 20 03:36:41 2013
Return-Path: <owner-freebsd-fs@FreeBSD.ORG>
Delivered-To: freebsd-fs@freebsd.org
Received: from mx1.freebsd.org (mx1.freebsd.org
 [IPv6:2001:1900:2254:206a::19:1])
 by hub.freebsd.org (Postfix) with ESMTP id 975A6F43
 for <freebsd-fs@freebsd.org>; Wed, 20 Mar 2013 03:36:41 +0000 (UTC)
 (envelope-from davide.damico@contactlab.com)
Received: from mail2.shared.smtp.contactlab.it
 (mail2.shared.smtp.contactlab.it [93.94.37.7])
 by mx1.freebsd.org (Postfix) with ESMTP id 190AA979
 for <freebsd-fs@freebsd.org>; Wed, 20 Mar 2013 03:36:40 +0000 (UTC)
DKIM-Signature: v=1; a=rsa-sha256; d=contactlab.it; s=clab1; c=relaxed/relaxed;
 q=dns/txt; i=@contactlab.it; t=1363750592;
 h=From:Subject:Date:To:MIME-Version:Content-Type;
 bh=uq19aj7NlNIj026w35pouYR8mMZm2AO78OwdjaF/bIE=;
 b=drcV6jMAkCCdyRTrspu3jAdbhbKqj01a14BfuGtMs95uQg2RwOlADA67OJmktRbp
 jPBMO1KIkf+VWMNxhLFSbMtkjdCGLRSfHOnLwn83+lzuVutd6ri88seDz+uclUCN
 v60OvwzmXFZsawwCYkX1SUh/B4fuEAmwCFqcVHuEarc=;
Received: from [213.92.90.12] ([213.92.90.12:61650] helo=mail3.tomato.it)
 by t.contactlab.it (envelope-from <davide.damico@contactlab.com>)
 (ecelerity 3.5.1.37854 r(Momo-dev:3.5.1.0)) with ESMTP
 id DD/B6-24145-0CE29415; Wed, 20 Mar 2013 04:36:32 +0100
Received: from mx3-master.housing.tomato.lan ([172.16.7.55])
 by mail3.tomato.it with smtp (Exim 4.80.1 (FreeBSD))
 (envelope-from <davide.damico@contactlab.com>) id 1UI9pI-0000fY-EI
 for freebsd-fs@freebsd.org; Wed, 20 Mar 2013 04:36:32 +0100
Received: (qmail 2570 invoked by uid 80); 20 Mar 2013 03:36:32 -0000
To: Bob Friesenhahn <bfriesen@simple.dallas.tx.us>
Subject: Re: FreBSD 9.1 and ZFS v28 performances
X-PHP-Script: uebmeil.sys.tomatointeractive.it/index.php for 172.16.16.227
X-PHP-Originating-Script: 0:main.inc
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8;
 format=flowed
Content-Transfer-Encoding: 7bit
Date: Wed, 20 Mar 2013 04:36:32 +0100
From: Davide D'Amico <davide.damico@contactlab.com>
Organization: ContactLab
Mail-Reply-To: <davide.damico@contactlab.com>
In-Reply-To: <alpine.GSO.2.01.1303192036240.11141@freddy.simplesystems.org>
References: <514729BD.2000608@contactlab.com>
 <810E5C08C2D149DBAC94E30678234995@multiplay.co.uk>
 <51473D1D.3050306@contactlab.com>
 <1DD6360145924BE0ABF2D0979287F5F4@multiplay.co.uk>
 <51474F2F.5040003@contactlab.com>
 <E106A7DB08744581A08C610BD8A86560@multiplay.co.uk>
 <51475267.1050204@contactlab.com> <514757DD.9030705@contactlab.com>
 <A9C89C979F8D4CBABE73256A1C66E95D@multiplay.co.uk>
 <alpine.GSO.2.01.1303192036240.11141@freddy.simplesystems.org>
Message-ID: <4930f6fddf6a995051bc6554d1a6a6b7@sys.tomatointeractive.it>
X-Sender: davide.damico@contactlab.com
User-Agent: Roundcube Webmail/0.8.5
Cc: freebsd-fs@freebsd.org
X-BeenThere: freebsd-fs@freebsd.org
X-Mailman-Version: 2.1.14
Precedence: list
Reply-To: davide.damico@contactlab.com
List-Id: Filesystems <freebsd-fs.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/options/freebsd-fs>,
 <mailto:freebsd-fs-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-fs>
List-Post: <mailto:freebsd-fs@freebsd.org>
List-Help: <mailto:freebsd-fs-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-fs>,
 <mailto:freebsd-fs-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Wed, 20 Mar 2013 03:36:41 -0000

Il 20.03.2013 02:37 Bob Friesenhahn ha scritto:
> On Mon, 18 Mar 2013, Steven Hartland wrote:
>> 
>> Oh and another thing if this is mysql did you set the right settings
>> for your ZFS volume e.g.
>> zfs set atime=off tank
>> zfs create tank/mysql
>> zfs set recordsize=16k tank/mysql
> 
> Very importantly, the recordsize should be set before first creating
> the database file.  The recordsize becomes a property of the file.
> Even if one sets it to 16k, the file will continue to use 128k if that
> was the setting when it was created.

Well, after changing the recordsite property, I copied the file from an 
UFS partition (using cp -Rp): this should use recordsize=16k, right?

Thanks,
d.