Talk in English - US at SunshinePHP 2017
Track Name:
Key Biscayne 2
View Slides: https://github.com/michaelmoussa/talks/tree/master/mysql-query-optimization/ssp2017
Short URL: https://joind.in/talk/aad28
(QR-Code (opens in new window))
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!
Comments
Comments are closed.
Great thorough and technical talk. I always walk away with something new on each of your talks. Keep up the great work!
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.
Very nice explanation of commonly overlooked MySQL tools.
Impossible to cover such a broad topic in one talk, but author did it or very big part of it :) Worth hearing.
Great presentation. Glad to learn something I didn't know without having to go through the documentation.
Very thorough with your examples. Learned some great techniques that I will be applying in my every day development.
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.
Thorough presentation, engaging speaker. Really great job!
Very thorough. I loved the very concrete example and working through it in one hour.
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.
Very well done and informative!
A little over my head but only because I do not have that much experience with MySQL specifically. Great explanation though.
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.
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.