SHOW RELAYLOG ['connection_name'] EVENTS [IN 'log_name'] [FROM pos] [LIMIT [offset,] row_count]
Syntax for the
LIMIT clause is the same as for
SELECT ... LIMIT.
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
On the replication master, this command does nothing.
MariaDB starting with 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.