SHOW RELAYLOG EVENTS
Syntax
SHOW RELAYLOG ['connection_name'] EVENTS [IN 'log_name'] [FROM pos] [LIMIT [offset,] row_count]
Description
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
MariaDB starting with 10.0.1
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.