# 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](https://mariadb.com/docs/server/reference/system-tables/performance-schema) 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" %}