This table shows the current general transaction execution
status on the slave server. This table was added in MySQL
5.7.2 with the name
replication_execute_status, and renamed to
in MySQL 5.7.6.
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 18.2.3, “Replication Channels” for more information.
Reserved for future use.
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
Added in MySQL 5.7.5, shows the number of retries that were made because the slave SQL thread failed to apply a transaction.