Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

能解释一下这些字段是什么意思吗 #2170

Closed
Bruce2jiang opened this issue Sep 9, 2019 · 3 comments
Closed

能解释一下这些字段是什么意思吗 #2170

Bruce2jiang opened this issue Sep 9, 2019 · 3 comments

Comments

@Bruce2jiang
Copy link

{"data":[{"id":"103","name_":"77","orders":"88","deml":"99"}],"database":"canal","es":1567995973000,"id":421,"isDdl":false,"mysqlType":{"id":"bigint(14)","name_":"varchar(255)","orders":"varchar(255)","deml":"varchar(255)"},"old":null,"pkNames":["id"],"sql":"","sqlType":{"id":-5,"name_":12,"orders":12,"deml":12},"table":"examplev1","ts":1567995973598,"type":"INSERT"}

@Bruce2jiang
Copy link
Author

其中 id sqltype是什么意思,其他我都知道了

@D-YuLin
Copy link

D-YuLin commented Oct 9, 2019

可以理解为es 是canalserver dumpBinlog的执行时间和ts 是mysql数据dml的时间戳么

@agapple
Copy link
Member

agapple commented Oct 11, 2019

  1. es是指mysql binlog里原始的时间戳,也就是数据原始变更的时间
  2. ts是指canal收到这个binlog,构造为自己协议对象的时间

a. canal的消费延迟 = ts - es
b. 应用消费的延迟 = now - ts

@agapple agapple closed this as completed Oct 11, 2019
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

3 participants