Optimizing MySQL Queries with EXPLAIN

Comments

Comments are closed.

Audio was a little garbled on my end.

Anonymous at 07:08 on 10 Apr 2015

Excellent talk! Very detailed walk-through and examples. I'll definitely be referring back to this later when I'm optimizing these queries.

Audio did fade in and out a bit, understandable since he was on his phone.

Very good. I learned a lot. Mostly that I need to upgrade my MySQL version.

Morgan did great explaining the whole thing. His voice wasn't very strong and seemed to crackle a bit, but that might have been the phone. There were a few uhms and ahs, but overall, really good.

Great talk!

I understand Morgan is from Oracle, but I would like to have some hints it this is MySQL only or MariaDB also...

Thank you!

Good information for optimizing queries with MySQL. I felt the talk was too heavily focused on indexing, and I was hoping to hear more about temp table creation and file sort results from EXPLAIN. Overall a great overview on how to tackle query optimization.

Very index-heavy talk without getting too technical into how indices work. Might have liked to see more background into what explain is telling us, with temp tables or file sorts.

Excellent talk, great information on optimizing queries.

Really amazing details about how MySQL works to attempt to optimize queries and how they can be analyzed and tweaked. It was helpful to have a metric (cost units?) to measure what a specific query will "cost". That helped provide a nice way to determine by how much a query is improved, even though a time measurement is a little more intuitive. The example data sets were awesome to look at and see how he worked with them.

Excellent talk! Very detailed examples.

Excellent talk. Very dense. I will have to revisit the talk one or two more times to understand it fully.

Great decomposition of a hard-to-understand problem. I've seen the slides before, but hearing Morgan speak helped increase my understanding a lot. Very clear and well-thought out with great examples.