书生笔记-binlog_row_image参数解析

1，参数定义

 

• For MySQL row-based replication, this variable determines how row images are written to the binary log.

对于基于row模式的复制，binlog_row_image变量决定了images是如何写入到binlog日志文件的。

• In MySQL row-based replication, each row change event contains two images, a “before” image whose columns are matched against when searching for the row to be updated, and an “after” image containing the changes. Normally, MySQL logs full rows (that is, all columns) for both the before and after images. However, it is not strictly necessary to include every column in both images, and we can often save disk, memory, and network usage by logging only those columns which are actually required.

在基于row模式的复制，每行的改变event包含了两个image：1，before, 将要被修改的行 2，after，改变后的行信息 。

正常情况下，full row是包含了before和after的信息。然后，这不是必须要求的，只在我们需要的时候使用。

• Note