The state of the Group Replication related channels and threads can be observed using the regular replication_applier_status table as well. If there are many different worker threads applying transactions, then the worker tables can also be used to monitor what each worker thread is doing.
Table 17.4 replication_applier_status
Field | Description |
|---|---|
Channel_name | The name of the Group Replication channel. |
Service_state | Shows whether the applier service is ON or OFF. |
Remaining_delay | Shows whether there is some applier delay configured. |
Count_transactions_retries | The number of retries performed while applying a transaction. |
Received_transaction_set | Transactions in this GTID set have been received by this member of the group. |