For a multithreaded replica, the replica 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 replica, this table is empty. For a
multithreaded replica, 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.2, “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 replica's error log.
All error codes and messages displayed in the
LAST_ERROR_MESSAGEcolumns correspond to error values listed in Server Error Message Reference.
A timestamp in
YYMMDD hh:mm:ssformat that shows when the most recent SQL/coordinator error occurred.
SHOW SLAVE STATUS Column