ITPub博客

首页 > Linux操作系统 > Linux操作系统 > Mysql Binary Log (3)

Mysql Binary Log (3)

原创 Linux操作系统 作者:aaqwsh 时间:2013-03-05 17:20:11 0 删除 编辑

 Binlog file structure

 

 

All events have a common general structure consisting of an event header followed by event data:

+===================+

| event header |

+===================+

| event data |

+===================+

 

 

 

header length = x bytes

data length = (event_length - x) bytes

fixed data length = y bytes variable data length = (event_length - (x + y)) bytes

x is given by the header_length field in the format description event (FDE). Currently, x is 19, so the extra_headers field is empty.

y is specific to the event type, and is given by the FDE. The fixed-part length is the same for all events of a given type, but may vary for different event types.

The fixed part of the event data is sometimes referred to as the "post-header" part. The variable part is  sometimes referred to as the "payload" or "body."

structure1.jpg

structure2.jpg

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/758322/viewspace-755329/,如需转载,请注明出处,否则将追究法律责任。

上一篇: Mysql Binary Log (2)
下一篇: linux io tools
请登录后发表评论 登录
全部评论

注册时间:2010-11-24

  • 博文量
    132
  • 访问量
    261962