Here's a compendium of practical MySQL optimization tricks - from bottlenecks to configuration and indexes. Leave your ORM behind and get your hands dirty!
How to Optimize MySQL: Indexes, Slow Queries, Configuration
Beyond Rails Abstractions: A Dive into Database Internals
David Bush discusses the importance of understanding core functionality in Rails, showing how indexes work and how to implement a database by yourself.