lonestar2017

Lone Star PHP 2017 - MySQL: Analysis, understanding, and optimization of queries

Slides and reference materials for my MySQL: Analysis, understanding, and optimization of queries talk at Lone Star PHP 2017.

Instructions

1. Download MySQL
2. Download and Install the Sakila Sample Database
3. Try some of the queries you find in the slide deck or the Usage Examples
4. EXPLAIN all the things!

Links

• Slides: Lone Star PHP 2017: MySQL Query Optimization
• joind.in: https://joind.in/talk/f06be

Problems?

Tweet at me or open an issue. I really, truly want to help, and it's not a bother at all.