Percona Live: Data Performance Conference 2016 Logo

April 18-21, 2016

Santa Clara, California

MySQL Query Performance Tuning: A 12 Step Program

MySQL Query Performance Tuning: A 12 Step Program

 20 April 02:00 PM - 02:50 PM @ Ballroom H
Experience level: 
50 minutes conference
Tools and Techniques


Performance tuning can be complex. It's often hard to know which knob to turn or button to press to get the biggest performance boost. In this presentation, Janis Griffin, Database Performance Evangelist, SolarWinds, will detail 12 steps to quickly identify performance issues and resolve them. Attendees at this session will learn how to: • Quickly fine tune a SQL statement • Understand MySQL explain plans and learn several techniques to come up with the best execution plan • Identify performance inhibitors to help avoid future performance issues


Janis Griffin's picture

Janis Griffin

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.

Share this talk