为提高效率,请提供以下信息,问题描述清晰能够更快得到解决:
【TiDB 版本】v4.0.7
【问题描述】通过TiCDC将TiDB的数据复制到MySQL的过程中,发现无索引的表不能被复制。参数如下:
Starting component ctl
: /root/.tiup/components/ctl/v5.0.0-rc/ctl cdc changefeed query --pd=http://10.60.79.168:2379 --changefeed-id=sync-test-repl-task
{
“info”: {
“sink-uri”: “mysql://sync_data:test1234@rds-test.ct7cj9f0ldac.us-east-1.rds.amazonaws.com:3306/?max-txn-row=500\u0026time-zone=”,
“opts”: {
“_changefeed_id”: “cli-verify”
},
“create-time”: “2021-02-19T14:19:26.154014888+08:00”,
“start-ts”: 423025791230541831,
“target-ts”: 0,
“admin-job-type”: 0,
“sort-engine”: “memory”,
“sort-dir”: “.”,
“config”: {
“case-sensitive”: false,
“enable-old-value”: true,
“force-replicate”: true,
“check-gc-safe-point”: true,
“filter”: {
“rules”: [
“sync_test.*”
],
“ignore-txn-start-ts”: null,
“ddl-allow-list”: null
},
“mounter”: {
“worker-num”: 16
},
“sink”: {
“dispatchers”: null,
“protocol”: “default”
},
“cyclic-replication”: {
“enable”: false,
“replica-id”: 1,
“filter-replica-ids”: [
2,
3
],
“id-buckets”: 0,
“sync-ddl”: true
},
“scheduler”: {
“type”: “table-number”,
“polling-time”: -1
}
},
“state”: “normal”,
“history”: null,
“error”: null,
“sync-point-enabled”: false,
“sync-point-interval”: 600000000000
},
“status”: {
“resolved-ts”: 423025874303975425,
“checkpoint-ts”: 423025874251546625,
“admin-job-type”: 0
},
“count”: 0,
“task-status”: [
{
“capture-id”: “d4b8da56-f56f-485e-9949-10aab228cb16”,
“status”: {
“tables”: {
“47”: {
“start-ts”: 423025791230541831,
“mark-table-id”: 0
},
“71”: {
“start-ts”: 423025867645517835,
“mark-table-id”: 0
}
},
“operation”: null,
“admin-job-type”: 0
}
}
]
}
要同步的表结构如下:
CREATE TABLE test_no_index
(
id
int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
请帮忙看下原因,多谢。
若提问为性能优化、故障排查类问题,请下载脚本运行。终端输出的打印结果,请务必全选并复制粘贴上传。