MySQL Query Tuning Trilogy: Working with optimizer and SQL tuning
This is the final part of our webinar trilogy on MySQL Query Tuning, in which we looked at query tuning process and tools to help with that. We’ve covered topics such as SQL tuning, indexing, the optimizer and how to leverage EXPLAIN to gain insight into execution plans. Part 3: Working with the optimizer and SQL tuning.
Agenda
- Optimizer
- How execution plans are calculated
- InnoDB statistics
- Hinting the optimizer
- Index hints
- JOIN order modifications
- Tweakable optimizations
- Optimizing SQL
Presenter
Krzysztof Książek, Director of Support at Severalnines. For nearly 15 years Krzysztof has held positions as a SysAdmin & DBA designing, deploying, and driving the performance of MySQL-based databases. In his role at Severalnines Krzysztof and his team are responsible for delivering 24/7 support for our clients mission-critical applications across a variety of database technologies as well as creating technical content, consulting and training. His spare time is spent with his wife and child as well as the occasional hiking and ski trip.
ClusterControl
The only management system you’ll ever need to take control of your open source database infrastructure.
Sign up for Planets9s
