Blogs.
My take on things.

MySQL Indexes: From a Slow Query to a Better B+ Tree

Tracing a slow query through execution plans, composite indexes, and access patterns, with a look at the write and storage costs behind faster reads.