You know SSD’s make MySQL fast, but do you know why?
Everybody knows SSDs make MySQL faster because they are fast. But the story doesn’t end there. We will share what we’ve learned about the mechanics of MySQL performance on SSD’s. Our analysis will shed light on some interesting questions, such as: Why do some SSDs perform better with MySQL than others? Why does relative IO performance not always correlate to MySQL performance? Exactly which characteristics of SSD’s matter to MySQL? What causes the big gap between what high end SSDs are capable of and what MySQL can actually drive? How can MySQL evolve to get more benefit out of SSDs?