MySQL 知识要点 #170
AlexStocks
started this conversation in
General
MySQL 知识要点
#170
Replies: 0 comments
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
Binlog
如上图，如果 binlog 格式是 statement，MySQL 针对 “delete from t /comment/ where a>=4 and t_modified<='2018-11-10' limit 1;” 这一条 SQL 语句，在 binlog 中加了很多扩充，补齐了上下文。
如果 binlog 格式是 row 格式，则 master binlog 中记录的是删除的结果。
针对时间 now() 函数的特殊处理：
双主复制
Beta Was this translation helpful? Give feedback.
All reactions