CodeMash 2007 – Maximum Velocity with MySQL

This session went over-time. Actually we were only through about half of it before we had to leave. Shame, it was a cool talk, I could have stayed for another hour or so learning about MySQL optimization.

I learned a few things on benchmarking (Apache Bench), and the EXPLAIN keyword. A few other tricks related to horizontal partitioning and some performance tweaks that can be made from using the INNER JOIN, as opposed to sub queries.

As I said, I wish the talk was longer, I have a feeling the cool stuff was last…