Talk in English - US at SunshinePHP 2017
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!