SHOW BINLOG EVENTS [IN 'log_name'] [FROM pos] [LIMIT [offset,] row_count]
Shows the events in the binary log. If you do not specify 'log_name
', the first binary log is displayed.
SHOW BINLOG EVENTS IN 'mysql_sandbox10019-bin.000002'; +-------------------------------+-----+-------------------+-----------+-------------+------------------------------------------------+ | Log_name | Pos | Event_type | Server_id | End_log_pos | Info | +-------------------------------+-----+-------------------+-----------+-------------+------------------------------------------------+ | mysql_sandbox10019-bin.000002 | 4 | Format_desc | 1 | 248 | Server ver: 10.0.19-MariaDB-log, Binlog ver: 4 | | mysql_sandbox10019-bin.000002 | 248 | Gtid_list | 1 | 273 | [] | | mysql_sandbox10019-bin.000002 | 273 | Binlog_checkpoint | 1 | 325 | mysql_sandbox10019-bin.000002 | | mysql_sandbox10019-bin.000002 | 325 | Gtid | 1 | 363 | GTID 0-1-1 | | mysql_sandbox10019-bin.000002 | 363 | Query | 1 | 446 | CREATE DATABASE blog | | mysql_sandbox10019-bin.000002 | 446 | Gtid | 1 | 484 | GTID 0-1-2 | | mysql_sandbox10019-bin.000002 | 484 | Query | 1 | 571 | use `blog`; CREATE TABLE bb (id INT) | +-------------------------------+-----+-------------------+-----------+-------------+------------------------------------------------+
© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/show-binlog-events/