Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

MySQL and InnoDB Performance for the Rest of Us

USENIX via YouTube

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!
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

Reviews

Start your review of MySQL and InnoDB Performance for the Rest of Us

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.