刘安
刘安
src /debug/pprof/goroutine?debug=1 ``` goroutine profile: total 100 8 @ 0x43d0c5 0x40854f 0x4081cb 0x1477dbd 0x13f6456 0xbd1658 0xbd2d28 0xbe0deb 0x474801 # 0x1477dbc github.com/hashicorp/nomad/plugins/drivers.(*driverPluginServer).TaskStats+0x19c /universe/src/github.com/actiontech/dtle/vendor/github.com/hashicorp/nomad/plugins/drivers/server.go:251 # 0x13f6455 github.com/hashicorp/nomad/plugins/drivers/proto._Driver_TaskStats_Handler+0x115 /universe/src/github.com/actiontech/dtle/vendor/github.com/hashicorp/nomad/plugins/drivers/proto/driver.pb.go:4509 # 0xbd1657 google.golang.org/grpc.(*Server).processStreamingRPC+0xcd7 /universe/src/github.com/actiontech/dtle/vendor/google.golang.org/grpc/server.go:1329...
dest /debug/pprof/goroutine?debug=1 ``` goroutine profile: total 171 32 @ 0x43d0c5 0x44e2d7 0x1881ca5 0x474801 # 0x1881ca4 github.com/go-sql-driver/mysql.(*mysqlConn).startWatcher.func1+0xa4 /universe/src/github.com/actiontech/dtle/vendor/github.com/go-sql-driver/mysql/connection.go:614 32 @ 0x43d0c5 0x44e2d7 0x264bf87 0x474801 # 0x264bf86 github.com/actiontech/dtle/drivers/mysql/mysql.(*ApplierIncr).MtsWorker+0x1e6 /universe/src/github.com/actiontech/dtle/drivers/mysql/mysql/applier_incr.go:187 15 @ 0x43d0c5...
update DDL support docs https://actiontech.github.io/dtle-docs-cn/3/3.6_DDL.html
/debug/pprof/goroutine?debug=1 ``` goroutine profile: total 64 8 @ 0x43d0c5 0x470a18 0x4709ee 0x48c839 0x179a5d6 0x474801 # 0x4709ed sync.runtime_notifyListWait+0xcd /opt/go/src/runtime/sema.go:513 # 0x48c838 sync.(*Cond).Wait+0x98 /opt/go/src/sync/cond.go:56 # 0x179a5d5 github.com/nats-io/nats%2ego.(*Conn).waitForMsgs+0x635 /universe/src/github.com/actiontech/dtle/vendor/github.com/nats-io/nats.go/nats.go:2626 4 @ 0x43d0c5 0x40854f...
fixed file is empty.
从binlog中可以获取server id信息
从binlog中可以获取thread信息
测试: 1. 将每个服务器设置为不同的时区: src dtle ```shell timedatectl set-timezone UTC ``` dest dest ```shell timedatectl set-timezone Europe/London ``` src mysql ```shell timedatectl set-timezone Europe/Monaco ``` dest mysql ```shell timedatectl set-timezone America/Los_Angeles...
读取TIMESTAMP使用默认使用MySQL server的时区 https://dev.mysql.com/doc/refman/5.7/en/datetime.html > MySQL converts TIMESTAMP values from the current time zone to UTC for storage, and back from UTC to the current time zone for retrieval. (This does...
can you provide MySQL general log?