> 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_by_worker-table.md).

# Performance Schema replication\_applier\_status\_by\_worker Table

The replication\_applier\_status\_by\_worker table provides status information for each worker thread involved in parallel replication.

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

The [Performance Schema](/docs/server/reference/system-tables/performance-schema.md) replication\_applier\_status\_by\_worker table displays replica worker thread specific information.

It contains the following fields.

| Column                    | Description                                                                                                                                                                                                                                                                                                                         |
| ------------------------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| CHANNEL\_NAME             | Name of replication channel through which the transaction is received.                                                                                                                                                                                                                                                              |
| THREAD\_ID                | Thread\_Id as displayed in the [performance\_schema.threads](/docs/server/reference/system-tables/performance-schema/performance-schema-tables/performance-schema-threads-table.md) table for thread with name 'thread/sql/rpl\_parallel\_thread'. THREAD\_ID will be NULL when worker threads are stopped due to error/force stop. |
| SERVICE\_STATE            | Whether or not the thread is running.                                                                                                                                                                                                                                                                                               |
| LAST\_SEEN\_TRANSACTION   | Last GTID executed by worker                                                                                                                                                                                                                                                                                                        |
| LAST\_ERROR\_NUMBER       | Last Error that occurred on a particular worker.                                                                                                                                                                                                                                                                                    |
| LAST\_ERROR\_MESSAGE      | Last error specific message.                                                                                                                                                                                                                                                                                                        |
| LAST\_ERROR\_TIMESTAMP    | Time stamp of last error.                                                                                                                                                                                                                                                                                                           |
| WORKER\_IDLE\_TIME        | Total idle time in seconds that the worker thread has spent waiting for work from SQL thread.                                                                                                                                                                                                                                       |
| LAST\_TRANS\_RETRY\_COUNT | Total number of retries attempted by last transaction.                                                                                                                                                                                                                                                                              |

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

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