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

Exclude TRUNCATE and REPLACE statements from schema history

XMLWordPrintable

    • False
    • None
    • False

      What ?

      Add TRUNCATE and REPLACE keywords here.

      Context

      TRUNCATE is written in binlog as `Query` event type. Also commands like `REPLACE INTO` are written in binlog as `Query` event type in certain offerings of mysql such as percona.

      Since `tableChanges` in a schema history record is populated only for create, alter or drop operations, the other operations if written in schema history, have to rely on DDL parser during the recovery phase, which is very slow in comparison to just deserializing `tableChanges`.

              Unassigned Unassigned
              akanimesh7 Animesh Kumar
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Created:
                Updated:
                Resolved: