Loading…
Welcome to Percona Live Online 2021
Online Open Source Database Conference
REGISTER HERE!
Back To Schedule
Thursday, May 13 • 14:00 - 15:00
Introduction into MySQL Query Tuning for Dev[Op]s

Sign up or log in to save this to your schedule, view media, leave feedback and see who's attending!

Feedback form is now closed.


In this talk I will show how to get started with MySQL Query Tuning. I will make a short introduction into physical table structure and demonstrate how it may influence query execution time. Then we will discuss basic query tuning instruments and techniques, mainly EXPLAIN command with its latest variations. You will learn how to understand its output and how to rewrite queries or change table structure to achieve better performance.

Speakers
avatar for Sveta Smirnova

Sveta Smirnova

Principal Support Engineering Coordinator, Percona
Sveta Smirnova is a MySQL Support Engineer with over 10 years of experience. She currently works in Percona. Her main professional interests are problem-solving, working with tricky issues, bugs, finding patterns that can solve typical issues quicker, teaching others how to deal with... Read More →


Thursday May 13, 2021 14:00 - 15:00 EDT
Room #2