Documentation Home
MySQL Internals Manual


14.9.5 COM_BINLOG_DUMP

Requests a binlog network stream from the master starting a given position.

You can use SHOW BINARY LOGS to get the current logfile and position from the master.

The master responds either with a

If the binlog-filename is empty, the server will send the binlog-stream of the first known binlog.

COM_BINLOG_DUMP:

request a binlog-stream from the server

Payload
1              [12] COM_BINLOG_DUMP
4              binlog-pos
2              flags
4              server-id
string[EOF]    binlog-filename
Fields
  • binlog_pos (4) -- position in the binlog-file to start the stream with

  • flags (2) -- can right now has one value:

    Flag

    Description

    0x01

    BINLOG_DUMP_NON_BLOCK

    BINLOG_DUMP_NON_BLOCK

    if there is no more event to send send a EOF_Packet instead of blocking the connection

  • server_id (4) -- server id of this slave

  • binlog-filename (string.EOF) -- filename of the binlog on the master


User Comments
User comments in this section are, as the name implies, provided by MySQL users. The MySQL documentation team is not responsible for, nor do they endorse, any of the information provided here.
Sign Up Login You must be logged in to post a comment.