Tagged articles

trx_cache

2 articles · Page 1 of 1

Mar 20, 2024 · Databases

How MySQL Writes Binlog Logs: Buffer Management and trx_cache Reading

This article explains MySQL 8.0.32's binlog log file structure, the 8 KB in‑memory buffer (IO_CACHE), how binlog entries are written from trx_cache to the binlog file, and the detailed steps and code involved in reading from memory or temporary files and flushing to disk.

BufferIO_CACHEMySQL

0 likes · 10 min read

How MySQL Writes Binlog Logs: Buffer Management and trx_cache Reading

Aikesheng Open Source Community

Feb 21, 2024 · Databases

Understanding MySQL Binlog Cache and Event Generation

This article explains how MySQL 8.0.32 InnoDB generates binlog events, the role of binlog cache (stmt_cache and trx_cache), the two‑level cache mechanism, and the detailed process of writing events to the cache and flushing them to disk.

InnoDBMySQLcache

0 likes · 8 min read

Understanding MySQL Binlog Cache and Event Generation