ITT 2018 - Sveta Smirnova - Introduction into MySQL Query Tuning

ITT 2018 - Sveta Smirnova - Introduction into MySQL Query Tuning

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 query or change table structure to achieve better performance.

990b89ca5f918a94ef6523d399eda9a4?s=128

Istanbul Tech Talks

April 17, 2018
Tweet