From owner-freebsd-fs@FreeBSD.ORG Wed Mar 20 10:45:49 2013 Return-Path: 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 DF99987F for ; Wed, 20 Mar 2013 10:45:49 +0000 (UTC) (envelope-from daniel@digsys.bg) Received: from smtp-sofia.digsys.bg (smtp-sofia.digsys.bg [193.68.21.123]) by mx1.freebsd.org (Postfix) with ESMTP id 56A4BE2A for ; Wed, 20 Mar 2013 10:45:48 +0000 (UTC) Received: from dcave.digsys.bg (dcave.digsys.bg [192.92.129.5]) (authenticated bits=0) by smtp-sofia.digsys.bg (8.14.6/8.14.6) with ESMTP id r2KAjbAn072541 (version=TLSv1/SSLv3 cipher=DHE-RSA-CAMELLIA256-SHA bits=256 verify=NO) for ; Wed, 20 Mar 2013 12:45:37 +0200 (EET) (envelope-from daniel@digsys.bg) Message-ID: <51499351.1040406@digsys.bg> Date: Wed, 20 Mar 2013 12:45:37 +0200 From: Daniel Kalchev User-Agent: Mozilla/5.0 (X11; FreeBSD amd64; rv:17.0) Gecko/20130304 Thunderbird/17.0.3 MIME-Version: 1.0 To: freebsd-fs@freebsd.org Subject: Re: FreBSD 9.1 and ZFS v28 performances References: <514729BD.2000608@contactlab.com> <810E5C08C2D149DBAC94E30678234995@multiplay.co.uk> <51473D1D.3050306@contactlab.com> <1DD6360145924BE0ABF2D0979287F5F4@multiplay.co.uk> <51474F2F.5040003@contactlab.com> <51475267.1050204@contactlab.com> <514757DD.9030705@contactlab.com> <4930f6fddf6a995051bc6554d1a6a6b7@sys.tomatointeractive.it> In-Reply-To: <4930f6fddf6a995051bc6554d1a6a6b7@sys.tomatointeractive.it> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-BeenThere: freebsd-fs@freebsd.org X-Mailman-Version: 2.1.14 Precedence: list List-Id: Filesystems List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 20 Mar 2013 10:45:49 -0000 On 20.03.13 05:36, Davide D'Amico wrote: > 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? Perhaps, if you delete the file, or preferably the entire ZFS dataset first. Copying an file over another existing, does not change anything with the destination file except it's contents and modification times. As is always with changing settings, it is safer to just create the entire data set from scratch, with the new settings. Daniel