💾 Archived View for gemini.bortzmeyer.org › fosdem › event-11190.gmi captured on 2022-04-29 at 01:14:15. Gemini links have been rewritten to link to archived content

View Raw

More Information

⬅️ Previous capture (2021-12-17)

-=-=-=-=-=-=-

FOSDEM event "Buffer pool performance improvements"

Marko Mäkelä

Type devroom

How the LRU replacement and log checkpoints were made faster in MariaDB 10.5

Starts on day 1 (2021-02-06) at 17:30 (Brussels time, UTC+1) in room Mariadb (duration 00:30)

Matrix room #mariadb:fosdem.org

In any block-oriented, update-in-place database with log-based recovery, two kinds of page flushing are needed. Eviction flushing is necessary when all least recently used blocks are dirty (modifications exist in the buffer pool). Checkpoint flushing (writing out the oldest modified page first) allows the log checkpoint to advance, shortening the potential recovery time by logically discarding the start of the log. Any write of a persistent page must be preceded by a corresponding log write and optional doublewrite, to guarantee that crash recovery works.

We will cover some improvements in this area in MariaDB Server's version of InnoDB storage engine. We will also discuss how a database could be configured to minimize write amplification.

FOSDEM schedule page