FreBSD 9.1 and ZFS v28 performances

[Bob Friesenhahn]

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 at simple.dallas.tx.us, http://www.simplesystems.org/users/bfriesen/
GraphicsMagick Maintainer,    http://www.GraphicsMagick.org/