1 of 1

SHOW RELAYLOG EVENTS

Inspect events in the relay log. This statement displays replication events from the relay log on a replica server.

The terms master and slave have historically been used in replication, and MariaDB has begun the process of adding primary and replica synonyms. The old terms will continue to be used to maintain backward compatibility - see MDEV-18777 to follow progress on this effort.

Syntax

Description

On , this command shows the events in the . If 'log_name' is not specified, the first relay log is shown.

Syntax for the LIMIT clause is the same as for .

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 .

On the primary, this command does nothing.

Requires the privilege.

Requires the privilege (>= ), the privilege (>= ) or the privilege (<= ).

connection_name

If there is only one nameless primary, or the default primary (as specified by the system variable) is intended, connection_name can be omitted. If provided, the SHOW RELAYLOG statement will apply to the specified primary. connection_name is case-insensitive.

The FOR CHANNEL keyword was added for MySQL compatibility. This is identical as using the channel_name directly after SHOW RELAYLOG.

FOR CHANNEL is not available.

_{This page is licensed: CC BY-SA / Gnu FDL}