Overview
Dive into a comprehensive exploration of MySQL and InnoDB performance optimization in this 34-minute conference talk from SREcon21. Gain valuable insights into storage engines, performance tuning, and index design. Learn how to effectively use clustered indexes and primary keys, improve access types, and overcome index limitations. Discover the intricacies of covering indexes and understand the query parser's role in optimization. Walk away with practical knowledge to enhance your database performance and confidently tackle SQL-related challenges.
Syllabus
Introduction
Agenda
Storage Engines
Performance
Indexes
Clustered Indexes
Primary Keys
Improving Access Types
Designing Indexes
Index Limitations
Covering Indexes
Query Parser
Post Processing
Taught by
USENIX