1. 解释"mysql waiting for source to send event"的含义 "mysql waiting for source to send event" 通常出现在MySQL复制(replication)环境中,特别是在使用基于二进制日志(binlog)的复制方式时。这个状态意味着从服务器(slave)正在等待主服务器(master)发送事件(如数据更改、DDL操作等)到其复制I/O线程。简单来...
Replica_IO_State: Waiting for source to send event Source_Host: 172.17.140.201 Source_User: repl_user Source_Port: 6001 Connect_Retry: 10 Source_Log_File: binlog.000001 Read_Source_Log_Pos: 2614 Relay_Log_File: relaylog-mgra_to_mgrb.000002 Relay_Log_Pos: 2816 Relay_Source_Log_File: b...
Query OK,0rowsaffected,9warnings (0.01sec) mysql>startslave; Query OK,0rowsaffected,1warning (0.00sec) mysql>showslave status \G***1.row***Slave_IO_State: Waitingforsourcetosend event Master_Host:192.168.1.132Master_User: slave Master_Port:3306Connect_Retry:60Master_Log_File: master-bin.0...
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...
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 ...
This occurs at the end but before the cleanup of ALTER TABLE, CREATE VIEW, DELETE, INSERT, SELECT, or UPDATE statements. For the end state, the following operations could be happening: Writing an event to the binary log Freeing memory buffers, including for blobs【blɑbz (颜色的)一小片,...
Slave_IO_State: Waiting for source to send event 等待目标库(从库) 同步完数据 使用show slave status看到如下信息, 则为数据同步完成 Slave_SQL_Running_State: Replica has read all relay log; waiting for more updates 目标库停止主从 代码语言:javascript ...
If you are using the SHOW REPLICA STATUS statement to check on the status of an individual replica, the statement provides the following information: mysql> SHOW REPLICA STATUS\G *** 1. row *** ReplicaIO_State: Waiting for source to send event Source_Host: 127.0.0.1 Source_User: root...
| 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 |
source/opt/test01_set-gtid-purgedis_on.sql;# 登录从库检查复制状态[正常的,因为还没有主库没有涉及到这个库的操作]mysql>show slave status\G***1.row***Slave_IO_State:Waitingformaster to send eventMaster_Host:172.20.134.2Master_User:universe_opMaster_Port:3306Connect_Retry:60Master_Log_File...