Percona Live 2017 Open Source Database Conference

April 24 - 27, 2017

Santa Clara, California

Does Your Performance Tuning Need a 12-step Program?

Does Your Performance Tuning Need a 12-step Program?

 27 April - 1:50 PM - 2:40 PM @ Room 209
Experience level: 
Beginner
Duration: 
50 minutes conference
Tracks:
Operations
Developer
Topics:
MySQL
Optimization
Monitoring

Description

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.

Speakers

Janis Griffin's picture

Janis Griffin

Senior DBA / Database Performance Evangelist, SolarWinds, Inc

Biography:

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.

Share this talk