This course aims to help participants improve their understanding of MySQL and InnoDB performance. By the end of the course, learners will be able to optimize storage engines, enhance query performance through indexes, and design efficient indexes. The teaching method involves a combination of theoretical explanations and practical examples. This course is intended for individuals who are interested in enhancing their MySQL performance skills, particularly those who struggle with understanding storage engines, query optimization, and index design.
Overview
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
