All generalizations are incorrect Charles Suresh's blog

Tuesday Aug 18, 2009

Although I will go into the details of how the MySQL/Innodb/ZFS read-only performance was improved almost 5x using SSDs for L2ARC, this blog is primarily focused on understanding why I got that improvement for the configuration that I was using. I'll also discuss why the tuning tip I mentioned in my previous blog entry, of matching the ZFS block size to the database record size, is not such a good idea for this particular test.[Read More]

Wednesday Jul 22, 2009

In some cases, system performance can be improved simply by reducing wasteful work. So in this blog, I talk about tools and techniques you can use to find if your system is doing more I/O than necessary and what you can do about it.[Read More]

Thursday Apr 09, 2009

A map is a lifesaver when embarking down unfamiliar territory. When I recently started working on ZFS performance (in the context of MySQL usage), I needed a code flow chart to know what parts I needed to focus on within ZFS. Take a look at the map of ZFS I generated to help me along the way.[Read More]