#MySQL's EXPLAIN Demystified - Boost your MySQL #Database - MySQL Tutorial

preview_player
Показать описание
If you don't understand #MySQL's EXPLAIN output, this webinar is for you. EXPLAIN output is confusing, but if you understand how it's created, it'll make sense to you.
You'll leave this webinar with the knowledge necessary to understand the most complex query plans, including those with filesorts, subqueries, and UNIONs.

You'll see the internals of #MySQL from a new angle. That knowledge will prepare you to reason about query execution plans the same way the MySQL server does. As a result, you'll be able to write queries that get the best performance from MySQL's query optimizer and executioner.

PRESENTER Baron Schwartz, February 21, 2012

Comment 💬, Share 🔗, Like 👍🏻, and Subscribe ✅ to our channel + Turn on the 🔔
📺Subscribe To Our Channel and Get More information about #OpenSource #Databases, #kubernetes and many other things.

You can find more about #OpenSource #Databases and Percona Live Online 2020 in these links 👇🏻👇🏻👇🏻

Connect With us on our Social Networks 👇🏻👇🏻👇🏻
Рекомендации по теме
Комментарии
Автор

I watched the full video and this is the only informative source I can find online on explaining the explain output.

tianhepeng
Автор

Finally know why the id with higher value runs first. Thank you!

houchenglin
Автор

Very Nice and informative Presentation for understanding Execution plan easily.

mrkamranumer
Автор

Thanks for the nice video, are the slides available anywhere?

richardwang
Автор

I saw the video fully. Your explanations were so informative...   Thanks for posting

MuthuGanapathyNathan