Transactions from the inside: WAL, MVCC and the undo log
Replaying all four isolation levels on MySQL 8.4 and PostgreSQL 16, how a write travels through the redo log, InnoDB's MVCC (undo log, read view, purge, and history list length measured in numbers) versus PostgreSQL's (xmin/xmax, dead tuples, VACUUM).