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’ll cover 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.
- How B-Tree indexes are built?
- Indexes - MyISAM vs. InnoDB
- Different index types
- Indexing gotchas
- EXPLAIN walkthrough - query execution plan
Krzysztof Książek, Senior Support Engineer at Severalnines, is a MySQL DBA with experience managing complex database environments for companies like Zendesk, Chegg, Pinterest and Flipboard.