Optimizing Storage Layout for InnoDB Tables
Building a composite index
Select Statement Optimization