75

解析MySQL binlog --（5）ROWS_EVENT-yanzongshuai的专栏

 6 years ago
source link: http://blog.51cto.com/yanzongshuai/2090894
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
1、介绍对于statement格式的binlog，所有增删改的SQL语句都记录在QUERY_EVENT中，而row格式的binlog则以ROWS_EVENT格式记录对数据库的修改。ROWS_EVENT分为3种：WRITE_ROWS_EVENT、UPDATE_ROWS_EVENT、DELETE_ROWS_EVENT，分别对应insert、update、delete。WRITE_ROWS_EVENT包

report

Recommend

About Joyk


Aggregate valuable and interesting links.
Joyk means Joy of geeK