Understanding MySQL Concepts
summary
MySQL 8.0 moves system tables to InnoDB and removes long‑standing MyISAM defaults, with concrete notes about file‑per‑table and a 64 TB per‑table InnoDB ceiling. Memory behavior is concrete: InnoDB buffer_pool default 128MB; raise it on servers with >256MB. Replication specifics include binary log formats, GTID formats differ (MySQL: server UUID+seq, MariaDB: domain/server/seq) and advice to enable binlogs and keep them for point‑in‑time recovery. Storage engines include MyRocks with ~50% space savings on write‑heavy workloads.
AI-written summary · about
chapters (14)
- 0:00Start
- 1:22Table Exporting
- 4:26Buffer Pool
- 4:59Best Practices for Indb
- 6:42Other Storage Engines
- 9:18Mysql Does Not Support Pl Sql
- 10:15Replication
- 10:51Advantages of Replication
- 12:25Binary Logs
- 13:11Formats of Binary Logs
- 13:47Mixed Replication
- 22:17Replication Is Asynchronous
- 23:10Replication Lag
- 25:01Idb Group Replication
