We are running MySql 5.x on Solaris 10. Are there any good MySql options, or system options that we can use to optimize performance on an x86 Solaris 10 box with 16GB of RAM, running ZFS? For example, with UFS, people recommended mount the filesystem with the directio option.
- innodb_log_write_ahead_size=16384 (if your version has it)
There are a few other options you may want to look into. I wrote an article based on a talk I gave a while back about running MySQL on ZFS which you may find helpful.
There is article about optimization of ZFS, but it's dedicated for InnoDB: MySQL Innodb ZFS Best Practices