Backups and Point-in-Time Recovery
Lessons in this course
- 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