Webinar replay: MySQL Query Tuning Trilogy: Indexing and EXPLAIN - deep dive
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
SPEAKER
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.
Смотрите видео Webinar replay: MySQL Query Tuning Trilogy: Indexing and EXPLAIN - deep dive онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Severalnines 28 Сентябрь 2016, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 794 раз и оно понравилось 1 людям.