How to Parse Binlog to Know the Executed SQL in the Past

Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: 如何解析binlog,知道过去执行的sql

| username: TiDBer_yUoxD0vR

[TiDB Usage Environment] Production Environment / Testing / PoC
[TiDB Version]
[Reproduction Path] What operations were performed that led to the issue
[Encountered Issue: Problem Phenomenon and Impact]

How to parse binlog files or use other methods to know what SQL was executed at a certain time, similar to MySQL.

[Resource Configuration]
[Attachments: Screenshots/Logs/Monitoring]

| username: buddyyuan | Original post link

| username: xingzhenxiang | Original post link

Reparo can generate binlog files in a way similar to mysqlbinlog -read-from-remote-server.

| username: 胡杨树旁 | Original post link

Reparo can parse binlog logs.

| username: liuis | Original post link

https://docs.pingcap.com/tidb/stable/tidb-binlog-reparo

| username: system | Original post link

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.