文章目录
MySQL 集群管理之复制延迟优化
1. 确认主从同步延迟情况
# mysql -uroot -ppassword_need_input -P3306 -S/data/mysql/3306/run/mysqld.sock -e "show slave status\G" |grep -E "Master_Log_File|Read_Master_Log_Pos|Relay_Log_File|Relay_Log_Pos|Relay_Master_Log_File|Slave_IO_Running|Slave_SQL_Running|Exec_Master_Log_Pos|Relay_Log_Space|Seconds_Behind_Master|Slave_SQL_Running_State"
Master_Log_File: mysql-bin.000080
Read_Master_Log_Pos: 1037345645
Relay_Log_File: mysql-relay-bin.000239
Relay_Log_Pos: 724142022
Relay_Master_Log_File: mysql-bin.000080 --观察与主库相差多少个binlog
Slave_IO_Running: Ye