Does Your Performance Tuning Need a 12-step Program?
MySQL query tuning is often more art than science and it can quickly eat up a lot of time. In this presentation, Janis Griffin, performance evangelist and 20+ year database expert, will share her secrets for determining the best approach for tuning queries by utilizing the performance schema (specifically instrumented wait events and thread states), query execution plans, SQL diagramming techniques and more. Regardless of the complexity of your database or your skill level, this systematic approach will lead you down the correct tuning path with no guessing, saving countless hours tuning queries and optimizing performance of your MySQL-based databases.
Senior DBA / Database Performance Evangelist, SolarWinds, Inc
Janis Griffin has over 25 years of DBA experience including design, development and implementation of many mission critical databases. Before coming to Solarwinds, Janis held DBA positions primarily in the Telecom / Network industries (15 yrs), managing real-time routing and B2B OLTP databases. As a principal architect, a senior manager, and an Oracle ACE, Janis mentors many DBAs on best practices in database design and performance tuning. She has proven to be an effective collaborator providing cutting-edge database solutions.