MySQL Query Performance Tuning: A 12 Step Program
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
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.