Oracle® Solaris 11.2 Tunable Parameters Reference Manual

Exit Print View

Updated: December 2014

Using ZFS with MySQL Considerations

Review the following considerations when using ZFS with MySQL.

  • ZFS recordsize

    Match the ZFS recordsize property to the storage engine block size for better OLTP performance.

  • InnoDB

    With a known application memory footprint, such as for a database application, you might cap the ARC size so that the application will not need to reclaim its necessary memory from the ZFS cache.

  • Create a separate pool for the logs.

  • Set a different path for data and log in the my.cnf file.

  • Set the ZFS recordsize property to 16K for the InnoDB data files, and use the default recordsize value for InnoDB logs, prior to creating data files.