MySQL: Analysis, understanding, and optimization of queries

Michael Moussa (03.Feb.2017 at 16:00, 1 hr )
Talk at SunshinePHP 2017 (English - US)

Rating: 5 of 5

Your new database query ran quickly when you tested it, but seconds after deploying it, alarms are blaring and you’re scrambling to rollback before the site goes down. What happened?!?

I can “EXPLAIN”.

Queries that perform well under development load with limited datasets can easily bring a database to its knees under production load. In this talk, you will learn to decipher MySQL query execution plans, recognize portions that can be improved, and take the necessary steps to optimize your queries - all without starting any fires!

Who are you?

Claim talk

Talk claims have been moved to the new site.

Please login to the new site to claim your talk

Comments closed.


Rating: 5 of 5

03.Feb.2017 at 16:50 by Rodolfo Puig (33 comments) via Web2 LIVE

Great thorough and technical talk. I always walk away with something new on each of your talks. Keep up the great work!

Rating: 5 of 5

03.Feb.2017 at 16:52 by Colin O'Dell (122 comments) via Web2 LIVE

Even though I thought I knew a good deal on optimizing queries, I still learned some great pointers from Michael's talk. He did a great job grounding the more-advanced technical details with real-world examples and recommendations.

Rating: 4 of 5

03.Feb.2017 at 17:09 by Kenneth Walter (14 comments) via Web2 LIVE

Very nice explanation of commonly overlooked MySQL tools.

Rating: 5 of 5

03.Feb.2017 at 17:18 by Constantin Bosneaga (6 comments) via Web2 LIVE

Impossible to cover such a broad topic in one talk, but author did it or very big part of it :) Worth hearing.

Rating: 5 of 5

04.Feb.2017 at 10:18 by Omar Gonzalez (5 comments) via Web2 LIVE

Great presentation. Glad to learn something I didn't know without having to go through the documentation.

Rating: 5 of 5

04.Feb.2017 at 10:44 by Kyle Leber (6 comments) via Web2 LIVE

Very thorough with your examples. Learned some great techniques that I will be applying in my every day development.

Rating: 5 of 5

04.Feb.2017 at 11:32 by Eric Morris (24 comments) via Web2 LIVE

I have been working in MySQL for years, and have picked up through experience on how to optimize many queries, but it has always be an instinctual process for me. I knew about the EXPLAIN command, but have never really used it. This talk was very focused and broke down exactly how to interpret the EXPLAIN output and some things to do with it. I will definitely be using this tool often in the future.

Rating: 5 of 5

04.Feb.2017 at 13:25 by Max Schwanekamp (95 comments) via Web2 LIVE

Thorough presentation, engaging speaker. Really great job!

Rating: 5 of 5

04.Feb.2017 at 14:39 by Joshua Sampia (28 comments) via Web2 LIVE

Very thorough. I loved the very concrete example and working through it in one hour.

Rating: 5 of 5

06.Feb.2017 at 12:16 by Symeon Quimby (18 comments) via Web2 LIVE

Loved the examples. Love that you share the same angst for the naming conventions mysql chose for EXPLAINs output that I do. You helped me wrap my head around a few parts I always found confusing due to that very issue.

Rating: 5 of 5

07.Feb.2017 at 13:10 by Lawrence Shea (34 comments) via Web2 LIVE

Very well done and informative!

Rating: 4 of 5

07.Feb.2017 at 13:39 by David W. (14 comments) via Web2 LIVE

A little over my head but only because I do not have that much experience with MySQL specifically. Great explanation though.

Rating: 5 of 5

09.Feb.2017 at 14:52 by Justin Oakley (3 comments) via Web2 LIVE

This was a good explanation of the meanings of the different values returned when doing an explain on the execution plan. The speaker was able to cover all of these areas within the hour and had good examples.

Rating: 4 of 5

09.Feb.2017 at 15:31 by Steve Meyers (46 comments) via Web2 LIVE

Well done. It was a little bit too much in the weeds, without always really explaining why certain queries would be better, but I liked the process of showing people how to use EXPLAIN to make better queries.

© 2019