dm过程执行sql的开始时间、执行sql、结束时间

🪐 TiDB 技术问题 备份&数据迁移
22

“flushed checkpoint” 大概每30秒会进行一次
“query-status test_tidb” 中syncerBinlog大概也是30秒刷新一次。
这个只是监控信息？不影响性能吧

query-status test_tidb
{
    "result": true,
    "msg": "",
    "workers": [
        {
            "result": true,
            "worker": "192.168.10.101:8265",
            "msg": "",
            "subTaskStatus": [
                {
                    "name": "test_tidb",
                    "stage": "Running",
                    "unit": "Sync",
                    "result": null,
                    "unresolvedDDLLockID": "",
                    "sync": {
                        "totalEvents": "487847",
                        "totalTps": "4065",
                        "recentTps": "0",
                        "masterBinlog": "(db1m-bin.000047, 150116802)",
                        "masterBinlogGtid": "",
                        "syncerBinlog": "(db1m-bin|000001.000047, 150114359)",
                        "syncerBinlogGtid": "",
                        "blockingDDLs": [
                        ],
                        "unresolvedGroups": [
                        ],
                        "synced": false
                    }
                }
            ],


0078337)(flushed (db1m-bin|000001.000047, 148967163))"]
[2020/04/21 11:15:52.174 +08:00] [INFO] [syncer.go:809] ["flushed checkpoint"] [task=test_tidb] [unit="binlog replication"] [checkpoint="(db1m-bin|000001.000047, 150078337)(flushed (db1m-bin|000001.000047, 150078337))"]
[2020/04/21 11:15:52.174 +08:00] [INFO] [relay.go:113] ["current earliest active relay log"] [task=test_tidb] [unit="binlog replication"] ["active relay log"=07777bc0-9dd1-11e7-9d49-000c29652500.000001/db1m-bin.000047]
[2020/04/21 11:16:13.731 +08:00] [INFO] [relay.go:503] ["flush meta finished"] [component="relay log"] [meta="master-uuid = 07777bc0-9dd1-11e7-9d49-000c29652500.000001, relay-binlog = (db1m-bin.000047, 150087023), relay-binlog-gtid = 00000000-0000-0000-0000-000000000000:0"]
[2020/04/21 11:16:19.600 +08:00] [INFO] [syncer.go:1931] ["binlog replication progress"] [task=test_tidb] [unit="binlog replication"] ["total binlog size"=32702749] ["last binlog size"=32686390] ["cost time"=30] [bytes/Second=545] ["unsynced binlog size"=0] ["estimate time to catch up"=0]
[2020/04/21 11:16:19.600 +08:00] [INFO] [syncer.go:1956] ["binlog replication status"] [task=test_tidb] [unit="binlog replication"] [total_events=487823] [total_tps=8130] [tps=0] [master_position="(db1m-bin.000047, 150092554)"] [master_gtid=] [checkpoint="(db1m-bin|000001.000047, 150092554)(flushed (db1m-bin|000001.000047, 150078337))"]
[2020/04/21 11:16:22.379 +08:00] [INFO] [syncer.go:809] ["flushed checkpoint"] [task=test_tidb] [unit="binlog replication"] [checkpoint="(db1m-bin|000001.000047, 150092961)(flushed (db1m-bin|000001.000047, 150092961))"]
23

你好，

符合预期的

有新的问题清开新帖提问~

感谢

1 个赞