220.127.116.11 SHOW BINLOG EVENTS Statement
SHOW BINLOG EVENTS [IN 'log_name'] [FROM pos] [LIMIT [offset,] row_count]
SHOW BINLOG EVENTS with no
LIMIT clause could start a very time- and resource-consuming process because the server returns to the client the complete contents of the binary log (which includes all statements executed by the server that modify data). As an alternative to
SHOW BINLOG EVENTS, use the mysqlbinlog utility to save the binary log to a text file for later examination and analysis. See Section 4.6.7, “mysqlbinlog — Utility for Processing Binary Log Files”.
SHOW BINLOG EVENTS displays the following fields for each event in the binary log:
The name of the file that is being listed.
The position at which the event occurs.
An identifier that describes the event type.
The server ID of the server on which the event originated.
The position at which the next event begins, which is equal to
Posplus the size of the event.
More detailed information about the event type. The format of this information depends on the event type.