-
Enhancement
-
Resolution: Done
-
Major
-
None
-
False
-
-
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`.
- causes
-
DBZ-9162 Fix truncate present in history topic if it is a skipped operation
-
- Closed
-
- is related to
-
DBZ-4959 Improve performance of DB history recovery
-
- Open
-
- links to
-
RHEA-2025:154266
Red Hat build of Debezium 3.2.4 release