Checking master version Checking master version

Checking source version Checking source version

在与源建立连接后，极短时间内发生的一种状态。A state that occurs very briefly, after the connection to the source is established.

Connecting to master Connecting to master

Connecting to source Connecting to source

线程正在尝试连接到源。The thread is attempting to connect to the source.

Queueing master event to the relay log Queueing master event to the relay log

Queueing source event to the relay log Queueing source event to the relay log

线程已经读取了一个事件，并将其复制到中继日志，以便 SQL 线程可以处理它。The thread has read an event and is copying it to the relay log so that the SQL thread can process it.

Reconnecting after a failed binlog dump request Reconnecting after a failed binlog dump request

线程正在尝试重新连接到源。The thread is trying to reconnect to the source.

Reconnecting after a failed master event read Reconnecting after a failed master event read

Reconnecting after a failed source event read Reconnecting after a failed source event read

线程正在尝试重新连接到源服务器。当连接再次建立时，状态变为 Waiting for master to send event。The thread is trying to reconnect to the source. When connection is established again, the state becomes Waiting for master to send event.

Registering slave on master Registering slave on master

Registering replica on source Registering replica on source

在与源建立连接后很短暂出现的一种状态。A state that occurs very briefly after the connection to the source is established.

Requesting binlog dump Requesting binlog dump

在连接到源建立后非常短暂地发生的一种状态。线程向源发送请求，以获取其二进制日志的内容，从请求的二进制日志文件名和位置开始。A state that occurs very briefly, after the connection to the source is established. The thread sends to the source a request for the contents of its binary logs, starting from the requested binary log file name and position.

Waiting for its turn to commit Waiting for its turn to commit

当副本线程在等待旧的工作线程提交时发生的状态，如果启用了 replica_preserve_commit_order。A state that occurs when the replica thread is waiting for older worker threads to commit if replica_preserve_commit_order is enabled.

Waiting for master to send event Waiting for master to send event

Waiting for source to send event Waiting for source to send event

线程已连接到源，并正在等待二进制日志事件的到来。如果源处于空闲状态，这可能会持续很长时间。如果等待时间达到 replica_net_timeout 秒，则会发生超时。到那时，线程会认为连接已断开，并尝试重新连接。The thread has connected to the source and is waiting for binary log events to arrive. This can last for a long time if the source is idle. If the wait lasts for replica_net_timeout seconds, a timeout occurs. At that point, the thread considers the connection to be broken and makes an attempt to reconnect.

Waiting for master update Waiting for master update

Waiting for source update Waiting for source update

在 Connecting to master 或 Connecting to source 之前的初始状态。The initial state before Connecting to master or Connecting to source.

Waiting for slave mutex on exit Waiting for slave mutex on exit

Waiting for replica mutex on exit Waiting for replica mutex on exit

在线程停止时短暂发生的状态。A state that occurs briefly as the thread is stopping.

Waiting for the slave SQL thread to free enough relay log space Waiting for the slave SQL thread to free enough relay log space

Waiting for the replica SQL thread to free enough relay log space Waiting for the replica SQL thread to free enough relay log space

您正在使用非零的 relay_log_space_limit 值，中继日志已经增长到足够大，其总大小超过了该值。I/O（接收）线程正在等待，直到 SQL（应用）线程通过处理中继日志内容释放出足够的空间，以便它可以删除一些中继日志文件。You are using a nonzero relay_log_space_limit value, and the relay logs have grown large enough that their combined size exceeds this value. The I/O (receiver) thread is waiting until the SQL (applier) thread frees enough space by processing relay log contents so that it can delete some relay log files.

Waiting to reconnect after a failed binlog dump request Waiting to reconnect after a failed binlog dump request

如果二进制日志转储请求失败（由于断开连接），线程将在休眠时进入此状态，然后尝试定期重新连接。重试间隔可以使用CHANGE REPLICATION SOURCE TO进行指定。If the binary log dump request failed (due to disconnection), the thread goes into this state while it sleeps, then tries to reconnect periodically. The interval between retries can be specified using the CHANGE REPLICATION SOURCE TO.

Waiting to reconnect after a failed master event read Waiting to reconnect after a failed master event read

Waiting to reconnect after a failed source event read Waiting to reconnect after a failed source event read

读取时发生错误（由于断开连接）。线程会在尝试重新连接之前，按照 CHANGE REPLICATION SOURCE TO 语句设置的秒数休眠。An error occurred while reading (due to disconnection). The thread is sleeping for the number of seconds set by the CHANGE REPLICATION SOURCE TO statement before attempting to reconnect.