-
Enhancement
-
Resolution: Unresolved
-
Critical
-
None
-
False
-
False
-
Undefined
-
Table size 65 GB
Table records 106 million and affected rows number by SQL below is 53 million
update table_name set available_at = "0001-01-01 00:00:00" where available_at = "0000-00-00 00:00:00";
There are other tables in the same database, but they do not run such bulk update.
The running connector encounter huge latency and keep accumulating in the six hours after DML above get triggered. We do see 6 hours latency for jmx avg:jmx.debezium.binlog.millisecondsbehindsourceĀ