刘安

Results 17 comments of 刘安

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...

从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...