2

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.

0

I'd recommend using the MySQL from Sun's Glassfish Web Stack which is Sun's tuned version of MySQL for Solaris. Web Stack used to called Cool Stack, and both are supported in this forum.

3

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.

0
0

There is article about optimization of ZFS, but it's dedicated for InnoDB: MySQL Innodb ZFS Best Practices

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy