Top Five MySQL Query Tuning Tips

Tuesday 5:25PM-5:50PM

@ Room M3

MySQL / MariaDB

25 minutes conference

Beginner

Tracks:
Developer, Business / Case Studies

Query 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 at SolarWinds, 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 of tuning queries and optimizing performance of your MySQL® databases.

Learning objectives:
- Learn how to effectively use the performance schema to quickly identify bottlenecks and get clues on the best tuning approach
- Quickly identify inefficient operations through review of query execution plans
- Learn how to use SQL diagramming techniques to find the best plan
 


Speakers

Janis Griffin

Janis Griffin (SolarWinds)

Database Performance Evangelist

Biography:

Janis Griffin has over 25 years of DBA experience including design, development and implementations of many critical database applications. Before coming to SolarWinds over 10 years ago, Janis held DBA positions working with both real-time network routing databases and OLTP business to business applications. As a Principal Architect and Senior Manager, Janis has mentored many other DBAs on best practices in database performance tuning.


Slides



  Download Slides  

Connect with Percona

Stay Connected on:

Percona Live Conferences

The Percona Live Open Source Database Conferences are the premier event for the diverse and active open source database community, as well as businesses that develop and use open source database software.
 

Contact Us

For general information about the event/expo/conference, including registration, please contact us at:

  • info(@) percona.com
  • +1-888-401-3401
  • +1-919-948-2863