This session focuses on ZFS performance with MySQL, and explores its suitability for deploying workloads based on MyISAM and InnoDB. ZFS performance relative to other file systems and the impact of ZFS compression on MySQL performance will also be examined. The ZFS Intent Log (ZIL) and the second level Adaptive Replacement Cache (L2ARC) benefit from low latencies, and benchmark results will be presented with the ZIL and L2ARC placed on SSDs. ZFS also obviates the need for the InnoDB doublewrite buffer, and the performance benefits of disabling this buffer will be discussed. Finally, tuning tips and best practices will be outlined for achieving optimal MySQL performance with ZFS.
Allan Packer is a Principal Engineer working for the Performance Technologies engineering group at Sun Microsystems. He has developed tools used for performance and regression testing, acted as technical lead for several published TPC benchmarks, and developed a training curriculum used by SunU. Allan has worked on issues related to server systems performance, sizing, availability, and resource management, and currently leads the MySQL Performance and Scalability team at Sun. He has published articles in industry magazines, presented at international industry conferences, and his book “Configuring and Tuning Databases on the Solaris Platform” was published by Sun Press in December 2001.
Neel Nadgir works in the Performance & Availability Engineering group at Sun Microsystems. Neel has a long history with ZFS, performance, and databases. Neel is a senior member of the Sun/MySQL Performance & Scalability Project.
Comments on this page are now closed.
For information on exhibition and sponsorship opportunities at the conference, contact Sharon Cordesse at firstname.lastname@example.org
Download the MySQL Sponsor/Exhibitor Prospectus
For media-related inquiries, contact Maureen Jennings at email@example.com
To stay abreast of conference news and to receive email notification when registration opens, please sign up for the MySQL Conference newsletter.
View a complete list of MySQL contacts.