Slave_IO_State: Waiting for master to send event Master_Host: 12.12.12.12 Master_User: slave Master_Port: 3307 Connect_Retry: 60 Master_Log_File: mysql-bin.001756 Read_Master_Log_Pos: 226913659 Relay_Log_File: relaylog.002082 Relay_Log_Pos: 54747568 Relay_Master_Log_File: mysql-bin.001756 Slave_IO_Running: Yes Slave_SQL_Running: No Replicate_Do_DB: Replicate_Ignore_DB: Replicate_Do_Table: Replicate_Ignore_Table: Replicate_Wild_Do_Table: Replicate_Wild_Ignore_Table: Last_Errno: 0 Last_Error: Skip_Counter: 0 Exec_Master_Log_Pos: 54747363 Relay_Log_Space: 226914179 Until_Condition: None Until_Log_File: Until_Log_Pos: 0 Master_SSL_Allowed: No Master_SSL_CA_File: Master_SSL_CA_Path: Master_SSL_Cert: Master_SSL_Cipher: Master_SSL_Key: Seconds_Behind_Master: NULL Master_SSL_Verify_Server_Cert: No Last_IO_Errno: 0 Last_IO_Error: Last_SQL_Errno: 0 Last_SQL_Error: Replicate_Ignore_Server_Ids: Master_Server_Id: 481393307 Master_UUID: dff65ff0-fb2e-11eb-a350-b4055d80d812 Master_Info_File: mysql.slave_master_info SQL_Delay: 0 SQL_Remaining_Delay: NULL Slave_SQL_Running_State: Master_Retry_Count: 86400 Master_Bind: Last_IO_Error_Timestamp: Last_SQL_Error_Timestamp: Master_SSL_Crl: Master_SSL_Crlpath: Retrieved_Gtid_Set: ca74c47e-fb3e-11eb-9606-b4055d7de08e:1-104948685, dff65ff0-fb2e-11eb-a350-b4055d80d812:383340961-539319391 Executed_Gtid_Set: ca74c47e-fb3e-11eb-9606-b4055d7de08e:1-104782942, dff65ff0-fb2e-11eb-a350-b4055d80d812:1-539319391 Auto_Position: 1 Replicate_Rewrite_DB: Channel_Name: Master_TLS_Version:
日志:
2023-05-10T09:00:03.471325+08:00 929140 [Warning] STOP SLAVE command execution is incomplete: Slave SQL thread got the stop signal, thread is busy, SQL thread will stop once the current task is complete.
2023-05-10T09:05:46.731588+08:00 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4255ms. The settings might not be optimal. (flushed=1000, during the time.)
记录一下因为进行大表变更,导致灾备库复制中断
解决:
start slave;
标签:Last,Log,MySQL,SSL,Master,SQL,Replicate From: https://www.cnblogs.com/jokerWzz/p/17387332.html