Learn Python with Generative AI - Self Paced Online
Finance Certifications Goldman Sachs & Amazon Teams Trust
Overview
Google, IBM & Meta Certificates — All 10,000+ Courses at 40% Off
One annual plan covers every course and certificate on Coursera. 40% off for a limited time.
Get Full Access
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