MySQL: Analysis, understanding, and optimization of queries

Michael Moussa (21.Apr.2017 at 14:00, 50 min)
Talk at Lone Star PHP 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 query execution plans, recognize portions that can be improved, and take the necessary steps to optimize your queries!

Who are you?

Claim talk

Talk claims have been moved to the new Joind.in site.

Please login to the new site to claim your talk

 
Comments closed.

Comments

Rating: 5 of 5

21.Apr.2017 at 14:45 by Josh Butts (52 comments) via Web2 LIVE

I didn't expect to learn anything from this talk, as I was just sitting in the back catching up on work. I picked up 2 things I didn't know, and this explanation of how to use the explain plan for MySQL is probably the most accessible, easy to understand I've seen.

Rating: 5 of 5

21.Apr.2017 at 14:46 by Mark Niebergall (120 comments) via Web2 LIVE

Great examples of SQL and scenarios that I could relate to. Pace was good, Michael spoke clearly, and the slides were readable even though they included queries and output. Great presentation that covered basic query optimizations.

Rating: 5 of 5

21.Apr.2017 at 15:02 by Brent Wiethoff (5 comments) via Web2 LIVE

Great content! Would love to have gotten another hour in this talk. :)

Rating: 5 of 5

25.Apr.2017 at 09:23 by Bob Phillips (33 comments) via Web2 LIVE

Thank you for explaining the misnomers in EXPLAIN.

© Joind.in 2019