书生笔记-binlog_row_image参数解析

最新推荐文章于 2022-07-10 10:37:21 发布

VIP文章魏书生的技术空间

最新推荐文章于 2022-07-10 10:37:21 发布

阅读量389

点赞数 2

分类专栏： MySQL 文章标签：数据库 mysql

本文链接：https://blog.csdn.net/weihaodong0557/article/details/109642672

版权

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

优惠劵

关注关注