~/talk

Performance oriented InnoDB log format changes

Talkat FOSDEM 2022 · on Saturday, 2022-02-05· at 12:00· D.mariadb· [databases]

speaker

name:Marko Mäkelä

links:none on file

resources

video:https://video.fosdem.org/2022/D.mariadb/mariadb_innodb.mp4

slides:https://fosdem.org/2022/schedule/event/mariadb_innodb/attachments/slides/5140/export/events/attachments/mariadb_innodb/slides/5140/Performance_oriented_InnoDB_log_format_changes.pdf

summary

Describes changes to the InnoDB redo log file format in MariaDB Server to reduce write amplification and improve parsing across diverse storage block sizes (64–4096 bytes). Proposes treating each mini-transaction as its own block with a per-mini-transaction CRC-32C computed in a local buffer (reducing global log-buffer mutex contention), replacing the 12-byte header with a 1-bit sequence number, and optionally padding with no-op records to align to physical blocks; also covers how encryption is applied (data-only, with an 8‑byte IV per mini-transaction) and explicit cleartext record lengths to allow consistent hot backups.

AI-written summary · about

related talks