MySQL users commonly ask: What indexes do I need? Why aren’t my indexes helping me? Don’t indexes cause overhead? This webinar will provide practical, step by step methods for finding the queries you need to optimize and choosing the best indexes for them.
Video source and slides: http://www.percona.tv/percona-webinars/tools-and-techniques-for-index-design