Need for Speed: Getting MySQL Query Tuning Right the First Time

MySQL query tuning is often more art than science and it can quickly eat up a lot of DBA and/or Developer time. This presentation outline a method for determining the best approach for tuning queries by utilizing the performance schema (specifically instrumented wait events and thread states), query execution plans and SQL diagramming techniques. Regardless of the complexity of the statement or your skill level, this quick, systematic approach will lead you down the correct tuning path with no guessing, saving countless hours tuning a query.