If the slave is not multi-threaded, this table shows the
status of the SQL thread. Otherwise, the slave uses multiple
worker threads and a coordinator thread to manage them, and
this table shows the status of the coordinator thread. This
table was added in MySQL 5.7.2 with the name
in MySQL 5.7.6. For a multi-threaded slave, the
table shows the status of the worker threads.
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 17.2.3, “Replication Channels” for more information.
The SQL/coordinator thread ID.
ON (thread exists and is active or
OFF (thread no longer exists).
The error number and error message of the most recent
error that caused the SQL/coordinator 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.
All error codes and messages displayed in the
LAST_ERROR_MESSAGE columns correspond
to error values listed in
Section B.3, “Server Error Codes and Messages”.
A timestamp in
YYMMDD HH:MM:SS format
that shows when the most recent SQL/coordinator error