Date: Tue, 19 Mar 2013 20:37:34 -0500 (CDT) From: Bob Friesenhahn <bfriesen@simple.dallas.tx.us> To: Steven Hartland <killing@multiplay.co.uk> Cc: freebsd-fs@freebsd.org, Davide D'Amico <davide.damico@contactlab.com> Subject: Re: FreBSD 9.1 and ZFS v28 performances Message-ID: <alpine.GSO.2.01.1303192036240.11141@freddy.simplesystems.org> In-Reply-To: <A9C89C979F8D4CBABE73256A1C66E95D@multiplay.co.uk> 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>
next in thread | previous in thread | raw e-mail | index | archive | help
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. Bob -- Bob Friesenhahn bfriesen@simple.dallas.tx.us, http://www.simplesystems.org/users/bfriesen/ GraphicsMagick Maintainer, http://www.GraphicsMagick.org/
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?alpine.GSO.2.01.1303192036240.11141>