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.


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.


Comments loading...