How to Analyze and Tune MySQL Queries for Better Performance
Query performance is essential in making any application successful. In order to finely tune your queries you first need to understand how MySQL executes them, and what tools are available to help identify problems.
In this session you will learn:
1) The common tools for researching problem queries
2) What an Index is, and why you should use one
3) Index limitations
4) When to rewrite the query instead of just adding a new index