All the articles I've posted.
Getting the most out of your existing MySQL instance by finding and fixing slow queries before reaching for replicas, sharding, or partitioning.