This table shows the current general transaction execution status on the slave server.
This 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
if the slave is multi-threaded).
table has these columns:
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.3, “Replication Channels” for more information.
ONwhen the replication channel's applier threads are active or idle,
OFFmeans that the applier threads are not active.
If the slave is waiting for
DESIRED_DELAYseconds to pass since the master applied an event, this field contains the number of delay seconds remaining. At other times, this field is
DESIRED_DELAYvalue is stored in the
Shows the number of retries that were made because the slave SQL thread failed to apply a transaction.