Date: Wed, 20 Mar 2013 13:32:19 +0100 From: "Ronald Klop" <ronald-freebsd8@klop.yi.org> To: freebsd-fs@freebsd.org Subject: Re: FreBSD 9.1 and ZFS v28 performances Message-ID: <op.wt8vr5c38527sy@ronaldradial.versatec.local> In-Reply-To: <51499351.1040406@digsys.bg> 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> <4930f6fddf6a995051bc6554d1a6a6b7@sys.tomatointeractive.it> <51499351.1040406@digsys.bg>
next in thread | previous in thread | raw e-mail | index | archive | help
On Wed, 20 Mar 2013 11:45:37 +0100, Daniel Kalchev <daniel@digsys.bg> wrote: > > 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 ZFS never overwrites contents of a files. It always allocates new blocks.
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?op.wt8vr5c38527sy>