MySQL & InnoDB Fundamentals and Configuration
summary
Compares MyISAM and InnoDB with concrete tuning: MyISAM uses table locks and OS file cache so use it only for noncritical read-mostly replicas; InnoDB is ACID with redo/undo, log_flush_trx_commit=1 limiting durable commits to ~200/sec on spinning disks unless battery-backed or SSD, and needs the buffer pool sized to about 80% of RAM for good performance. Warns about long-running transactions bloating undo space and indexes, recommends query_cache_size=0, file-per-table to reclaim disk, short integer primary keys, and modest sort buffers.
AI-written summary · about
chapters (6)
- 0:00MySQL & InnoDB intro
- 2:52MySQL storage engines
- 8:42MyISAM deep dive
- 14:45InnoDB and ACID
- 26:09Critical InnoDB config
- 35:30Q&A
