How well do you know your MySQL Indexes?
summary
Shows concrete queries and EXPLAIN output that prove when a functional indexes actually speeds a lookup and when it does not, measures SELECT latency before and after adding a covering index coverage, demonstrates creating an invisible index and how the optimizer ignores or adopts it under controlled benchmarks, and reproduces the failure mode where a multi value indexes explodes index size and hurts writes so readers can see the tradeoffs and the exact commands used.
AI-written summary · about
related talks
42mThings every developer absolutely, positively needs to know about database indexing
36mFor performance, go to page 5: Indexes
46mSupercharge Your SQL with Indexes: a Practical Introduction
30mMySQL Indexes and Histograms to Speed Up Your Queries
35mMySQL Indexes and Histograms to Speed Up Your Queries
47mMySQL Indexing Best Practices
21mWriting High Performance SQL Statements
49mIt’s Not Always About the Index: The Hidden Secrets of Query Performance