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

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

This table shows the status of the coordinator thread when parallel replication is enabled, detailing the distribution of transactions to workers.

The [Performance Schema](/docs/server/reference/system-tables/performance-schema.md) replication\_applier\_status\_by\_coordinator table displays the status of the coordinator thread used in multi-threaded replicas to manage multiple worker threads.

It contains the following fields.

| Column                    | Type                | Null | Description                                                                |
| ------------------------- | ------------------- | ---- | -------------------------------------------------------------------------- |
| CHANNEL\_NAME             | varchar(256)        | NO   | Replication channel name.                                                  |
| THREAD\_ID                | bigint(20) unsigned | YES  | The SQL/coordinator thread ID.                                             |
| SERVICE\_STATE            | enum('ON','OFF')    | NO   | ON (thread exists and is active or idle) or OFF (thread no longer exists). |
| LAST\_ERROR\_NUMBER       | int(11)             | NO   | Last error number that caused the SQL/coordinator thread to stop.          |
| LAST\_ERROR\_MESSAGE      | varchar(1024)       | NO   | Last error message that caused the SQL/coordinator thread to stop.         |
| LAST\_ERROR\_TIMESTAMP    | timestamp           | NO   | Timestamp that shows when the most recent SQL/coordinator error occurred.  |
| LAST\_SEEN\_TRANSACTION   | char(57)            | NO   | The transaction the worker has last seen.                                  |
| LAST\_TRANS\_RETRY\_COUNT | int(11)             | NO   | Total number of retries attempted by last transaction.                     |

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

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