For a multi-threaded slave, the slave uses multiple worker
threads and a coordinator thread to manage them, and this
table shows the status of the coordinator thread. In MySQL
5.7.9 and later, for a single-threaded slave, this table is
empty. (Previously, this table showed the applier thread
status for a single-threaded slave; this information can now
be found in the
table in such cases. See Bug #74765, Bug #20001173.) This
table was added in MySQL 5.7.2 as
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 idle) 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_MESSAGEvalue is not empty, the error values also appear in the slave's error log.
All error codes and messages displayed in the
LAST_ERROR_MESSAGEcolumns correspond to error values listed in Section B.3, “Server Error Codes and Messages”.
A timestamp in
YYMMDD HH:MM:SSformat that shows when the most recent SQL/coordinator error occurred.