HA-Slave一直处于Reading event from the relay log状态

[杰克牌辣酱]

情况描述：
环境是测试环境，MMM架构，2主1从，数据同步状态是正常的。
现在主库上有一张10W条记录的表，我对它执行了一条UPDATE语句，更新了9W条记录，
查看Slave状态的时候，发现slave已经读取了Master的日志，但是一直处于Reading event from the relay log的状体：

db2 [(none)] [12:09:03]> show slave status\G
*************************** 1. row ***************************
Slave_IO_State: Waiting for master to send event
Master_Host: 192.168.100.5
Master_User: replication
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: mysql-bin.000020
Read_Master_Log_Pos: 524963654
Relay_Log_File: mysql-relay.000002
Relay_Log_Pos: 398
Relay_Master_Log_File: mysql-bin.000020
Slave_IO_Running: Yes
Slave_SQL_Running: Yes
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: 463245202
Relay_Log_Space: 61719019
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: 4408
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: 201
Master_UUID: bebbbeef-fa9c-11e3-a50f-fa163ee2a507
Master_Info_File: mysql.slave_master_info
SQL_Delay: 0
SQL_Remaining_Delay: NULL
Slave_SQL_Running_State: Reading event from the relay log
Master_Retry_Count: 86400
Master_Bind:
Last_IO_Error_Timestamp:
Last_SQL_Error_Timestamp:
Master_SSL_Crl:
Master_SSL_Crlpath:


MMM中的服务器配置：
主Master的内存配置是 2G，另一个Master的内存是1G，Slave的内存配置是1G

谢谢

[rucypli]

show processlist看看进程

[杰克牌辣酱]

引用 1 楼 rucypli 的回复:

show processlist看看进程

找到了 ---TRANSACTION 10553, ACTIVE 15712 sec fetching rows mysql tables in use 1, locked 1 2192 lock struct(s), heap size 211384, 92746 row lock(s), undo log entries 89705 MySQL thread id 37541, OS thread handle 0x7f8b45711700, query id 114545 Reading event from the relay log TABLE LOCK table `test`.`t7` trx id 10553 lock mode IX RECORD LOCKS space id 92 page no 4 n bits 112 index `GEN_CLUST_INDEX` of table `test`.`t7` trx id 10553 lock_mode X locks rec but not gap RECORD LOCKS space id 92 page no 5 n bits 112 index `GEN_CLUST_INDEX` of table `test`.`t7` trx id 10553 lock_mode X locks rec but not gap RECORD LOCKS space id 92 page no 6 n bits 112 index `GEN_CLUST_INDEX` of table `test`.`t7` trx id 10553 lock_mode X locks rec but not gap RECORD LOCKS space id 92 page no 7 n bits 112 index `GEN_CLUST_INDEX` of table `test`.`t7` trx id 10553 lock_mode X locks rec but not gap

[无忧工作室]

这说明什么问题呢？

[杰克牌辣酱]

引用 3 楼 CloudHorizon 的回复:

这说明什么问题呢？

配置太低吗