Oracle Blog

Sun Reviewed Best Practices

Monday Feb 23, 2009

As a follow up to the previous Sysbench benchmark that ran on Solaris UFS (HTTP link pointer), we re-ran the benchmark using ZFS filesystem on the same setup and configuration. Solaris ZFS does not allow the forcedirectio option as with UFS. We followed the “ZFS Best Practices Guide” recommendations. Namely, we limited the size of the Adaptive Replacement Cache (ARC) to 1GB, and we set the ZFS recordsize to 16K as it matches the Innodb page size. We used the same MySQL configuration file “my.cnf” that was used in the previous UFS test.