mysql> stop slave; mysql> change master to master_delay=10;#單位是秒 mysql> start slave; mysql> show slave status\G *************************** 1. row ***************************Slave_IO_State: Waiting for master to send event...SQL_Delay: 10SQL_Remaining_Delay: NULLSlave_SQL_Running_State: Slave has read all relay log; waiting for the slave I/O thread to update itMaster_Retry_Count: 86400Master_Bind: Last_IO_Error_Timestamp: Last_SQL_Error_Timestamp: Master_SSL_Crl: Master_SSL_Crlpath: Retrieved_Gtid_Set: Executed_Gtid_Set: Auto_Position: 0 1 row in set (0.00 sec)mysql>

?

轉載于:https://www.cnblogs.com/abclife/p/5691563.html

總結

以上是生活随笔為你收集整理的Mysql复制-Slave库设置复制延迟的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。