This topic describes how to execute the SHOW BINLOG EVENTS statement to query the events in binary log files.

Syntax

SHOW BINLOG EVENTS [WITH stream_name]

Usage notes

  • Before you execute the preceding SQL statement, make sure that your account is granted the REPLICATION SLAVE permission. For information about how to manage permissions, see Manage accounts and permissions.
  • If the SQL statement does not contain a WITH clause, the events in the binary log files generated in single-stream mode are returned.
  • If the SQL statement contains a WITH clause, the events in the binary log files generated for the specified stream in multi-stream mode are returned. The stream_name parameter specifies the name of the stream.
  • For more information about the SQL statement, see SHOW BINLOG EVENTS.

Example 1

Execute the following statement to query the events in the binary log files generated in single-stream mode: 

SHOW BINLOG EVENTS;

The following result is returned:

+---------------+------+------------+-----------+-------------+--------------------------------------------------------+
| LOG_NAME      | POS  | EVENT_TYPE | SERVER_ID | END_LOG_POS | INFO                                                   |
+---------------+------+------------+-----------+-------------+--------------------------------------------------------+
| binlog.000001 |  745 | Query      |         1 |         807 | BEGIN                                                  |
| binlog.000001 |  807 | Table_map  |         1 |         868 | table_id: 258 (transfer_test.accounts)                 |
| binlog.000001 |  868 | Write_rows |         1 |         912 | table_id: 258 flags: STMT_END_F                        |
| binlog.000001 |  912 | Table_map  |         1 |         973 | table_id: 367 (transfer_test.accounts)                 |
| binlog.000001 |  973 | Write_rows |         1 |        1017 | table_id: 367 flags: STMT_END_F                        |
| binlog.000001 | 1017 | Table_map  |         1 |        1078 | table_id: 366 (transfer_test.accounts)                 |
| binlog.000001 | 1078 | Write_rows |         1 |        1122 | table_id: 366 flags: STMT_END_F                        |
| binlog.000001 | 1122 | Table_map  |         1 |        1183 | table_id: 365 (transfer_test.accounts)                 |
| binlog.000001 | 1183 | Write_rows |         1 |        1227 | table_id: 365 flags: STMT_END_F                        |
| binlog.000001 | 1227 | Table_map  |         1 |        1288 | table_id: 365 (transfer_test.accounts)                 |
| binlog.000001 | 1288 | Write_rows |         1 |        1332 | table_id: 365 flags: STMT_END_F                        |
| binlog.000001 | 1332 | Xid        |         1 |        1363 | COMMIT /* xid=1 */                                     |
| binlog.000001 | 1363 | Rows_query |         1 |        1441 | 677707399066754342413081391897447014400000000000132369 |
+---------------+------+------------+-----------+-------------+--------------------------------------------------------+

Example 2

Execute the following statement to query the events in the group1_stream_0_binlog.000001 binary log file generated for the group1_stream_0 stream: 

SHOW BINLOG EVENTS WITH 'group1_stream_0' IN 'group1_stream_0_binlog.000001' LIMIT 10;

The following result is returned:

+-------------------------------+-----+-------------+------------+-------------+-------------------------------------------------------------+
| LOG_NAME                      | POS | EVENT_TYPE  | SERVER_ID  | END_LOG_POS | INFO                                                        |
+-------------------------------+-----+-------------+------------+-------------+-------------------------------------------------------------+
| group1_stream_0#binlog.000001 |   4 | Format_desc | 2065077497 |         123 | Server ver: 5.6.29-TDDL-5.4.13-16504348, Binlog ver: 4      |
| group1_stream_0#binlog.000001 | 123 | Rows_query  | 2065077497 |         206 | CTS::692310358647373830414541688019972300810000000000640450 |
| group1_stream_0#binlog.000001 | 206 | Rows_query  | 2065077497 |         289 | CTS::692310358730001619214541688028360949770000000000640450 |
| group1_stream_0#binlog.000001 | 289 | Rows_query  | 2065077497 |         372 | CTS::692310358815145990414541688036749516810000000000640450 |
| group1_stream_0#binlog.000001 | 372 | Rows_query  | 2065077497 |         455 | CTS::692310358897773779214541688045138165770000000000640450 |
| group1_stream_0#binlog.000001 | 455 | Rows_query  | 2065077497 |         538 | CTS::692310358982498720014541688053526732810000000000640450 |
| group1_stream_0#binlog.000001 | 538 | Rows_query  | 2065077497 |         621 | CTS::692310371229027539214541689278263541770000000000640450 |
| group1_stream_0#binlog.000001 | 621 | Rows_query  | 2065077497 |         704 | CTS::692310371313333049614541689286652108810000000000640450 |
| group1_stream_0#binlog.000001 | 704 | Rows_query  | 2065077497 |         787 | CTS::692310371397219129614541689295040757770000000000640450 |
| group1_stream_0#binlog.000001 | 787 | Rows_query  | 2065077497 |         870 | CTS::692310371481105209614541689303429324810000000000640450 |
+-------------------------------+-----+-------------+------------+-------------+-------------------------------------------------------------+