This table shows the current general transaction execution status on the slave server. This table was added in MySQL 5.7.2.
This table provides information about general aspects of
transaction execution status that are not specific to any
thread involved. Thread-specific status information is
available in the
if the slave is multi-threaded).
table has these columns:
Reserved for future use.
If the slave is waiting for
DESIRED_DELAY seconds to pass since the
master executed an event, this field contains the number
of delay seconds remaining. At other times, this field is
DESIRED_DELAY value is stored in the
Added in MySQL 5.7.5, this field shows the number of retries that were made because the slave SQL thread failed to execute a transaction.