Understanding MySQL Explain

71a2ae84018279b9286caa4922297a6d?s=47 Ryan Lv
June 24, 2017

Understanding MySQL Explain

## 大纲

Objective:

- give you the hunch: bad query? best query?
- which columns are most important?

Material and Method

- MySQL 5.7.17
- Sakila sample database

Questions

- Shall we add indexes?
- Are indexes efficient?
- What's executation plan of optimizer?
- How to optimize queries?

what does those mean?

- id
- select_type
- table
- access_type
- ref
- rows
- extra

Which columns are more important?

- access type
- rows
- extra

视频

https://www.youtube.com/edit?o=U&video_id=3U-qFPlCLlM

PPT

https://speakerdeck.com/xiaoronglv/understanding-mysql-explain

71a2ae84018279b9286caa4922297a6d?s=128

Ryan Lv

June 24, 2017
Tweet