SHOW RELAYLOG ['connection_name'] EVENTS [IN 'log_name'] [FROM pos] [LIMIT [offset,] row_count]
On replication slaves this command shows the events in the relay log. If 'log_name'
is not specified, the first relay log is shown.
Syntax for the LIMIT
clause is the same as for SELECT ... LIMIT
.
Using the LIMIT
clause is highly recommended because the SHOW RELAYLOG EVENTS
command returns the complete contents of the relay log, which can be quite large.
This command does not return events related to setting user and system variables. If you need those, use mysqlbinlog
.
On the replication master, this command does nothing.
connection_name
was added as part of multi-source replication added in MariaDB 10.0.1
If there is only one nameless master, or the default master (as specified by the default_master_connection
system variable) is intended, connection_name
can be omitted. If provided, the SHOW RELAYLOG
statement will apply to the specified master. connection_name
is case-insensitive.
© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/show-relaylog-events/