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. For a
single-threaded slave, this table is empty. 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 16.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 which is an empty string means “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.