As I recently noted, I’m giving a short talk at Percona Live about our experience with Fusion-io for MySQL at Craigslist. As is often the case, I agreed to give the talk before giving too much thought about exactly what I’d say. But recently I’ve started to sweat a little at the prospect of having to think up a compelling and understandable presentation.
Thankfully, due to a cache misconfiguration this week, we ended up taking a number of steps that not only will help us to deal with future growth, but as a side-effect we got to directly quantify some of the benefits of Fusion-io in our big MySQL boxes. For whatever reason, the bulk of the presentation basically fell into my lap today.
Now I just have to put it all together.
I won’t go so far as to claim that this is an argument for procrastination,but it sure is nice when something like this happens. 🙂
Jeremy Zawodny's blog 
The phrase you’re looking for is, “I love it when a plan comes together”, preferably chomping a cigar at the same time.
Derek stole the words out of my keyboard.
It’d be interesting to hear in what configurations or workloads Fusion-io didn’t help significantly.
Err, my reply is below. I forgot about threading! Heh.
If your working set fits in RAM and you’re primarily CPU-bound, spending the money on Fusion-io would be a waste. But even in sequential reads, it’s way faster than most disk arrays.
Did not realize you authored MySQL books (read your new bio box). Where might I find the one you cited?
First Edition:
http://www.amazon.com/High-Performance-MySQL-Jeremy-Zawodny/dp/0596003064/jeremydzawodny
Second Edition:
http://www.amazon.com/High-Performance-MySQL-Optimization-Replication/dp/0596101716/jeremydzawodny
Jeremy
Pingback: Slides for: Fusion-io and MySQL 5.5 at Craigslist | Jeremy Zawodny's blog
Pingback: When an example falls in your lap