Introduction into MySQL Query Tuning for Dev[Op]s

Logo
Presented by

Sveta Smirnova, Principal Support Escalation Specialist, Percona

About this talk

In this talk Sveta will show how to get started with MySQL Query Tuning. She will make a short introduction into physical table structure and demonstrate how it may influence query execution time. She then 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.

Related topics:

More from this channel

Upcoming talks (0)
On-demand talks (30)
Subscribers (4777)
Percona is a leading provider of unbiased open source database solutions that allow organizations to easily, securely, and affordably maintain business agility, minimize risks, and stay competitive. Percona provides single-source expertise in multi-vendor environments that eliminates lock-in, increases agility and enables business growth.