FreBSD 9.1 and ZFS v28 performances

[Davide D'Amico]

[...]

> 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

# zfs get all DATA | egrep -e "atime|record"
DATA  recordsize            16K                    local
DATA  atime                 off                    local

I didn't create tank/mysql, I issued:
# zpool create DATA mirror ...
# cd /DATA
# zfs set atime=off DATA
# zfs set recordsize=16k DATA
# mkdir mysql
# chown mysql:mysql mysql
# cp -Rp /repo/mysql/* /DATA/mysql
[..]
#

I think it's the same.

I've used:
vfs.zfs.prefetch_disable="1"

and
vfs.zfs.prefetch_disable="0"

same result.

I tried enabling/disabling in /boot/loader.conf (I have 32GB ram):
vfs.zfs.arc_min="4096M"
vfs.zfs.arc_max="15872M"
vm.kmem_size_max="64G"
vm.kmem_size="49152M"
vfs.zfs.write_limit_override=1073741824

same result.

Thanks,
d.