Basic MySQL Optimizer Tracing

preview_player
Показать описание
Query performance is critical to for any serious application.

EXPLAIN can tell you how the results were retrieved.

But as a Data Guardian, you will need to be able to dig into the details of why MySQL chooses a particular path to resolve queries.

Luckily, you can trace the MySQL optimizer to find out why.

Рекомендации по теме
Комментарии
Автор

I am making a presentation about MySQL and I have to say: this was a very well structured and comprehensive(optimized?) video explaining the basic idea!

dthnote