This table shows the current status of the I/O thread that handles the slave server connection to the master server. This table was added in MySQL 5.7.2.
Compared to the
changes more frequently. It contains values that change during
the connection, whereas
contains values define how the slave connects to the master
and that remain constant during the connection.
table has these columns:
from the master.
The I/O thread ID.
ON (thread exists and is active or
OFF (thread no longer exists),
CONNECTING (thread exists and is
connecting to the master).
The set of global transaction IDs (GTIDs) corresponding to all transactions received by this slave. Empty if GTIDs are not in use.
The error number and error message of the most recent
error that caused the I/O thread to stop. An error number
of 0 and message of the empty string mean “no
error.” If the
LAST_ERROR_MESSAGE value is not empty,
the error values also appear in the slave's error log.
A timestamp in
YYMMDD HH:MM:SS format
that shows when the most recent I/O error took place.