row *** Replica_IO_State: Waiting for source to send event Source_Host: 192.168.11.152 Source_User: syn_b Source_Port: 3306 Connect_Retry: 60 Source_Log_File: mysql-bin.000060 Read_Source_Log_Pos: 200550 Relay_Log_File: zbx-db01-relay-bin.000002 Relay_Log_Pos: 324 Relay_Source_Log...
Someone has sent a KILL statement to the thread and it should abort next time it checks the kill flag. The flag is checked in each major loop in MySQL, but in some cases it might still take a short time for the thread to die. If the thread is locked by some other thread, the kil...
Replica_IO_State: Waiting for source to send event Source_Host: 10.28.29.55 Source_User: repl Source_Port: 3306 Connect_Retry: 60 Source_Log_File: mysql-bin.000003 Read_Source_Log_Pos: 721 Relay_Log_File: idc-mongo58-relay-bin.000002 Relay_Log_Pos: 422 Relay_Source_Log_File: mysql-bi...
Query OK, 0 rows affected (0.00 sec) 1. 2. 3. 4. mysql> show slave status\G *** 1. row *** Slave_IO_State: Waiting for source to send event Master_Host: 192.168.67.110 Master_User: repl Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.000007 Read_Master_Log_Po...
Waiting for source to send event 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...
mysqld will log errors to /var/lib/mysql/f0d909d9adcb.err mysqld is running as pid 94 2022-07-23 09:58:56+08:00 [Note] [Entrypoint]: Temporary server started. Warning: Unable to load '/usr/share/zoneinfo/iso3166.tab' as time zone. Skipping it. ...
Waiting for master to send event From MySQL 8.0.26: Waiting for source to send event 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 or slave_net...
row *** Replica_IO_State: Waiting for source to send event Source_Host: 192.168.11.151 Source_User: syn_a Source_Port: 3306 Connect_Retry: 60 Source_Log_File: mysql-bin.000005 Read_Source_Log_Pos: 1986340 Relay_Log_File: zbx-db02-relay-bin.000012 Relay_Log_Pos: 630974 Relay_Source_...
| 16 | system user | connecting host | NULL | Connect | 5279 | Waiting for source to send event | NULL | | 17 | system user | | NULL | Query | 5010 | Replica has read all relay log; waiting for more updates | NULL |
row *** Replica_IO_State: Waiting for source to send event Source_Host: XXXXXXXXXX Source_User: XXXXXXXXXX Source_Port: XXXXXXXXXX Connect_Retry: 60 Source_Log_File: mysql-bin-changelog.XXXXXXXXXX Read_Source_Log_Pos: 2548XXXXXXXXXX Relay_Log_File: XXXXXXXXXX-relay-bin.XXXXXXXXXX Relay...