MySQL 5.7 Reference Manual Including MySQL NDB Cluster 7.5 and NDB Cluster 7.6
This table shows the current general transaction execution
status on the replica. The table provides information about
general aspects of transaction applier status that are not
specific to any thread involved. Thread-specific status
information is available in the
replication_applier_status_by_coordinator
table (and
replication_applier_status_by_worker
if the replica is multithreaded).
The replication_applier_status
table has these columns:
CHANNEL_NAME
The replication channel which this row is displaying. There is always a default replication channel, and more replication channels can be added. See Section 16.2.2, “Replication Channels” for more information.
SERVICE_STATE
Shows ON when the replication channel's
applier threads are active or idle, OFF
means that the applier threads are not active.
REMAINING_DELAY
If the replica is waiting for
DESIRED_DELAY seconds to pass since the
source applied an event, this field contains the number of
delay seconds remaining. At other times, this field is
NULL. (The
DESIRED_DELAY value is stored in the
replication_applier_configuration
table.)
COUNT_TRANSACTIONS_RETRIES
Shows the number of retries that were made because the
replication SQL thread failed to apply a transaction. The
maximum number of retries for a given transaction is set
by the
slave_transaction_retries
system variable.
TRUNCATE TABLE is not permitted
for the
replication_applier_status table.
The following table shows the correspondence between
replication_applier_status
columns and SHOW SLAVE STATUS
columns.
replication_applier_status Column |
SHOW SLAVE STATUS Column |
|---|---|
SERVICE_STATE |
None |
REMAINING_DELAY |
SQL_Remaining_Delay |