Tuning MySql on Solaris?

Diet version:

ZFS:

• recordsize=16k
• logbias=throughput
• atime=off
• compression=lz4
• primarycache=metadata

InnoDB:

• innodb_doublewrite=0
• 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.