Uploaded image for project: 'Debezium'
  1. Debezium
  2. DBZ-5170

Mysql Commit Timestamp

    XMLWordPrintable

Details

    Description

      What Debezium connector do you use and what version?

      Debezium connector for MySQL. Version 1.8

      What is the connector configuration?

      an initial change events with provide.transaction.metadata = true

      What is the captured database version and mode of depoyment?

      MySQL version 5.7

      Feature request or enhancement

      I want to get the timestamp of the transaction commit time in change events or boundaries events. Better in both. But actually, the Change events only inlcude the timestamp when the statement start executing, and Boundaries events include no timestamp infomation. As we all known, the changes can be seen by other transactions after this transaction is commited(for READ COMMITTED and REPEATED READ isolation level), so I think the transaction commit time is very Important.

      Implementation ideas (optional)

      Analyze the binlog XID EVENT to get the timestamp of transaction commit time. (I am not very familer with binlog, just a little understand).

      Attachments

        Activity

          People

            Unassigned Unassigned
            jingtaozhang18 jingtao zhang
            Votes:
            0 Vote for this issue
            Watchers:
            6 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: