Optimizing MySQL Queries with EXPLAIN

Morgan Tocker

Wednesday 29 October 2014 from 16:00 to 17:00

Talk in English - US at ZendCon 2014
Track Name: Room 204
Short URL: https://joind.in/talk/8c1b7 (QR-Code (opens in new window))

Avg. Rating

Optimizing MySQL Queries with EXPLAIN

Comments

Comments are closed.

David Weinraub at 16:54 on 29 Oct 2014

Wow, MySQL db index choices are sooo much more subtle than I ever realized. :D

A great talk that was very clear, informative, and authoritative. Thanks!

Anonymous at 17:01 on 29 Oct 2014

Great talk, good presentation and answered everyone's questions with ease!

Ollie Brennan at 17:05 on 29 Oct 2014

Morgan used some really good examples to demonstrate how to add indexes to tables and how the MySQL optimiser works internally.

Good explanations on how 5.4-5.6 introduced pretty neat features to help optimise queries along with somethings that maybe coming in 5.7.

Possibly one of the best talks so far at zendcon