Date: Wed, 20 Mar 2013 12:45:37 +0200 From: Daniel Kalchev <daniel@digsys.bg> To: freebsd-fs@freebsd.org Subject: Re: FreBSD 9.1 and ZFS v28 performances Message-ID: <51499351.1040406@digsys.bg> In-Reply-To: <4930f6fddf6a995051bc6554d1a6a6b7@sys.tomatointeractive.it> 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>
next in thread | previous in thread | raw e-mail | index | archive | help
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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?51499351.1040406>