Tag: MVCC
2 posts
-
MySQL Complete Guide | InnoDB Internals, MVCC, Optimizer, Replication & Production Patterns
Deep MySQL guide: InnoDB buffer pool and WAL, MVCC and isolation, cost-based optimizer, binlog replication, plus indexing, partitioning, and production operations.
-
PostgreSQL Complete Guide | MVCC, VACUUM, Planner, B-tree/GiST/GIN & Production Patterns
PostgreSQL internals: MVCC snapshots, VACUUM/autovacuum, cost-based planner & stats, B-tree vs GiST vs GIN—plus partitioning, replication, backups, and production ops.