> For the complete documentation index, see [llms.txt](https://mariadb.com/docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/show/show-relaylog-events.md).

# SHOW RELAYLOG EVENTS

{% hint style="info" %}
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](https://jira.mariadb.org/browse/MDEV-18777) to follow progress on this effort.
{% endhint %}

## Syntax

```bnf
SHOW RELAYLOG ['connection_name'] EVENTS
    [IN 'log_name'] [FROM pos] [LIMIT [offset,] row_count]
    [ FOR CHANNEL 'channel_name']
```

## Description

On [replicas](/docs/server/ha-and-performance/standard-replication.md), this command shows the events in the [relay log](/docs/server/server-management/server-monitoring-logs/binary-log/relay-log.md). If `'log_name'` is not specified, the first relay log is shown.

Syntax for the `LIMIT` clause is the same as for [SELECT ... LIMIT](/docs/server/reference/sql-statements/data-manipulation/selecting-data/select.md#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 [mariadb-binlog](/docs/server/clients-and-utilities/logging-tools/mariadb-binlog.md).

On the primary, this command does nothing.

{% tabs %}
{% tab title="Current" %}
Requires the [REPLICA MONITOR](/docs/server/reference/sql-statements/account-management-sql-statements/grant.md#replica-monitor) privilege.
{% endtab %}

{% tab title="< 10.5.9 / 10.5.2 / 10.5.1" %}
Requires the [REPLICA MONITOR](/docs/server/reference/sql-statements/account-management-sql-statements/grant.md#replica-monitor) privilege (>= [MariaDB 10.5.9](/docs/release-notes/community-server/old-releases/10.5/10.5.9.md)), the [REPLICATION SLAVE ADMIN](/docs/server/reference/sql-statements/account-management-sql-statements/grant.md#replication-slave-admin) privilege (>= [MariaDB 10.5.2](/docs/release-notes/community-server/old-releases/10.5/10.5.2.md)) or the [REPLICATION SLAVE](/docs/server/reference/sql-statements/account-management-sql-statements/grant.md#replication-slave) privilege (<= [MariaDB 10.5.1](/docs/release-notes/community-server/old-releases/10.5/10.5.1.md)).
{% endtab %}
{% endtabs %}

#### connection\_name

If there is only one nameless primary, or the default primary (as specified by the [default\_master\_connection](/docs/server/ha-and-performance/standard-replication/replication-and-binary-log-system-variables.md) 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.

{% tabs %}
{% tab title="Current" %}
The `FOR CHANNEL` keyword was added for MySQL compatibility. This is identical as using the `channel_name` directly after `SHOW RELAYLOG`.
{% endtab %}

{% tab title="< 10.7.0" %}
`FOR CHANNEL` is not available.
{% endtab %}
{% endtabs %}

<sub>*This page is licensed: CC BY-SA / Gnu FDL*</sub>

{% @marketo/form formId="4316" %}