The Ultimate Guide to High Availability with MariaDB

SHOW RELAYLOG EVENTS

You are viewing an old version of this article. View the current version here.

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 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

Comments loading...
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.