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

Mysql Commit Timestamp

    XMLWordPrintable

Details

    • False
    • None
    • False

    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

        Issue Links

          Activity

            People

              Unassigned Unassigned
              jingtaozhang18 jingtao zhang (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              7 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: