Date: Wed, 20 Mar 2013 20:52:00 +0100 From: Davide D'Amico <davide.damico@contactlab.com> To: Bob Friesenhahn <bfriesen@simple.dallas.tx.us> Cc: freebsd-fs@freebsd.org Subject: Re: FreBSD 9.1 and ZFS v28 performances Message-ID: <bbb8fd8ad189ecc1cc0347b81b131eee@sys.tomatointeractive.it> 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>
next in thread | previous in thread | raw e-mail | index | archive | help
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.
To recap, a collegue of mine was able to reach the same performances of
UFS using a lot of *magic* knobs or sysctls such as
vfs.zfs.txg.{synctime,timeout}, vfs.zfs.write_limit_override,
txg.write_limit_override and vfs.zfs.zil_disable=0.
So, the lesson for me is: with my hardware (R720 12core, 32GB ram),
with my raid/disks setup, with the software I have to use
(mysql-5.6.10-ent), with the dataset/payload I have to use I think I'll
use UFS (I have a lot of other dbserver using UFS) or (but I will know
this only tomorrow) I'll test CentOS on the same hardware to see how
does it perform, so I'll post my questions and/or results on
freebsd-performances ml :)
Thanks,
d.
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?bbb8fd8ad189ecc1cc0347b81b131eee>