MySQL Query Tuning Trilogy: Indexing and EXPLAIN - deep dive

Presented by Krzysztof Ksiazek
Webinar Replay
Webinar Slides
Please Sign In to View Content
To view the webinar replay video or slides, "MySQL Query Tuning Trilogy: Indexing and EXPLAIN - deep dive", you must be signed in using your Severalnines.com account. If you don't already have an account you can create one in just a couple minutes. Just click on the "Login to View" button below.

This is part 2 of our webinar trilogy on MySQL Query Tuning, in which we look 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 2: Indexing and EXPLAIN - deep dive.

Agenda

  • How B-Tree indexes are built?
  • Indexes - MyISAM vs. InnoDB
  • Different index types
    • B-Tree
    • Fulltext
    • Hash
  • Indexing gotchas
  • EXPLAIN walkthrough - query execution plan

Presenter

Krzysztof Ksiazek

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.

Comments & questions

Have any questions? Please, contact us.