binlogsum

A summarizer for decoded MySQL and MariaDB binary logs — turns mysqlbinlog output into per-table write statistics, GTID/transaction ranges, and writes-over-time histograms for diagnosing replication delay and unusual write activity.


About

binlogsum reads the decoded output of mysqlbinlog and reports on what actually happened in a given window of binary log activity: time range covered, server versions and per-server event counts, GTID and transaction ID ranges, a breakdown of query types, and which tables received the most writes and when. It distinguishes tables that were actually updated in a transaction from ones merely referenced, and surfaces the original SQL when binlog_rows_query_log_events is enabled — useful for tracing down the cause of a replication lag spike or an unexpected burst of writes.

It supports both ROW and STATEMENT binlog formats and can output a terminal report with Unicode histograms, an interactive web UI with zoomable graphs, or a self-contained HTML snapshot for sharing. Like the author’s other tools, it’s pure Go with no external dependencies, built as a single static binary.

Category Software & Tools
Subcategory Monitoring & Observability, Replication & High Availability
✎ Suggest an update

Community feedback

This space is for grounded, evaluable experience — versions used, environments, what you measured or observed, and how it behaves alongside other software. General impressions without supporting detail may be removed. Sign in to write one; posts are tied to a verified identity, not anonymous.