mysql中Binlog3种格式，STATMENT,ROW,MIXED有什么区别 | Dami

0 0

mysql中Binlog3种格式，STATMENT,ROW,MIXED有什么区别

应用场景是什么，为什么会有三种格式？

mysql_replication mysql mysql优化

9 years, 9 months ago

史前大龙虾

share

史前大龙虾 9 years, 9 months ago

0

通俗的说

statement 记录发生写操作的查询

Row 记录写操作发生后改变的行

Mixed 根据情况两者皆有

具体看这里的说明 https://dev.mysql.com/doc/refman/5.6/en/binary-log-setting.html

answered 9 years, 9 months ago

listz

share

listz answered 9 years, 9 months ago

Your Answer