MySQL Mastery: Performance, Replication Basics & Administration
Diagnose a slow MySQL 8 database like a professional: read slow logs and EXPLAIN, size B-trees and indexes, reason about locks, MVCC, partitions, replication lag, backups and server memory, with every answer checked as you go.
- One-time payment
- Instant access right after payment
- Secure checkout with Stripe
About this course
MySQL Mastery is an advanced, hands-on course for developers and database administrators who need to make a slow MySQL 8 database fast and keep it healthy. Working on a fictional web shop, you turn slow query log entries into a digest, read EXPLAIN plans and key_len, calculate B+tree heights, index selectivity and the real cost of row lookups and deep OFFSET pagination. You then reason about filesorts, join order, partition pruning, the InnoDB buffer pool, next-key locks, MVCC isolation levels and deadlocks, model replication lag with GTIDs, plan a point-in-time recovery and size server memory. Every answer is checked instantly, and the first lesson is free.
Lessons
- The Slow Query Log: Find Where the Time GoesFree
- EXPLAIN: rows, filtered and the Real Work of a Join Locked
- Access Types: From const to ALL Locked
- How a B+Tree Index Finds a Row Locked
- Cardinality, Selectivity and Skew Locked
- Composite Indexes and key_len Locked
- The Leftmost-Prefix Rule in Practice Locked
- Covering Indexes and the Cost of Row Lookups Locked
- Primary Key Choice and Index Size Locked
- ORDER BY, LIMIT and Deep Pagination Locked
- Filesort, Temporary Tables and Sort Buffers Locked
- Join Order, Nested Loops and Hash Joins Locked
- Partitioning: Pruning and Its Limits Locked
- InnoDB Buffer Pool: Hit Ratio and Sizing Locked
- Row Locks, Gap Locks and Next-Key Locks Locked
- MVCC and Isolation Levels: Who Sees What Locked
- Lock Waits and Deadlocks Locked
- Replication Basics: Binlog, GTIDs and Lag Locked
- Backups and Point-in-Time Recovery Locked
- Server Memory and Connection Limits Locked
- Capstone: Triage a Slow Production Database Locked