Shulou(Shulou.com)06/01 Report--

This format describes events introduced in binlog version 4 to replace previous versions of START_EVENT_3 events. Is the first event in a binlog file and appears only once in a binlog file. Specific definition:

Binlog-version:binlog version

Mysql-server version: server version

Create timestamp: indicates when the binlog file was created. If the binlog is due to a handover, then the field is 0

Event header length:189

Event type header lengths: the length of private event headers that record all events. The number of event is defined as 5.6. 5.7 is 40, that is, 40 bytes.

[mysql26@localhost data] $hexdump-Cv mysql-bin.000002 > 2.txt [mysql26@localhost data] $vi 2.txt 00000000 fe 62 69 6e 46 c4 a4 5a 0f 0b 000000 74 0000 | .binF.. Z.t.. | 00000010 00 78 000000 01 00 04 00 35 2e 36 2e 32 36 2d | .x5.6.26-| 00000020 64 65 62 75 2d 6c 6f 6700000000000 | debug-log... | | 00000030 000000 000000 000000 00000000 |. | 00000040000000000000000000 46 c4 a4 5a 13 | .F.Z. | 00000050 38 0d 00 08 00 12 0004 04 12 0000 5c 00 | 8.\. | 00000060041a 08 000000 08 08 02 000000 0a 0a 0a |. | 00000070 19 00 01 C1 A1 c5 19 62 c4 a4 5a 02 0b 0000 | .b.Z. | 00000080 00 47 000000 bf 000000 08 00 01 000000 00 | .000090000 0000 0000 0000 1a 0000000000000 0000 |. | | 000000a0 00 40 000000 00 06 03 73 74 64 04 21 00 21 00 |. @ .std.!. | 000000b0 21 00 79 7a 73 00 42 45 47 49 4e 30 85 8c ba 62 |! .yzs.BEGIN0. B | 000000c0 c4 a4 5a 13 0b 000000 2d 000000 ec 000000 | Z. -. | 000000d0 0000 46000000 0000 01 00 03 79 7a 73 00 | 02 |.. F.yzs.. |

Analysis:

1. The first 4 bytes of binlog magic number:fe 62 69 6e, or .bin

2. The first binlog event is FORMAT_DESCRIPTION_EVENT.

3. Timestamp: 46 c4 a4 5a, that is, small end display 0x5aa4c446, decimal 1520747590

[mysql26@localhost data] $date-d "@ 1520747590"

Sat Mar 10 21:53:10 PST 2018

The time for binlog parsing is: # 180310 21:53:10 server id 11 end_log_pos 120 CRC32 0x19c5a1c8 Start: binlog v 4, server v 5.6.26-debug-log created 180310 21:53:10 at startup

3. Event type:0f, i.e. 15

5. Server-id:0b 000000, that is, the small end shows 0x00 0000b, that is, 11

6 、 event size:74 00 00 00:0x 00 00 00 74116 . 120-4 (.bin)

7. Next-log pos:78 00 00 00:0x00 00 78 00:0x00 120, the location of the next event, relative to the file header, is the same as end_log_pos 120

8. Flag:01 00; for 0X0001, it will report a warning in the MYSQLBINLOG output that this binlog is not closed

9. Binlog version:04 00, small end display and 0X0004, which is consistent with the parsed Start: binlog v 4 in mysqlbinlog

10. Mysql server version:5.6.26-debug-log, the remaining bytes are filled with 0

00000010 35 2e 36 2e 32 36 2d | .x.5.6.26-| 00000020 64 65 62 75 67 2d 6c 6f 67 000000 000000 00 | debug-log. | 00000030000000000000000000000000. | 00000040000000000000000 0000

11. Create stamp:46 c4 a4 5a, same as event head

12. Event header length:13, that is, 19 bytes

13. Event header lengths:array [30]-[32]: 0a 0a 0a, indicating the length of private event headers of WRITE_ROWS_EVENT = 30 updated ROWSign event = 31, DELETE_ROWS_EVENT = 32

00000050 38 0d 00 08 00 00 12 04 04 12 0000 5c 00 | 8.\. | 00000060 04 1a 08 000000 08 08 02 000000 0a 0a 0a |. | 00000070 19 00 01 c8 A1 c5 19

Reference: http://blog.itpub.net/7728585/viewspace-2133189/

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.