> 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/system-tables/performance-schema/performance-schema-tables/performance-schema-replication_applier_status-table.md).

# Performance Schema replication\_applier\_status Table

{% hint style="info" %}
The `replication_applier_status` table is available from MariaDB 10.5.2.
{% endhint %}

The [Performance Schema](/docs/server/reference/system-tables/performance-schema.md) replication\_applier\_status table contains information about the general transaction execution status on the replica.

It contains the following fields.

| Field                        | Type                | Null | Description                                                                                                                    |
| ---------------------------- | ------------------- | ---- | ------------------------------------------------------------------------------------------------------------------------------ |
| CHANNEL\_NAME                | char(64)            | NO   | The replication channel name.                                                                                                  |
| SERVICE\_STATE               | enum('ON','OFF')    | NO   | Shows ON when the replication channel's applier threads are active or idle, OFF means that the applier threads are not active. |
| REMAINING\_DELAY             | int(10) unsigned    | YES  | Seconds the replica needs to wait to reach the desired delay from master.                                                      |
| COUNT\_TRANSACTIONS\_RETRIES | bigint(20) unsigned | NO   | The number of retries that were made because the replication SQL thread failed to apply a transaction.                         |

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

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