MariaDB [(none)]> start slave; Query OK, 0 rows affected (0.006 sec) *************************** 1. row *************************** Slave_IO_State: Queueing master event to the relay log Master_Host: 172.31.71.127 Master_User: repl Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.000002 Read_Master_Log_Pos: 114944432 Relay_Log_File: ip-172-31-64-255-relay-bin.000005 Relay_Log_Pos: 24536080 Relay_Master_Log_File: mysql-bin.000002 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: 24535945 Relay_Log_Space: 114945287 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: 4 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: 1 Master_SSL_Crl: Master_SSL_Crlpath: Using_Gtid: Slave_Pos Gtid_IO_Pos: 201-1-622 Replicate_Do_Domain_Ids: Replicate_Ignore_Domain_Ids: Parallel_Mode: optimistic SQL_Delay: 0 SQL_Remaining_Delay: NULL Slave_SQL_Running_State: Reading event from the relay log Slave_DDL_Groups: 0 Slave_Non_Transactional_Groups: 438 Slave_Transactional_Groups: 0 sleep(10) 0 Id User Host db Command Time State Info Progress 11 root localhost NULL Sleep 210 NULL 0.000 16 system user NULL Slave_IO 513 Waiting for master to send event NULL 0.000 18 system user NULL Slave_worker 0 closing tables NULL 0.000 19 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 20 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 21 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 17 system user NULL Slave_SQL 227 Slave has read all relay log; waiting for more updates NULL 0.000 32 root localhost NULL Sleep 0 NULL 0.000 33 root localhost NULL Query 0 starting show full processlist 0.000 *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: 172.31.71.127 Master_User: repl Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.000002 Read_Master_Log_Pos: 344016730 Relay_Log_File: ip-172-31-64-255-relay-bin.000005 Relay_Log_Pos: 75172808 Relay_Master_Log_File: mysql-bin.000002 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: 75172673 Relay_Log_Space: 344017585 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: 14 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: 1 Master_SSL_Crl: Master_SSL_Crlpath: Using_Gtid: Slave_Pos Gtid_IO_Pos: 201-1-1061 Replicate_Do_Domain_Ids: Replicate_Ignore_Domain_Ids: Parallel_Mode: optimistic SQL_Delay: 0 SQL_Remaining_Delay: NULL Slave_SQL_Running_State: Slave has read all relay log; waiting for more updates Slave_DDL_Groups: 0 Slave_Non_Transactional_Groups: 535 Slave_Transactional_Groups: 0 sleep(10) 0 Id User Host db Command Time State Info Progress 11 root localhost NULL Sleep 222 NULL 0.000 16 system user NULL Slave_IO 524 Waiting for master to send event NULL 0.000 18 system user NULL Slave_worker 0 closing tables NULL 0.000 19 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 20 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 21 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 17 system user NULL Slave_SQL 239 Slave has read all relay log; waiting for more updates NULL 0.000 32 root localhost NULL Sleep 4 NULL 0.000 36 root localhost NULL Query 0 starting show full processlist 0.000 *************************** 1. row *************************** Slave_IO_State: Queueing master event to the relay log Master_Host: 172.31.71.127 Master_User: repl Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.000002 Read_Master_Log_Pos: 532091896 Relay_Log_File: ip-172-31-64-255-relay-bin.000005 Relay_Log_Pos: 126853526 Relay_Master_Log_File: mysql-bin.000002 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: 126853391 Relay_Log_Space: 532092751 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: 23 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: 1 Master_SSL_Crl: Master_SSL_Crlpath: Using_Gtid: Slave_Pos Gtid_IO_Pos: 201-1-1421 Replicate_Do_Domain_Ids: Replicate_Ignore_Domain_Ids: Parallel_Mode: optimistic SQL_Delay: 0 SQL_Remaining_Delay: NULL Slave_SQL_Running_State: Reading event from the relay log Slave_DDL_Groups: 0 Slave_Non_Transactional_Groups: 634 Slave_Transactional_Groups: 0 sleep(10) 0 Id User Host db Command Time State Info Progress 11 root localhost NULL Sleep 234 NULL 0.000 16 system user NULL Slave_IO 536 Waiting for master to send event NULL 0.000 18 system user NULL Slave_worker 0 closing tables NULL 0.000 19 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 20 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 21 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 17 system user NULL Slave_SQL 251 Waiting for room in worker thread event queue NULL 0.000 32 root localhost NULL Sleep 2 NULL 0.000 38 root localhost NULL Query 0 starting show full processlist 0.000 *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: 172.31.71.127 Master_User: repl Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.000002 Read_Master_Log_Pos: 779387823 Relay_Log_File: ip-172-31-64-255-relay-bin.000005 Relay_Log_Pos: 176968448 Relay_Master_Log_File: mysql-bin.000002 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: 176968313 Relay_Log_Space: 779388678 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: 32 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: 1 Master_SSL_Crl: Master_SSL_Crlpath: Using_Gtid: Slave_Pos Gtid_IO_Pos: 201-1-1896 Replicate_Do_Domain_Ids: Replicate_Ignore_Domain_Ids: Parallel_Mode: optimistic SQL_Delay: 0 SQL_Remaining_Delay: NULL Slave_SQL_Running_State: Waiting for room in worker thread event queue Slave_DDL_Groups: 0 Slave_Non_Transactional_Groups: 730 Slave_Transactional_Groups: 0 sleep(10) 0 Id User Host db Command Time State Info Progress 11 root localhost NULL Sleep 245 NULL 0.000 16 system user NULL Slave_IO 548 Waiting for master to send event NULL 0.000 18 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 19 system user NULL Slave_worker 0 closing tables NULL 0.000 20 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 21 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 17 system user NULL Slave_SQL 262 Waiting for room in worker thread event queue NULL 0.000 32 root localhost NULL Sleep 1 NULL 0.000 41 root localhost NULL Query 0 starting show full processlist 0.000 *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: 172.31.71.127 Master_User: repl Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.000002 Read_Master_Log_Pos: 981933166 Relay_Log_File: ip-172-31-64-255-relay-bin.000005 Relay_Log_Pos: 234912728 Relay_Master_Log_File: mysql-bin.000002 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: 234912593 Relay_Log_Space: 981934021 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: 42 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: 1 Master_SSL_Crl: Master_SSL_Crlpath: Using_Gtid: Slave_Pos Gtid_IO_Pos: 201-1-2288 Replicate_Do_Domain_Ids: Replicate_Ignore_Domain_Ids: Parallel_Mode: optimistic SQL_Delay: 0 SQL_Remaining_Delay: NULL Slave_SQL_Running_State: Waiting for room in worker thread event queue Slave_DDL_Groups: 0 Slave_Non_Transactional_Groups: 841 Slave_Transactional_Groups: 0 sleep(10) 0 Id User Host db Command Time State Info Progress 11 root localhost NULL Sleep 258 NULL 0.000 16 system user NULL Slave_IO 561 Waiting for master to send event NULL 0.000 18 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 19 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 20 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 21 system user NULL Slave_worker 0 closing tables NULL 0.000 17 system user NULL Slave_SQL 275 Waiting for room in worker thread event queue NULL 0.000 32 root localhost NULL Sleep 4 NULL 0.000 44 root localhost NULL Query 0 starting show full processlist 0.000 *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: 172.31.71.127 Master_User: repl Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.000003 Read_Master_Log_Pos: 251617453 Relay_Log_File: ip-172-31-64-255-relay-bin.000005 Relay_Log_Pos: 313738131 Relay_Master_Log_File: mysql-bin.000002 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: 313737996 Relay_Log_Space: 1325429538 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: 56 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: 1 Master_SSL_Crl: Master_SSL_Crlpath: Using_Gtid: Slave_Pos Gtid_IO_Pos: 201-1-2946 Replicate_Do_Domain_Ids: Replicate_Ignore_Domain_Ids: Parallel_Mode: optimistic SQL_Delay: 0 SQL_Remaining_Delay: NULL Slave_SQL_Running_State: Waiting for room in worker thread event queue Slave_DDL_Groups: 0 Slave_Non_Transactional_Groups: 992 Slave_Transactional_Groups: 0 sleep(10) 0 Id User Host db Command Time State Info Progress 11 root localhost NULL Sleep 276 NULL 0.000 16 system user NULL Slave_IO 579 Waiting for master to send event NULL 0.000 18 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 19 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 20 system user NULL Slave_worker 0 closing tables NULL 0.000 21 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 17 system user NULL Slave_SQL 293 Waiting for room in worker thread event queue NULL 0.000 32 root localhost NULL Sleep 11 NULL 0.000 47 root localhost NULL Query 0 starting show full processlist 0.000 *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: 172.31.71.127 Master_User: repl Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.000003 Read_Master_Log_Pos: 538213526 Relay_Log_File: ip-172-31-64-255-relay-bin.000005 Relay_Log_Pos: 397264702 Relay_Master_Log_File: mysql-bin.000002 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: 397264567 Relay_Log_Space: 1612025611 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: 71 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: 1 Master_SSL_Crl: Master_SSL_Crlpath: Using_Gtid: Slave_Pos Gtid_IO_Pos: 201-1-3499 Replicate_Do_Domain_Ids: Replicate_Ignore_Domain_Ids: Parallel_Mode: optimistic SQL_Delay: 0 SQL_Remaining_Delay: NULL Slave_SQL_Running_State: Waiting for room in worker thread event queue Slave_DDL_Groups: 0 Slave_Non_Transactional_Groups: 1152 Slave_Transactional_Groups: 0 sleep(10) 0 Id User Host db Command Time State Info Progress 11 root localhost NULL Sleep 295 NULL 0.000 16 system user NULL Slave_IO 598 Waiting for master to send event NULL 0.000 18 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 19 system user NULL Slave_worker 0 closing tables NULL 0.000 20 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 21 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 17 system user NULL Slave_SQL 312 Waiting for room in worker thread event queue NULL 0.000 32 root localhost NULL Sleep 15 NULL 0.000 51 root localhost NULL Query 0 starting show full processlist 0.000 *************************** 1. row *************************** Slave_IO_State: Queueing master event to the relay log Master_Host: 172.31.71.127 Master_User: repl Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.000003 Read_Master_Log_Pos: 777062100 Relay_Log_File: ip-172-31-64-255-relay-bin.000005 Relay_Log_Pos: 479221697 Relay_Master_Log_File: mysql-bin.000002 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: 479221562 Relay_Log_Space: 1850874185 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: 83 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: 1 Master_SSL_Crl: Master_SSL_Crlpath: Using_Gtid: Slave_Pos Gtid_IO_Pos: 201-1-3956 Replicate_Do_Domain_Ids: Replicate_Ignore_Domain_Ids: Parallel_Mode: optimistic SQL_Delay: 0 SQL_Remaining_Delay: NULL Slave_SQL_Running_State: Waiting for room in worker thread event queue Slave_DDL_Groups: 0 Slave_Non_Transactional_Groups: 1309 Slave_Transactional_Groups: 0 sleep(10) 0 Id User Host db Command Time State Info Progress 11 root localhost NULL Sleep 314 NULL 0.000 16 system user NULL Slave_IO 616 Waiting for master to send event NULL 0.000 18 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 19 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 20 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 21 system user NULL Slave_worker 0 closing tables NULL 0.000 17 system user NULL Slave_SQL 331 Waiting for room in worker thread event queue NULL 0.000 32 root localhost NULL Sleep 11 NULL 0.000 54 root localhost NULL Query 0 starting show full processlist 0.000 *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: 172.31.71.127 Master_User: repl Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.000003 Read_Master_Log_Pos: 875195017 Relay_Log_File: ip-172-31-64-255-relay-bin.000005 Relay_Log_Pos: 570576114 Relay_Master_Log_File: mysql-bin.000002 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: 570575979 Relay_Log_Space: 1949006382 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: 100 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: 1 Master_SSL_Crl: Master_SSL_Crlpath: Using_Gtid: Slave_Pos Gtid_IO_Pos: 201-1-5729 Replicate_Do_Domain_Ids: Replicate_Ignore_Domain_Ids: Parallel_Mode: optimistic SQL_Delay: 0 SQL_Remaining_Delay: NULL Slave_SQL_Running_State: Waiting for room in worker thread event queue Slave_DDL_Groups: 0 Slave_Non_Transactional_Groups: 1484 Slave_Transactional_Groups: 0 sleep(10) 0 Id User Host db Command Time State Info Progress 11 root localhost NULL Sleep 335 NULL 0.000 16 system user NULL Slave_IO 638 Waiting for master to send event NULL 0.000 18 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 19 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 20 system user NULL Slave_worker 0 closing tables NULL 0.000 21 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 17 system user NULL Slave_SQL 17 Waiting for room in worker thread event queue NULL 0.000 32 root localhost NULL Sleep 1 NULL 0.000 58 root localhost NULL Query 0 starting show full processlist 0.000 *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: 172.31.71.127 Master_User: repl Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.000003 Read_Master_Log_Pos: 878788971 Relay_Log_File: ip-172-31-64-255-relay-bin.000005 Relay_Log_Pos: 638960105 Relay_Master_Log_File: mysql-bin.000002 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: 638959970 Relay_Log_Space: 1952600336 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: 113 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: 1 Master_SSL_Crl: Master_SSL_Crlpath: Using_Gtid: Slave_Pos Gtid_IO_Pos: 201-1-16362 Replicate_Do_Domain_Ids: Replicate_Ignore_Domain_Ids: Parallel_Mode: optimistic SQL_Delay: 0 SQL_Remaining_Delay: NULL Slave_SQL_Running_State: Waiting for room in worker thread event queue Slave_DDL_Groups: 0 Slave_Non_Transactional_Groups: 1615 Slave_Transactional_Groups: 0 sleep(10) 0 Id User Host db Command Time State Info Progress 11 root localhost NULL Sleep 351 NULL 0.000 16 system user NULL Slave_IO 653 Waiting for master to send event NULL 0.000 18 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 19 system user NULL Slave_worker 0 closing tables NULL 0.000 20 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 21 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 17 system user NULL Slave_SQL 32 Waiting for room in worker thread event queue NULL 0.000 32 root localhost NULL Sleep 6 NULL 0.000 61 root localhost NULL Query 0 starting show full processlist 0.000 *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: 172.31.71.127 Master_User: repl Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.000003 Read_Master_Log_Pos: 886734337 Relay_Log_File: ip-172-31-64-255-relay-bin.000005 Relay_Log_Pos: 764768838 Relay_Master_Log_File: mysql-bin.000002 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: 764768703 Relay_Log_Space: 1960545702 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: 136 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: 1 Master_SSL_Crl: Master_SSL_Crlpath: Using_Gtid: Slave_Pos Gtid_IO_Pos: 201-1-39869 Replicate_Do_Domain_Ids: Replicate_Ignore_Domain_Ids: Parallel_Mode: optimistic SQL_Delay: 0 SQL_Remaining_Delay: NULL Slave_SQL_Running_State: Waiting for room in worker thread event queue Slave_DDL_Groups: 0 Slave_Non_Transactional_Groups: 1856 Slave_Transactional_Groups: 0 sleep(10) 0 Id User Host db Command Time State Info Progress 11 root localhost NULL Sleep 379 NULL 0.000 16 system user NULL Slave_IO 682 Waiting for master to send event NULL 0.000 18 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 19 system user sbtest Slave_worker 0 creating table CREATE TABLE sbtest4(\n id INTEGER NOT NULL AUTO_INCREMENT,\n k INTEGER DEFAULT '0' NOT NULL,\n c CHAR(120) DEFAULT '' NOT NULL,\n pad CHAR(60) DEFAULT '' NOT NULL,\n PRIMARY KEY (id)\n) /*! ENGINE = innodb */ 0.000 20 system user NULL Slave_worker 6 Waiting for prior transaction to commit NULL 0.000 21 system user NULL Slave_worker 3 Waiting for prior transaction to commit NULL 0.000 17 system user NULL Slave_SQL 61 Waiting for room in worker thread event queue NULL 0.000 32 root localhost NULL Sleep 3 NULL 0.000 66 root localhost NULL Query 0 starting show full processlist 0.000 *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: 172.31.71.127 Master_User: repl Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.000003 Read_Master_Log_Pos: 892449917 Relay_Log_File: ip-172-31-64-255-relay-bin.000005 Relay_Log_Pos: 830023873 Relay_Master_Log_File: mysql-bin.000002 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: 830023738 Relay_Log_Space: 1966261282 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: 149 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: 1 Master_SSL_Crl: Master_SSL_Crlpath: Using_Gtid: Slave_Pos Gtid_IO_Pos: 201-1-56779 Replicate_Do_Domain_Ids: Replicate_Ignore_Domain_Ids: Parallel_Mode: optimistic SQL_Delay: 0 SQL_Remaining_Delay: NULL Slave_SQL_Running_State: Waiting for room in worker thread event queue Slave_DDL_Groups: 0 Slave_Non_Transactional_Groups: 1986 Slave_Transactional_Groups: 0 sleep(10) 0 Id User Host db Command Time State Info Progress 11 root localhost NULL Sleep 401 NULL 0.000 16 system user NULL Slave_IO 704 Waiting for master to send event NULL 0.000 18 system user NULL Slave_worker 0 closing tables NULL 0.000 19 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 20 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 21 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 17 system user NULL Slave_SQL 83 Waiting for room in worker thread event queue NULL 0.000 32 root localhost NULL Sleep 0 NULL 0.000 69 root localhost NULL Query 0 starting show full processlist 0.000 *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: 172.31.71.127 Master_User: repl Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.000003 Read_Master_Log_Pos: 899688525 Relay_Log_File: ip-172-31-64-255-relay-bin.000005 Relay_Log_Pos: 948001547 Relay_Master_Log_File: mysql-bin.000002 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: 948001412 Relay_Log_Space: 1973499890 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: 171 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: 1 Master_SSL_Crl: Master_SSL_Crlpath: Using_Gtid: Slave_Pos Gtid_IO_Pos: 201-1-78195 Replicate_Do_Domain_Ids: Replicate_Ignore_Domain_Ids: Parallel_Mode: optimistic SQL_Delay: 0 SQL_Remaining_Delay: NULL Slave_SQL_Running_State: Waiting for room in worker thread event queue Slave_DDL_Groups: 0 Slave_Non_Transactional_Groups: 2212 Slave_Transactional_Groups: 0 sleep(10) 0 Id User Host db Command Time State Info Progress 11 root localhost NULL Sleep 428 NULL 0.000 16 system user NULL Slave_IO 730 Waiting for master to send event NULL 0.000 18 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 19 system user NULL Slave_worker 0 closing tables NULL 0.000 20 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 21 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 17 system user NULL Slave_SQL 110 Waiting for room in worker thread event queue NULL 0.000 32 root localhost NULL Sleep 3 NULL 0.000 73 root localhost NULL Query 0 starting show full processlist 0.000 *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: 172.31.71.127 Master_User: repl Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.000003 Read_Master_Log_Pos: 900981713 Relay_Log_File: ip-172-31-64-255-relay-bin.000008 Relay_Log_Pos: 16183828 Relay_Master_Log_File: mysql-bin.000003 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: 16183533 Relay_Log_Space: 1974793078 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: 193 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: 1 Master_SSL_Crl: Master_SSL_Crlpath: Using_Gtid: Slave_Pos Gtid_IO_Pos: 201-1-82021 Replicate_Do_Domain_Ids: Replicate_Ignore_Domain_Ids: Parallel_Mode: optimistic SQL_Delay: 0 SQL_Remaining_Delay: NULL Slave_SQL_Running_State: Waiting for room in worker thread event queue Slave_DDL_Groups: 0 Slave_Non_Transactional_Groups: 2484 Slave_Transactional_Groups: 0 sleep(10) 0 Id User Host db Command Time State Info Progress 11 root localhost NULL Sleep 460 NULL 0.000 16 system user NULL Slave_IO 763 Waiting for master to send event NULL 0.000 18 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 19 system user NULL Slave_worker 0 closing tables NULL 0.000 20 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 21 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 17 system user NULL Slave_SQL 142 Waiting for room in worker thread event queue NULL 0.000 32 root localhost NULL Sleep 0 NULL 0.000 78 root localhost NULL Query 0 starting show full processlist 0.000 *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: 172.31.71.127 Master_User: repl Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.000003 Read_Master_Log_Pos: 900981713 Relay_Log_File: ip-172-31-64-255-relay-bin.000008 Relay_Log_Pos: 101795166 Relay_Master_Log_File: mysql-bin.000003 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: 101794871 Relay_Log_Space: 1974793078 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: 210 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: 1 Master_SSL_Crl: Master_SSL_Crlpath: Using_Gtid: Slave_Pos Gtid_IO_Pos: 201-1-82021 Replicate_Do_Domain_Ids: Replicate_Ignore_Domain_Ids: Parallel_Mode: optimistic SQL_Delay: 0 SQL_Remaining_Delay: NULL Slave_SQL_Running_State: Waiting for room in worker thread event queue Slave_DDL_Groups: 0 Slave_Non_Transactional_Groups: 2648 Slave_Transactional_Groups: 0 sleep(10) 0 Id User Host db Command Time State Info Progress 11 root localhost NULL Sleep 480 NULL 0.000 16 system user NULL Slave_IO 782 Waiting for master to send event NULL 0.000 18 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 19 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 20 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 21 system user NULL Slave_worker 0 closing tables NULL 0.000 17 system user NULL Slave_SQL 162 Waiting for room in worker thread event queue NULL 0.000 32 root localhost NULL Sleep 2 NULL 0.000 82 root localhost NULL Query 0 starting show full processlist 0.000 *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: 172.31.71.127 Master_User: repl Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.000003 Read_Master_Log_Pos: 900981713 Relay_Log_File: ip-172-31-64-255-relay-bin.000008 Relay_Log_Pos: 156087560 Relay_Master_Log_File: mysql-bin.000003 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: 156087265 Relay_Log_Space: 1974793078 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: 220 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: 1 Master_SSL_Crl: Master_SSL_Crlpath: Using_Gtid: Slave_Pos Gtid_IO_Pos: 201-1-82021 Replicate_Do_Domain_Ids: Replicate_Ignore_Domain_Ids: Parallel_Mode: optimistic SQL_Delay: 0 SQL_Remaining_Delay: NULL Slave_SQL_Running_State: Waiting for room in worker thread event queue Slave_DDL_Groups: 0 Slave_Non_Transactional_Groups: 2752 Slave_Transactional_Groups: 0 sleep(10) 0 Id User Host db Command Time State Info Progress 11 root localhost NULL Sleep 492 NULL 0.000 16 system user NULL Slave_IO 795 Waiting for master to send event NULL 0.000 18 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 19 system user NULL Slave_worker 0 closing tables NULL 0.000 20 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 21 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 17 system user NULL Slave_SQL 174 Waiting for room in worker thread event queue NULL 0.000 32 root localhost NULL Sleep 2 NULL 0.000 85 root localhost NULL Query 0 starting show full processlist 0.000 *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: 172.31.71.127 Master_User: repl Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.000003 Read_Master_Log_Pos: 900981713 Relay_Log_File: ip-172-31-64-255-relay-bin.000008 Relay_Log_Pos: 208290462 Relay_Master_Log_File: mysql-bin.000003 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: 208290167 Relay_Log_Space: 1974793078 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: 229 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: 1 Master_SSL_Crl: Master_SSL_Crlpath: Using_Gtid: Slave_Pos Gtid_IO_Pos: 201-1-82021 Replicate_Do_Domain_Ids: Replicate_Ignore_Domain_Ids: Parallel_Mode: optimistic SQL_Delay: 0 SQL_Remaining_Delay: NULL Slave_SQL_Running_State: Waiting for room in worker thread event queue Slave_DDL_Groups: 0 Slave_Non_Transactional_Groups: 2852 Slave_Transactional_Groups: 0 sleep(10) 0 Id User Host db Command Time State Info Progress 11 root localhost NULL Sleep 504 NULL 0.000 16 system user NULL Slave_IO 807 Waiting for master to send event NULL 0.000 18 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 19 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 20 system user NULL Slave_worker 0 closing tables NULL 0.000 21 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 17 system user NULL Slave_SQL 186 Waiting for room in worker thread event queue NULL 0.000 32 root localhost NULL Sleep 4 NULL 0.000 87 root localhost NULL Query 0 starting show full processlist 0.000 *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: 172.31.71.127 Master_User: repl Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.000003 Read_Master_Log_Pos: 900981713 Relay_Log_File: ip-172-31-64-255-relay-bin.000008 Relay_Log_Pos: 327310803 Relay_Master_Log_File: mysql-bin.000003 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: 327310508 Relay_Log_Space: 1974793078 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: 251 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: 1 Master_SSL_Crl: Master_SSL_Crlpath: Using_Gtid: Slave_Pos Gtid_IO_Pos: 201-1-82021 Replicate_Do_Domain_Ids: Replicate_Ignore_Domain_Ids: Parallel_Mode: optimistic SQL_Delay: 0 SQL_Remaining_Delay: NULL Slave_SQL_Running_State: Waiting for room in worker thread event queue Slave_DDL_Groups: 0 Slave_Non_Transactional_Groups: 3080 Slave_Transactional_Groups: 0 sleep(10) 0 Id User Host db Command Time State Info Progress 11 root localhost NULL Sleep 531 NULL 0.000 16 system user NULL Slave_IO 834 Waiting for master to send event NULL 0.000 18 system user NULL Slave_worker 0 Write_rows_log_event::write_row(-1) NULL 0.000 19 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 20 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 21 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 17 system user NULL Slave_SQL 213 Slave has read all relay log; waiting for more updates NULL 0.000 32 root localhost NULL Sleep 12 NULL 0.000 92 root localhost NULL Query 0 starting show full processlist 0.000 *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: 172.31.71.127 Master_User: repl Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.000003 Read_Master_Log_Pos: 900981713 Relay_Log_File: ip-172-31-64-255-relay-bin.000008 Relay_Log_Pos: 395696873 Relay_Master_Log_File: mysql-bin.000003 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: 395696578 Relay_Log_Space: 1974793078 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: 265 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: 1 Master_SSL_Crl: Master_SSL_Crlpath: Using_Gtid: Slave_Pos Gtid_IO_Pos: 201-1-82021 Replicate_Do_Domain_Ids: Replicate_Ignore_Domain_Ids: Parallel_Mode: optimistic SQL_Delay: 0 SQL_Remaining_Delay: NULL Slave_SQL_Running_State: Slave has read all relay log; waiting for more updates Slave_DDL_Groups: 0 Slave_Non_Transactional_Groups: 3211 Slave_Transactional_Groups: 0 sleep(10) 0 Id User Host db Command Time State Info Progress 11 root localhost NULL Sleep 547 NULL 0.000 16 system user NULL Slave_IO 849 Waiting for master to send event NULL 0.000 18 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 19 system user NULL Slave_worker 0 closing tables NULL 0.000 20 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 21 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 17 system user NULL Slave_SQL 229 Slave has read all relay log; waiting for more updates NULL 0.000 32 root localhost NULL Sleep 12 NULL 0.000 95 root localhost NULL Query 0 starting show full processlist 0.000 *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: 172.31.71.127 Master_User: repl Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.000003 Read_Master_Log_Pos: 900981713 Relay_Log_File: ip-172-31-64-255-relay-bin.000008 Relay_Log_Pos: 532471498 Relay_Master_Log_File: mysql-bin.000003 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: 532471203 Relay_Log_Space: 1974793078 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: 290 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: 1 Master_SSL_Crl: Master_SSL_Crlpath: Using_Gtid: Slave_Pos Gtid_IO_Pos: 201-1-82021 Replicate_Do_Domain_Ids: Replicate_Ignore_Domain_Ids: Parallel_Mode: optimistic SQL_Delay: 0 SQL_Remaining_Delay: NULL Slave_SQL_Running_State: Slave has read all relay log; waiting for more updates Slave_DDL_Groups: 0 Slave_Non_Transactional_Groups: 3477 Slave_Transactional_Groups: 0 sleep(10) 0 Id User Host db Command Time State Info Progress 11 root localhost NULL Sleep 585 NULL 0.000 16 system user NULL Slave_IO 887 Waiting for master to send event NULL 0.000 18 system user NULL Slave_worker 0 Write_rows_log_event::write_row(-1) NULL 0.000 19 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 20 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 21 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 17 system user NULL Slave_SQL 267 Slave has read all relay log; waiting for more updates NULL 0.000 32 root localhost NULL Sleep 2 NULL 0.000 100 root localhost NULL Query 0 starting show full processlist 0.000 *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: 172.31.71.127 Master_User: repl Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.000003 Read_Master_Log_Pos: 900981713 Relay_Log_File: ip-172-31-64-255-relay-bin.000008 Relay_Log_Pos: 600336140 Relay_Master_Log_File: mysql-bin.000003 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: 600335845 Relay_Log_Space: 1974793078 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: 301 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: 1 Master_SSL_Crl: Master_SSL_Crlpath: Using_Gtid: Slave_Pos Gtid_IO_Pos: 201-1-82021 Replicate_Do_Domain_Ids: Replicate_Ignore_Domain_Ids: Parallel_Mode: optimistic SQL_Delay: 0 SQL_Remaining_Delay: NULL Slave_SQL_Running_State: Slave has read all relay log; waiting for more updates Slave_DDL_Groups: 0 Slave_Non_Transactional_Groups: 3607 Slave_Transactional_Groups: 0 sleep(10) 0 Id User Host db Command Time State Info Progress 11 root localhost NULL Sleep 600 NULL 0.000 16 system user NULL Slave_IO 903 Waiting for master to send event NULL 0.000 18 system user NULL Slave_worker 0 closing tables NULL 0.000 19 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 20 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 21 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 17 system user NULL Slave_SQL 282 Slave has read all relay log; waiting for more updates NULL 0.000 32 root localhost NULL Sleep 5 NULL 0.000 103 root localhost NULL Query 0 starting show full processlist 0.000 *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: 172.31.71.127 Master_User: repl Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.000003 Read_Master_Log_Pos: 900981713 Relay_Log_File: ip-172-31-64-255-relay-bin.000008 Relay_Log_Pos: 749637105 Relay_Master_Log_File: mysql-bin.000003 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: 749636810 Relay_Log_Space: 1974793078 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: 323 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: 1 Master_SSL_Crl: Master_SSL_Crlpath: Using_Gtid: Slave_Pos Gtid_IO_Pos: 201-1-82021 Replicate_Do_Domain_Ids: Replicate_Ignore_Domain_Ids: Parallel_Mode: optimistic SQL_Delay: 0 SQL_Remaining_Delay: NULL Slave_SQL_Running_State: Slave has read all relay log; waiting for more updates Slave_DDL_Groups: 0 Slave_Non_Transactional_Groups: 3893 Slave_Transactional_Groups: 0 sleep(10) 0 Id User Host db Command Time State Info Progress 11 root localhost NULL Sleep 635 NULL 0.000 16 system user NULL Slave_IO 937 Waiting for master to send event NULL 0.000 18 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 19 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 20 system user NULL Slave_worker 0 closing tables NULL 0.000 21 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 17 system user NULL Slave_SQL 316 Slave has read all relay log; waiting for more updates NULL 0.000 32 root localhost NULL Sleep 5 NULL 0.000 108 root localhost NULL Query 0 starting show full processlist 0.000 *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: 172.31.71.127 Master_User: repl Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.000003 Read_Master_Log_Pos: 900981713 Relay_Log_File: ip-172-31-64-255-relay-bin.000008 Relay_Log_Pos: 874748814 Relay_Master_Log_File: mysql-bin.000003 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: 874748519 Relay_Log_Space: 1974793078 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: 360 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: 1 Master_SSL_Crl: Master_SSL_Crlpath: Using_Gtid: Slave_Pos Gtid_IO_Pos: 201-1-82021 Replicate_Do_Domain_Ids: Replicate_Ignore_Domain_Ids: Parallel_Mode: optimistic SQL_Delay: 0 SQL_Remaining_Delay: NULL Slave_SQL_Running_State: Slave has read all relay log; waiting for more updates Slave_DDL_Groups: 0 Slave_Non_Transactional_Groups: 4397 Slave_Transactional_Groups: 0 sleep(10) 0 Id User Host db Command Time State Info Progress 11 root localhost NULL Sleep 693 NULL 0.000 16 system user NULL Slave_IO 996 Waiting for master to send event NULL 0.000 18 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 19 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 20 system user NULL Slave_worker 0 closing tables NULL 0.000 21 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 17 system user NULL Slave_SQL 375 Slave has read all relay log; waiting for more updates NULL 0.000 32 root localhost NULL Sleep 13 NULL 0.000 117 root localhost NULL Query 0 starting show full processlist 0.000 *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: 172.31.71.127 Master_User: repl Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.000003 Read_Master_Log_Pos: 900981713 Relay_Log_File: ip-172-31-64-255-relay-bin.000008 Relay_Log_Pos: 874886042 Relay_Master_Log_File: mysql-bin.000003 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: 874885747 Relay_Log_Space: 1974793078 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: 401 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: 1 Master_SSL_Crl: Master_SSL_Crlpath: Using_Gtid: Slave_Pos Gtid_IO_Pos: 201-1-82021 Replicate_Do_Domain_Ids: Replicate_Ignore_Domain_Ids: Parallel_Mode: optimistic SQL_Delay: 0 SQL_Remaining_Delay: NULL Slave_SQL_Running_State: Slave has read all relay log; waiting for more updates Slave_DDL_Groups: 0 Slave_Non_Transactional_Groups: 4803 Slave_Transactional_Groups: 0 sleep(10) 0 Id User Host db Command Time State Info Progress 11 root localhost NULL Sleep 735 NULL 0.000 16 system user NULL Slave_IO 1037 Waiting for master to send event NULL 0.000 18 system user NULL Slave_worker 0 closing tables NULL 0.000 19 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 20 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 21 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 17 system user NULL Slave_SQL 416 Slave has read all relay log; waiting for more updates NULL 0.000 32 root localhost NULL Sleep 5 NULL 0.000 125 root localhost NULL Query 0 starting show full processlist 0.000 *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: 172.31.71.127 Master_User: repl Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.000003 Read_Master_Log_Pos: 900981713 Relay_Log_File: ip-172-31-64-255-relay-bin.000008 Relay_Log_Pos: 875014482 Relay_Master_Log_File: mysql-bin.000003 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: 875014187 Relay_Log_Space: 1974793078 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: 439 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: 1 Master_SSL_Crl: Master_SSL_Crlpath: Using_Gtid: Slave_Pos Gtid_IO_Pos: 201-1-82021 Replicate_Do_Domain_Ids: Replicate_Ignore_Domain_Ids: Parallel_Mode: optimistic SQL_Delay: 0 SQL_Remaining_Delay: NULL Slave_SQL_Running_State: Slave has read all relay log; waiting for more updates Slave_DDL_Groups: 0 Slave_Non_Transactional_Groups: 5183 Slave_Transactional_Groups: 0 sleep(10) 0 Id User Host db Command Time State Info Progress 11 root localhost NULL Sleep 773 NULL 0.000 16 system user NULL Slave_IO 1076 Waiting for master to send event NULL 0.000 18 system user NULL Slave_worker 0 closing tables NULL 0.000 19 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 20 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 21 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 17 system user NULL Slave_SQL 455 Slave has read all relay log; waiting for more updates NULL 0.000 32 root localhost NULL Sleep 13 NULL 0.000 132 root localhost NULL Query 0 starting show full processlist 0.000 *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: 172.31.71.127 Master_User: repl Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.000003 Read_Master_Log_Pos: 900981713 Relay_Log_File: ip-172-31-64-255-relay-bin.000008 Relay_Log_Pos: 875122642 Relay_Master_Log_File: mysql-bin.000003 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: 875122347 Relay_Log_Space: 1974793078 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: 471 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: 1 Master_SSL_Crl: Master_SSL_Crlpath: Using_Gtid: Slave_Pos Gtid_IO_Pos: 201-1-82021 Replicate_Do_Domain_Ids: Replicate_Ignore_Domain_Ids: Parallel_Mode: optimistic SQL_Delay: 0 SQL_Remaining_Delay: NULL Slave_SQL_Running_State: Slave has read all relay log; waiting for more updates Slave_DDL_Groups: 0 Slave_Non_Transactional_Groups: 5503 Slave_Transactional_Groups: 0 sleep(10) 0 Id User Host db Command Time State Info Progress 11 root localhost NULL Sleep 806 NULL 0.000 16 system user NULL Slave_IO 1108 Waiting for master to send event NULL 0.000 18 system user NULL Slave_worker 0 closing tables NULL 0.000 19 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 20 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 21 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 17 system user NULL Slave_SQL 487 Slave has read all relay log; waiting for more updates NULL 0.000 32 root localhost NULL Sleep 6 NULL 0.000 138 root localhost NULL Query 0 starting show full processlist 0.000 *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: 172.31.71.127 Master_User: repl Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.000003 Read_Master_Log_Pos: 900981713 Relay_Log_File: ip-172-31-64-255-relay-bin.000008 Relay_Log_Pos: 875235196 Relay_Master_Log_File: mysql-bin.000003 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: 875234901 Relay_Log_Space: 1974793078 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: 504 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: 1 Master_SSL_Crl: Master_SSL_Crlpath: Using_Gtid: Slave_Pos Gtid_IO_Pos: 201-1-82021 Replicate_Do_Domain_Ids: Replicate_Ignore_Domain_Ids: Parallel_Mode: optimistic SQL_Delay: 0 SQL_Remaining_Delay: NULL Slave_SQL_Running_State: Slave has read all relay log; waiting for more updates Slave_DDL_Groups: 0 Slave_Non_Transactional_Groups: 5836 Slave_Transactional_Groups: 0 sleep(10) 0 Id User Host db Command Time State Info Progress 11 root localhost NULL Sleep 839 NULL 0.000 16 system user NULL Slave_IO 1142 Waiting for master to send event NULL 0.000 18 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 19 system user NULL Slave_worker 0 closing tables NULL 0.000 20 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 21 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 17 system user NULL Slave_SQL 521 Slave has read all relay log; waiting for more updates NULL 0.000 32 root localhost NULL Sleep 1 NULL 0.000 144 root localhost NULL Query 0 starting show full processlist 0.000 *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: 172.31.71.127 Master_User: repl Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.000003 Read_Master_Log_Pos: 900981713 Relay_Log_File: ip-172-31-64-255-relay-bin.000008 Relay_Log_Pos: 875285558 Relay_Master_Log_File: mysql-bin.000003 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: 875285263 Relay_Log_Space: 1974793078 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: 519 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: 1 Master_SSL_Crl: Master_SSL_Crlpath: Using_Gtid: Slave_Pos Gtid_IO_Pos: 201-1-82021 Replicate_Do_Domain_Ids: Replicate_Ignore_Domain_Ids: Parallel_Mode: optimistic SQL_Delay: 0 SQL_Remaining_Delay: NULL Slave_SQL_Running_State: Slave has read all relay log; waiting for more updates Slave_DDL_Groups: 0 Slave_Non_Transactional_Groups: 5985 Slave_Transactional_Groups: 0 sleep(10) 0 Id User Host db Command Time State Info Progress 11 root localhost NULL Sleep 854 NULL 0.000 16 system user NULL Slave_IO 1157 Waiting for master to send event NULL 0.000 18 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 19 system user NULL Slave_worker 0 closing tables NULL 0.000 20 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 21 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 17 system user NULL Slave_SQL 536 Slave has read all relay log; waiting for more updates NULL 0.000 32 root localhost NULL Sleep 1 NULL 0.000 147 root localhost NULL Query 0 starting show full processlist 0.000 *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: 172.31.71.127 Master_User: repl Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.000003 Read_Master_Log_Pos: 900981713 Relay_Log_File: ip-172-31-64-255-relay-bin.000008 Relay_Log_Pos: 875455234 Relay_Master_Log_File: mysql-bin.000003 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: 875454939 Relay_Log_Space: 1974793078 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: 569 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: 1 Master_SSL_Crl: Master_SSL_Crlpath: Using_Gtid: Slave_Pos Gtid_IO_Pos: 201-1-82021 Replicate_Do_Domain_Ids: Replicate_Ignore_Domain_Ids: Parallel_Mode: optimistic SQL_Delay: 0 SQL_Remaining_Delay: NULL Slave_SQL_Running_State: Slave has read all relay log; waiting for more updates Slave_DDL_Groups: 0 Slave_Non_Transactional_Groups: 6487 Slave_Transactional_Groups: 0 sleep(10) 0 Id User Host db Command Time State Info Progress 11 root localhost NULL Sleep 905 NULL 0.000 16 system user NULL Slave_IO 1208 Waiting for master to send event NULL 0.000 18 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 19 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 20 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 21 system user NULL Slave_worker 0 closing tables NULL 0.000 17 system user NULL Slave_SQL 587 Slave has read all relay log; waiting for more updates NULL 0.000 32 root localhost NULL Sleep 2 NULL 0.000 156 root localhost NULL Query 0 starting show full processlist 0.000 *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: 172.31.71.127 Master_User: repl Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.000003 Read_Master_Log_Pos: 900981713 Relay_Log_File: ip-172-31-64-255-relay-bin.000008 Relay_Log_Pos: 875617812 Relay_Master_Log_File: mysql-bin.000003 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: 875617517 Relay_Log_Space: 1974793078 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: 617 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: 1 Master_SSL_Crl: Master_SSL_Crlpath: Using_Gtid: Slave_Pos Gtid_IO_Pos: 201-1-82021 Replicate_Do_Domain_Ids: Replicate_Ignore_Domain_Ids: Parallel_Mode: optimistic SQL_Delay: 0 SQL_Remaining_Delay: NULL Slave_SQL_Running_State: Slave has read all relay log; waiting for more updates Slave_DDL_Groups: 0 Slave_Non_Transactional_Groups: 6968 Slave_Transactional_Groups: 0 sleep(10) 0 Id User Host db Command Time State Info Progress 11 root localhost NULL Sleep 954 NULL 0.000 16 system user NULL Slave_IO 1257 Waiting for master to send event NULL 0.000 18 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 19 system user NULL Slave_worker 0 closing tables NULL 0.000 20 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 21 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 17 system user NULL Slave_SQL 636 Slave has read all relay log; waiting for more updates NULL 0.000 32 root localhost NULL Sleep 6 NULL 0.000 164 root localhost NULL Query 0 starting show full processlist 0.000 *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: 172.31.71.127 Master_User: repl Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.000003 Read_Master_Log_Pos: 900981713 Relay_Log_File: ip-172-31-64-255-relay-bin.000008 Relay_Log_Pos: 875826358 Relay_Master_Log_File: mysql-bin.000003 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: 875826063 Relay_Log_Space: 1974793078 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: 679 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: 1 Master_SSL_Crl: Master_SSL_Crlpath: Using_Gtid: Slave_Pos Gtid_IO_Pos: 201-1-82021 Replicate_Do_Domain_Ids: Replicate_Ignore_Domain_Ids: Parallel_Mode: optimistic SQL_Delay: 0 SQL_Remaining_Delay: NULL Slave_SQL_Running_State: Slave has read all relay log; waiting for more updates Slave_DDL_Groups: 0 Slave_Non_Transactional_Groups: 7585 Slave_Transactional_Groups: 0 sleep(10) 0 Id User Host db Command Time State Info Progress 11 root localhost NULL Sleep 1017 NULL 0.000 16 system user NULL Slave_IO 1319 Waiting for master to send event NULL 0.000 18 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 19 system user NULL Slave_worker 0 closing tables NULL 0.000 20 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 21 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 17 system user NULL Slave_SQL 699 Slave has read all relay log; waiting for more updates NULL 0.000 32 root localhost NULL Sleep 14 NULL 0.000 175 root localhost NULL Query 0 starting show full processlist 0.000 *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: 172.31.71.127 Master_User: repl Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.000003 Read_Master_Log_Pos: 900981713 Relay_Log_File: ip-172-31-64-255-relay-bin.000008 Relay_Log_Pos: 875936546 Relay_Master_Log_File: mysql-bin.000003 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: 875936251 Relay_Log_Space: 1974793078 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: 712 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: 1 Master_SSL_Crl: Master_SSL_Crlpath: Using_Gtid: Slave_Pos Gtid_IO_Pos: 201-1-82021 Replicate_Do_Domain_Ids: Replicate_Ignore_Domain_Ids: Parallel_Mode: optimistic SQL_Delay: 0 SQL_Remaining_Delay: NULL Slave_SQL_Running_State: Slave has read all relay log; waiting for more updates Slave_DDL_Groups: 0 Slave_Non_Transactional_Groups: 7911 Slave_Transactional_Groups: 0 sleep(10) 0 Id User Host db Command Time State Info Progress 11 root localhost NULL Sleep 1050 NULL 0.000 16 system user NULL Slave_IO 1352 Waiting for master to send event NULL 0.000 18 system user NULL Slave_worker 0 closing tables NULL 0.000 19 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 20 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 21 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 17 system user NULL Slave_SQL 732 Slave has read all relay log; waiting for more updates NULL 0.000 32 root localhost NULL Sleep 14 NULL 0.000 181 root localhost NULL Query 0 starting show full processlist 0.000 *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: 172.31.71.127 Master_User: repl Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.000003 Read_Master_Log_Pos: 900981713 Relay_Log_File: ip-172-31-64-255-relay-bin.000008 Relay_Log_Pos: 876027806 Relay_Master_Log_File: mysql-bin.000003 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: 876027511 Relay_Log_Space: 1974793078 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: 738 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: 1 Master_SSL_Crl: Master_SSL_Crlpath: Using_Gtid: Slave_Pos Gtid_IO_Pos: 201-1-82021 Replicate_Do_Domain_Ids: Replicate_Ignore_Domain_Ids: Parallel_Mode: optimistic SQL_Delay: 0 SQL_Remaining_Delay: NULL Slave_SQL_Running_State: Slave has read all relay log; waiting for more updates Slave_DDL_Groups: 0 Slave_Non_Transactional_Groups: 8181 Slave_Transactional_Groups: 0 sleep(10) 0 Id User Host db Command Time State Info Progress 11 root localhost NULL Sleep 1077 NULL 0.000 16 system user NULL Slave_IO 1380 Waiting for master to send event NULL 0.000 18 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 19 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 20 system user NULL Slave_worker 0 closing tables NULL 0.000 21 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 17 system user NULL Slave_SQL 759 Slave has read all relay log; waiting for more updates NULL 0.000 32 root localhost NULL Sleep 7 NULL 0.000 186 root localhost NULL Query 0 starting show full processlist 0.000 *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: 172.31.71.127 Master_User: repl Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.000003 Read_Master_Log_Pos: 900981713 Relay_Log_File: ip-172-31-64-255-relay-bin.000008 Relay_Log_Pos: 876080872 Relay_Master_Log_File: mysql-bin.000003 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: 876080577 Relay_Log_Space: 1974793078 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: 754 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: 1 Master_SSL_Crl: Master_SSL_Crlpath: Using_Gtid: Slave_Pos Gtid_IO_Pos: 201-1-82021 Replicate_Do_Domain_Ids: Replicate_Ignore_Domain_Ids: Parallel_Mode: optimistic SQL_Delay: 0 SQL_Remaining_Delay: NULL Slave_SQL_Running_State: Slave has read all relay log; waiting for more updates Slave_DDL_Groups: 0 Slave_Non_Transactional_Groups: 8338 Slave_Transactional_Groups: 0 sleep(10) 0 Id User Host db Command Time State Info Progress 11 root localhost NULL Sleep 1093 NULL 0.000 16 system user NULL Slave_IO 1396 Waiting for master to send event NULL 0.000 18 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 19 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 20 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 21 system user NULL Slave_worker 0 closing tables NULL 0.000 17 system user NULL Slave_SQL 775 Slave has read all relay log; waiting for more updates NULL 0.000 32 root localhost NULL Sleep 4 NULL 0.000 190 root localhost NULL Query 0 starting show full processlist 0.000 *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: 172.31.71.127 Master_User: repl Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.000003 Read_Master_Log_Pos: 900981713 Relay_Log_File: ip-172-31-64-255-relay-bin.000008 Relay_Log_Pos: 876120418 Relay_Master_Log_File: mysql-bin.000003 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: 876120123 Relay_Log_Space: 1974793078 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: 766 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: 1 Master_SSL_Crl: Master_SSL_Crlpath: Using_Gtid: Slave_Pos Gtid_IO_Pos: 201-1-82021 Replicate_Do_Domain_Ids: Replicate_Ignore_Domain_Ids: Parallel_Mode: optimistic SQL_Delay: 0 SQL_Remaining_Delay: NULL Slave_SQL_Running_State: Slave has read all relay log; waiting for more updates Slave_DDL_Groups: 0 Slave_Non_Transactional_Groups: 8455 Slave_Transactional_Groups: 0 sleep(10) 0 Id User Host db Command Time State Info Progress 11 root localhost NULL Sleep 1105 NULL 0.000 16 system user NULL Slave_IO 1408 Waiting for master to send event NULL 0.000 18 system user NULL Slave_worker 0 closing tables NULL 0.000 19 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 20 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 21 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 17 system user NULL Slave_SQL 787 Slave has read all relay log; waiting for more updates NULL 0.000 32 root localhost NULL Sleep 0 NULL 0.000 193 root localhost NULL Query 0 starting show full processlist 0.000 *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: 172.31.71.127 Master_User: repl Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.000003 Read_Master_Log_Pos: 900981713 Relay_Log_File: ip-172-31-64-255-relay-bin.000008 Relay_Log_Pos: 876165034 Relay_Master_Log_File: mysql-bin.000003 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: 876164739 Relay_Log_Space: 1974793078 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: 779 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: 1 Master_SSL_Crl: Master_SSL_Crlpath: Using_Gtid: Slave_Pos Gtid_IO_Pos: 201-1-82021 Replicate_Do_Domain_Ids: Replicate_Ignore_Domain_Ids: Parallel_Mode: optimistic SQL_Delay: 0 SQL_Remaining_Delay: NULL Slave_SQL_Running_State: Slave has read all relay log; waiting for more updates Slave_DDL_Groups: 0 Slave_Non_Transactional_Groups: 8587 Slave_Transactional_Groups: 0 sleep(10) 0 Id User Host db Command Time State Info Progress 11 root localhost NULL Sleep 1118 NULL 0.000 16 system user NULL Slave_IO 1421 Waiting for master to send event NULL 0.000 18 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 19 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 20 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 21 system user NULL Slave_worker 0 closing tables NULL 0.000 17 system user NULL Slave_SQL 800 Slave has read all relay log; waiting for more updates NULL 0.000 32 root localhost NULL Sleep 1 NULL 0.000 196 root localhost NULL Query 0 starting show full processlist 0.000 *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: 172.31.71.127 Master_User: repl Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.000003 Read_Master_Log_Pos: 900981713 Relay_Log_File: ip-172-31-64-255-relay-bin.000008 Relay_Log_Pos: 876447264 Relay_Master_Log_File: mysql-bin.000003 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: 876446969 Relay_Log_Space: 1974793078 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: 862 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: 1 Master_SSL_Crl: Master_SSL_Crlpath: Using_Gtid: Slave_Pos Gtid_IO_Pos: 201-1-82021 Replicate_Do_Domain_Ids: Replicate_Ignore_Domain_Ids: Parallel_Mode: optimistic SQL_Delay: 0 SQL_Remaining_Delay: NULL Slave_SQL_Running_State: Slave has read all relay log; waiting for more updates Slave_DDL_Groups: 0 Slave_Non_Transactional_Groups: 9422 Slave_Transactional_Groups: 0 sleep(10) 0 Id User Host db Command Time State Info Progress 11 root localhost NULL Sleep 1203 NULL 0.000 16 system user NULL Slave_IO 1506 Waiting for master to send event NULL 0.000 18 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 19 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 20 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 21 system user NULL Slave_worker 0 closing tables NULL 0.000 17 system user NULL Slave_SQL 885 Slave has read all relay log; waiting for more updates NULL 0.000 32 root localhost NULL Sleep 2 NULL 0.000 210 root localhost NULL Query 0 starting show full processlist 0.000 *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: 172.31.71.127 Master_User: repl Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.000003 Read_Master_Log_Pos: 900981713 Relay_Log_File: ip-172-31-64-255-relay-bin.000008 Relay_Log_Pos: 876575704 Relay_Master_Log_File: mysql-bin.000003 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: 876575409 Relay_Log_Space: 1974793078 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: 900 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: 1 Master_SSL_Crl: Master_SSL_Crlpath: Using_Gtid: Slave_Pos Gtid_IO_Pos: 201-1-82021 Replicate_Do_Domain_Ids: Replicate_Ignore_Domain_Ids: Parallel_Mode: optimistic SQL_Delay: 0 SQL_Remaining_Delay: NULL Slave_SQL_Running_State: Slave has read all relay log; waiting for more updates Slave_DDL_Groups: 0 Slave_Non_Transactional_Groups: 9802 Slave_Transactional_Groups: 0 sleep(10) 0 Id User Host db Command Time State Info Progress 11 root localhost NULL Sleep 1242 NULL 0.000 16 system user NULL Slave_IO 1544 Waiting for master to send event NULL 0.000 18 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 19 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 20 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 21 system user NULL Slave_worker 0 closing tables NULL 0.000 17 system user NULL Slave_SQL 924 Slave has read all relay log; waiting for more updates NULL 0.000 32 root localhost NULL Sleep 6 NULL 0.000 217 root localhost NULL Query 0 starting show full processlist 0.000 *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: 172.31.71.127 Master_User: repl Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.000003 Read_Master_Log_Pos: 900981713 Relay_Log_File: ip-172-31-64-255-relay-bin.000008 Relay_Log_Pos: 876711242 Relay_Master_Log_File: mysql-bin.000003 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: 876710947 Relay_Log_Space: 1974793078 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: 941 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: 1 Master_SSL_Crl: Master_SSL_Crlpath: Using_Gtid: Slave_Pos Gtid_IO_Pos: 201-1-82021 Replicate_Do_Domain_Ids: Replicate_Ignore_Domain_Ids: Parallel_Mode: optimistic SQL_Delay: 0 SQL_Remaining_Delay: NULL Slave_SQL_Running_State: Slave has read all relay log; waiting for more updates Slave_DDL_Groups: 0 Slave_Non_Transactional_Groups: 10203 Slave_Transactional_Groups: 0 sleep(10) 0 Id User Host db Command Time State Info Progress 11 root localhost NULL Sleep 1283 NULL 0.000 16 system user NULL Slave_IO 1585 Waiting for master to send event NULL 0.000 18 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 19 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 20 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 21 system user NULL Slave_worker 0 closing tables NULL 0.000 17 system user NULL Slave_SQL 964 Slave has read all relay log; waiting for more updates NULL 0.000 32 root localhost NULL Sleep 13 NULL 0.000 224 root localhost NULL Query 0 starting show full processlist 0.000 *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: 172.31.71.127 Master_User: repl Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.000003 Read_Master_Log_Pos: 900981713 Relay_Log_File: ip-172-31-64-255-relay-bin.000008 Relay_Log_Pos: 876784926 Relay_Master_Log_File: mysql-bin.000003 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: 876784631 Relay_Log_Space: 1974793078 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: 962 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: 1 Master_SSL_Crl: Master_SSL_Crlpath: Using_Gtid: Slave_Pos Gtid_IO_Pos: 201-1-82021 Replicate_Do_Domain_Ids: Replicate_Ignore_Domain_Ids: Parallel_Mode: optimistic SQL_Delay: 0 SQL_Remaining_Delay: NULL Slave_SQL_Running_State: Slave has read all relay log; waiting for more updates Slave_DDL_Groups: 0 Slave_Non_Transactional_Groups: 10421 Slave_Transactional_Groups: 0 sleep(10) 0 Id User Host db Command Time State Info Progress 11 root localhost NULL Sleep 1305 NULL 0.000 16 system user NULL Slave_IO 1607 Waiting for master to send event NULL 0.000 18 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 19 system user NULL Slave_worker 0 closing tables NULL 0.000 20 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 21 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 17 system user NULL Slave_SQL 986 Slave has read all relay log; waiting for more updates NULL 0.000 32 root localhost NULL Sleep 35 NULL 0.000 228 root localhost NULL Query 0 starting show full processlist 0.000 *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: 172.31.71.127 Master_User: repl Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.000003 Read_Master_Log_Pos: 900981713 Relay_Log_File: ip-172-31-64-255-relay-bin.000008 Relay_Log_Pos: 876841034 Relay_Master_Log_File: mysql-bin.000003 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: 876840739 Relay_Log_Space: 1974793078 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: 979 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: 1 Master_SSL_Crl: Master_SSL_Crlpath: Using_Gtid: Slave_Pos Gtid_IO_Pos: 201-1-82021 Replicate_Do_Domain_Ids: Replicate_Ignore_Domain_Ids: Parallel_Mode: optimistic SQL_Delay: 0 SQL_Remaining_Delay: NULL Slave_SQL_Running_State: Slave has read all relay log; waiting for more updates Slave_DDL_Groups: 0 Slave_Non_Transactional_Groups: 10587 Slave_Transactional_Groups: 0 sleep(10) 0 Id User Host db Command Time State Info Progress 11 root localhost NULL Sleep 1322 NULL 0.000 16 system user NULL Slave_IO 1624 Waiting for master to send event NULL 0.000 18 system user NULL Slave_worker 0 closing tables NULL 0.000 19 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 20 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 21 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 17 system user NULL Slave_SQL 1003 Slave has read all relay log; waiting for more updates NULL 0.000 32 root localhost NULL Sleep 7 NULL 0.000 232 root localhost NULL Query 0 starting show full processlist 0.000 *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: 172.31.71.127 Master_User: repl Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.000003 Read_Master_Log_Pos: 900981713 Relay_Log_File: ip-172-31-64-255-relay-bin.000008 Relay_Log_Pos: 876980290 Relay_Master_Log_File: mysql-bin.000003 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: 876979995 Relay_Log_Space: 1974793078 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: 1020 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: 1 Master_SSL_Crl: Master_SSL_Crlpath: Using_Gtid: Slave_Pos Gtid_IO_Pos: 201-1-82021 Replicate_Do_Domain_Ids: Replicate_Ignore_Domain_Ids: Parallel_Mode: optimistic SQL_Delay: 0 SQL_Remaining_Delay: NULL Slave_SQL_Running_State: Slave has read all relay log; waiting for more updates Slave_DDL_Groups: 0 Slave_Non_Transactional_Groups: 10999 Slave_Transactional_Groups: 0 sleep(10) 0 Id User Host db Command Time State Info Progress 11 root localhost NULL Sleep 1363 NULL 0.000 16 system user NULL Slave_IO 1666 Waiting for master to send event NULL 0.000 18 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 19 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 20 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 21 system user NULL Slave_worker 0 closing tables NULL 0.000 17 system user NULL Slave_SQL 1045 Slave has read all relay log; waiting for more updates NULL 0.000 32 root localhost NULL Sleep 3 NULL 0.000 239 root localhost NULL Query 0 starting show full processlist 0.000 *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: 172.31.71.127 Master_User: repl Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.000003 Read_Master_Log_Pos: 900981713 Relay_Log_File: ip-172-31-64-255-relay-bin.000008 Relay_Log_Pos: 877039778 Relay_Master_Log_File: mysql-bin.000003 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: 877039483 Relay_Log_Space: 1974793078 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: 1037 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: 1 Master_SSL_Crl: Master_SSL_Crlpath: Using_Gtid: Slave_Pos Gtid_IO_Pos: 201-1-82021 Replicate_Do_Domain_Ids: Replicate_Ignore_Domain_Ids: Parallel_Mode: optimistic SQL_Delay: 0 SQL_Remaining_Delay: NULL Slave_SQL_Running_State: Slave has read all relay log; waiting for more updates Slave_DDL_Groups: 0 Slave_Non_Transactional_Groups: 11175 Slave_Transactional_Groups: 0 sleep(10) 0 Id User Host db Command Time State Info Progress 11 root localhost NULL Sleep 1381 NULL 0.000 16 system user NULL Slave_IO 1684 Waiting for master to send event NULL 0.000 18 system user NULL Slave_worker 0 closing tables NULL 0.000 19 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 20 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 21 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 17 system user NULL Slave_SQL 1063 Slave has read all relay log; waiting for more updates NULL 0.000 32 root localhost NULL Sleep 0 NULL 0.000 243 root localhost NULL Query 0 starting show full processlist 0.000 *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: 172.31.71.127 Master_User: repl Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.000003 Read_Master_Log_Pos: 900981713 Relay_Log_File: ip-172-31-64-255-relay-bin.000008 Relay_Log_Pos: 877098928 Relay_Master_Log_File: mysql-bin.000003 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: 877098633 Relay_Log_Space: 1974793078 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: 1055 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: 1 Master_SSL_Crl: Master_SSL_Crlpath: Using_Gtid: Slave_Pos Gtid_IO_Pos: 201-1-82021 Replicate_Do_Domain_Ids: Replicate_Ignore_Domain_Ids: Parallel_Mode: optimistic SQL_Delay: 0 SQL_Remaining_Delay: NULL Slave_SQL_Running_State: Slave has read all relay log; waiting for more updates Slave_DDL_Groups: 0 Slave_Non_Transactional_Groups: 11350 Slave_Transactional_Groups: 0 sleep(10) 0 Id User Host db Command Time State Info Progress 11 root localhost NULL Sleep 1399 NULL 0.000 16 system user NULL Slave_IO 1701 Waiting for master to send event NULL 0.000 18 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 19 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 20 system user NULL Slave_worker 0 closing tables NULL 0.000 21 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 17 system user NULL Slave_SQL 1081 Slave has read all relay log; waiting for more updates NULL 0.000 32 root localhost NULL Sleep 5 NULL 0.000 247 root localhost NULL Query 0 starting show full processlist 0.000 *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: 172.31.71.127 Master_User: repl Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.000003 Read_Master_Log_Pos: 900981713 Relay_Log_File: ip-172-31-64-255-relay-bin.000008 Relay_Log_Pos: 877231086 Relay_Master_Log_File: mysql-bin.000003 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: 877230791 Relay_Log_Space: 1974793078 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: 1095 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: 1 Master_SSL_Crl: Master_SSL_Crlpath: Using_Gtid: Slave_Pos Gtid_IO_Pos: 201-1-82021 Replicate_Do_Domain_Ids: Replicate_Ignore_Domain_Ids: Parallel_Mode: optimistic SQL_Delay: 0 SQL_Remaining_Delay: NULL Slave_SQL_Running_State: Slave has read all relay log; waiting for more updates Slave_DDL_Groups: 0 Slave_Non_Transactional_Groups: 11741 Slave_Transactional_Groups: 0 sleep(10) 0 Id User Host db Command Time State Info Progress 11 root localhost NULL Sleep 1439 NULL 0.000 16 system user NULL Slave_IO 1741 Waiting for master to send event NULL 0.000 18 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 19 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 20 system user NULL Slave_worker 0 closing tables NULL 0.000 21 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 17 system user NULL Slave_SQL 1120 Slave has read all relay log; waiting for more updates NULL 0.000 32 root localhost NULL Sleep 5 NULL 0.000 254 root localhost NULL Query 0 starting show full processlist 0.000 *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: 172.31.71.127 Master_User: repl Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.000003 Read_Master_Log_Pos: 900981713 Relay_Log_File: ip-172-31-64-255-relay-bin.000008 Relay_Log_Pos: 877284828 Relay_Master_Log_File: mysql-bin.000003 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: 877284533 Relay_Log_Space: 1974793078 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: 1110 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: 1 Master_SSL_Crl: Master_SSL_Crlpath: Using_Gtid: Slave_Pos Gtid_IO_Pos: 201-1-82021 Replicate_Do_Domain_Ids: Replicate_Ignore_Domain_Ids: Parallel_Mode: optimistic SQL_Delay: 0 SQL_Remaining_Delay: NULL Slave_SQL_Running_State: Slave has read all relay log; waiting for more updates Slave_DDL_Groups: 0 Slave_Non_Transactional_Groups: 11900 Slave_Transactional_Groups: 0 sleep(10) 0 Id User Host db Command Time State Info Progress 11 root localhost NULL Sleep 1455 NULL 0.000 16 system user NULL Slave_IO 1757 Waiting for master to send event NULL 0.000 18 system user NULL Slave_worker 0 closing tables NULL 0.000 19 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 20 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 21 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 17 system user NULL Slave_SQL 1136 Slave has read all relay log; waiting for more updates NULL 0.000 32 root localhost NULL Sleep 21 NULL 0.000 257 root localhost NULL Query 0 starting show full processlist 0.000 *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: 172.31.71.127 Master_User: repl Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.000003 Read_Master_Log_Pos: 900981713 Relay_Log_File: ip-172-31-64-255-relay-bin.000008 Relay_Log_Pos: 877374736 Relay_Master_Log_File: mysql-bin.000003 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: 877374441 Relay_Log_Space: 1974793078 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: 1137 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: 1 Master_SSL_Crl: Master_SSL_Crlpath: Using_Gtid: Slave_Pos Gtid_IO_Pos: 201-1-82021 Replicate_Do_Domain_Ids: Replicate_Ignore_Domain_Ids: Parallel_Mode: optimistic SQL_Delay: 0 SQL_Remaining_Delay: NULL Slave_SQL_Running_State: Slave has read all relay log; waiting for more updates Slave_DDL_Groups: 0 Slave_Non_Transactional_Groups: 12166 Slave_Transactional_Groups: 0 sleep(10) 0 Id User Host db Command Time State Info Progress 11 root localhost NULL Sleep 1482 NULL 0.000 16 system user NULL Slave_IO 1784 Waiting for master to send event NULL 0.000 18 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 19 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 20 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 21 system user NULL Slave_worker 0 closing tables NULL 0.000 17 system user NULL Slave_SQL 1163 Slave has read all relay log; waiting for more updates NULL 0.000 32 root localhost NULL Sleep 1 NULL 0.000 263 root localhost NULL Query 0 starting show full processlist 0.000 *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: 172.31.71.127 Master_User: repl Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.000003 Read_Master_Log_Pos: 900981713 Relay_Log_File: ip-172-31-64-255-relay-bin.000008 Relay_Log_Pos: 877426112 Relay_Master_Log_File: mysql-bin.000003 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: 877425817 Relay_Log_Space: 1974793078 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: 1152 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: 1 Master_SSL_Crl: Master_SSL_Crlpath: Using_Gtid: Slave_Pos Gtid_IO_Pos: 201-1-82021 Replicate_Do_Domain_Ids: Replicate_Ignore_Domain_Ids: Parallel_Mode: optimistic SQL_Delay: 0 SQL_Remaining_Delay: NULL Slave_SQL_Running_State: Slave has read all relay log; waiting for more updates Slave_DDL_Groups: 0 Slave_Non_Transactional_Groups: 12318 Slave_Transactional_Groups: 0 sleep(10) 0 Id User Host db Command Time State Info Progress 11 root localhost NULL Sleep 1497 NULL 0.000 16 system user NULL Slave_IO 1800 Waiting for master to send event NULL 0.000 18 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 19 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 20 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 21 system user NULL Slave_worker 0 closing tables NULL 0.000 17 system user NULL Slave_SQL 1179 Slave has read all relay log; waiting for more updates NULL 0.000 32 root localhost NULL Sleep 17 NULL 0.000 266 root localhost NULL Query 0 starting show full processlist 0.000 *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: 172.31.71.127 Master_User: repl Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.000003 Read_Master_Log_Pos: 900981713 Relay_Log_File: ip-172-31-64-255-relay-bin.000008 Relay_Log_Pos: 877498782 Relay_Master_Log_File: mysql-bin.000003 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: 877498487 Relay_Log_Space: 1974793078 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: 1174 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: 1 Master_SSL_Crl: Master_SSL_Crlpath: Using_Gtid: Slave_Pos Gtid_IO_Pos: 201-1-82021 Replicate_Do_Domain_Ids: Replicate_Ignore_Domain_Ids: Parallel_Mode: optimistic SQL_Delay: 0 SQL_Remaining_Delay: NULL Slave_SQL_Running_State: Slave has read all relay log; waiting for more updates Slave_DDL_Groups: 0 Slave_Non_Transactional_Groups: 12533 Slave_Transactional_Groups: 0 sleep(10) 0 Id User Host db Command Time State Info Progress 11 root localhost NULL Sleep 1519 NULL 0.000 16 system user NULL Slave_IO 1821 Waiting for master to send event NULL 0.000 18 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 19 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 20 system user NULL Slave_worker 0 closing tables NULL 0.000 21 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 17 system user NULL Slave_SQL 1201 Slave has read all relay log; waiting for more updates NULL 0.000 32 root localhost NULL Sleep 0 NULL 0.000 270 root localhost NULL Query 0 starting show full processlist 0.000 *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: 172.31.71.127 Master_User: repl Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.000003 Read_Master_Log_Pos: 900981713 Relay_Log_File: ip-172-31-64-255-relay-bin.000008 Relay_Log_Pos: 877569762 Relay_Master_Log_File: mysql-bin.000003 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: 877569467 Relay_Log_Space: 1974793078 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: 1194 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: 1 Master_SSL_Crl: Master_SSL_Crlpath: Using_Gtid: Slave_Pos Gtid_IO_Pos: 201-1-82021 Replicate_Do_Domain_Ids: Replicate_Ignore_Domain_Ids: Parallel_Mode: optimistic SQL_Delay: 0 SQL_Remaining_Delay: NULL Slave_SQL_Running_State: Slave has read all relay log; waiting for more updates Slave_DDL_Groups: 0 Slave_Non_Transactional_Groups: 12743 Slave_Transactional_Groups: 0 sleep(10) 0 Id User Host db Command Time State Info Progress 11 root localhost NULL Sleep 1540 NULL 0.000 16 system user NULL Slave_IO 1843 Waiting for master to send event NULL 0.000 18 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 19 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 20 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 21 system user NULL Slave_worker 0 closing tables NULL 0.000 17 system user NULL Slave_SQL 1222 Slave has read all relay log; waiting for more updates NULL 0.000 32 root localhost NULL Sleep 21 NULL 0.000 275 root localhost NULL Query 0 starting show full processlist 0.000 *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: 172.31.71.127 Master_User: repl Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.000003 Read_Master_Log_Pos: 900981713 Relay_Log_File: ip-172-31-64-255-relay-bin.000008 Relay_Log_Pos: 877891876 Relay_Master_Log_File: mysql-bin.000003 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: 877891581 Relay_Log_Space: 1974793078 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: 1290 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: 1 Master_SSL_Crl: Master_SSL_Crlpath: Using_Gtid: Slave_Pos Gtid_IO_Pos: 201-1-82021 Replicate_Do_Domain_Ids: Replicate_Ignore_Domain_Ids: Parallel_Mode: optimistic SQL_Delay: 0 SQL_Remaining_Delay: NULL Slave_SQL_Running_State: Slave has read all relay log; waiting for more updates Slave_DDL_Groups: 0 Slave_Non_Transactional_Groups: 13696 Slave_Transactional_Groups: 0 sleep(10) 0 Id User Host db Command Time State Info Progress 11 root localhost NULL Sleep 1637 NULL 0.000 16 system user NULL Slave_IO 1939 Waiting for master to send event NULL 0.000 18 system user NULL Slave_worker 0 closing tables NULL 0.000 19 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 20 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 21 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 17 system user NULL Slave_SQL 1319 Slave has read all relay log; waiting for more updates NULL 0.000 32 root localhost NULL Sleep 0 NULL 0.000 291 root localhost NULL Query 0 starting show full processlist 0.000 *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: 172.31.71.127 Master_User: repl Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.000003 Read_Master_Log_Pos: 900981713 Relay_Log_File: ip-172-31-64-255-relay-bin.000008 Relay_Log_Pos: 877937506 Relay_Master_Log_File: mysql-bin.000003 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: 877937211 Relay_Log_Space: 1974793078 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: 1304 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: 1 Master_SSL_Crl: Master_SSL_Crlpath: Using_Gtid: Slave_Pos Gtid_IO_Pos: 201-1-82021 Replicate_Do_Domain_Ids: Replicate_Ignore_Domain_Ids: Parallel_Mode: optimistic SQL_Delay: 0 SQL_Remaining_Delay: NULL Slave_SQL_Running_State: Slave has read all relay log; waiting for more updates Slave_DDL_Groups: 0 Slave_Non_Transactional_Groups: 13831 Slave_Transactional_Groups: 0 sleep(10) 0 Id User Host db Command Time State Info Progress 11 root localhost NULL Sleep 1651 NULL 0.000 16 system user NULL Slave_IO 1953 Waiting for master to send event NULL 0.000 18 system user NULL Slave_worker 0 closing tables NULL 0.000 19 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 20 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 21 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 17 system user NULL Slave_SQL 1332 Slave has read all relay log; waiting for more updates NULL 0.000 32 root localhost NULL Sleep 12 NULL 0.000 294 root localhost NULL Query 0 starting show full processlist 0.000 *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: 172.31.71.127 Master_User: repl Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.000003 Read_Master_Log_Pos: 900981713 Relay_Log_File: ip-172-31-64-255-relay-bin.000008 Relay_Log_Pos: 878064256 Relay_Master_Log_File: mysql-bin.000003 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: 878063961 Relay_Log_Space: 1974793078 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: 1341 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: 1 Master_SSL_Crl: Master_SSL_Crlpath: Using_Gtid: Slave_Pos Gtid_IO_Pos: 201-1-82021 Replicate_Do_Domain_Ids: Replicate_Ignore_Domain_Ids: Parallel_Mode: optimistic SQL_Delay: 0 SQL_Remaining_Delay: NULL Slave_SQL_Running_State: Slave has read all relay log; waiting for more updates Slave_DDL_Groups: 0 Slave_Non_Transactional_Groups: 14206 Slave_Transactional_Groups: 0 sleep(10) 0 Id User Host db Command Time State Info Progress 11 root localhost NULL Sleep 1689 NULL 0.000 16 system user NULL Slave_IO 1991 Waiting for master to send event NULL 0.000 18 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 19 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 20 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 21 system user NULL Slave_worker 0 closing tables NULL 0.000 17 system user NULL Slave_SQL 1370 Slave has read all relay log; waiting for more updates NULL 0.000 32 root localhost NULL Sleep 4 NULL 0.000 300 root localhost NULL Query 0 starting show full processlist 0.000 *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: 172.31.71.127 Master_User: repl Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.000003 Read_Master_Log_Pos: 900981713 Relay_Log_File: ip-172-31-64-255-relay-bin.000008 Relay_Log_Pos: 878230890 Relay_Master_Log_File: mysql-bin.000003 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: 878230595 Relay_Log_Space: 1974793078 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: 1391 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: 1 Master_SSL_Crl: Master_SSL_Crlpath: Using_Gtid: Slave_Pos Gtid_IO_Pos: 201-1-82021 Replicate_Do_Domain_Ids: Replicate_Ignore_Domain_Ids: Parallel_Mode: optimistic SQL_Delay: 0 SQL_Remaining_Delay: NULL Slave_SQL_Running_State: Slave has read all relay log; waiting for more updates Slave_DDL_Groups: 0 Slave_Non_Transactional_Groups: 14699 Slave_Transactional_Groups: 0 sleep(10) 0 Id User Host db Command Time State Info Progress 11 root localhost NULL Sleep 1739 NULL 0.000 16 system user NULL Slave_IO 2041 Waiting for master to send event NULL 0.000 18 system user NULL Slave_worker 0 closing tables NULL 0.000 19 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 20 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 21 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 17 system user NULL Slave_SQL 1420 Slave has read all relay log; waiting for more updates NULL 0.000 32 root localhost NULL Sleep 54 NULL 0.000 309 root localhost NULL Query 0 starting show full processlist 0.000 *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: 172.31.71.127 Master_User: repl Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.000003 Read_Master_Log_Pos: 900981713 Relay_Log_File: ip-172-31-64-255-relay-bin.000008 Relay_Log_Pos: 878472222 Relay_Master_Log_File: mysql-bin.000003 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: 878471927 Relay_Log_Space: 1974793078 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: 1462 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: 1 Master_SSL_Crl: Master_SSL_Crlpath: Using_Gtid: Slave_Pos Gtid_IO_Pos: 201-1-82021 Replicate_Do_Domain_Ids: Replicate_Ignore_Domain_Ids: Parallel_Mode: optimistic SQL_Delay: 0 SQL_Remaining_Delay: NULL Slave_SQL_Running_State: Slave has read all relay log; waiting for more updates Slave_DDL_Groups: 0 Slave_Non_Transactional_Groups: 15413 Slave_Transactional_Groups: 0 sleep(10) 0 Id User Host db Command Time State Info Progress 11 root localhost NULL Sleep 1811 NULL 0.000 16 system user NULL Slave_IO 2113 Waiting for master to send event NULL 0.000 18 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 19 system user NULL Slave_worker 0 closing tables NULL 0.000 20 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 21 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 17 system user NULL Slave_SQL 1493 Slave has read all relay log; waiting for more updates NULL 0.000 32 root localhost NULL Sleep 5 NULL 0.000 321 root localhost NULL Query 0 starting show full processlist 0.000 *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: 172.31.71.127 Master_User: repl Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.000003 Read_Master_Log_Pos: 900981713 Relay_Log_File: ip-172-31-64-255-relay-bin.000008 Relay_Log_Pos: 878702400 Relay_Master_Log_File: mysql-bin.000003 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: 878702105 Relay_Log_Space: 1974793078 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: 1530 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: 1 Master_SSL_Crl: Master_SSL_Crlpath: Using_Gtid: Slave_Pos Gtid_IO_Pos: 201-1-82021 Replicate_Do_Domain_Ids: Replicate_Ignore_Domain_Ids: Parallel_Mode: optimistic SQL_Delay: 0 SQL_Remaining_Delay: NULL Slave_SQL_Running_State: Slave has read all relay log; waiting for more updates Slave_DDL_Groups: 0 Slave_Non_Transactional_Groups: 16094 Slave_Transactional_Groups: 0 sleep(10) 0 Id User Host db Command Time State Info Progress 11 root localhost NULL Sleep 1880 NULL 0.000 16 system user NULL Slave_IO 2183 Waiting for master to send event NULL 0.000 18 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 19 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 20 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 21 system user NULL Slave_worker 0 closing tables NULL 0.000 17 system user NULL Slave_SQL 1562 Slave has read all relay log; waiting for more updates NULL 0.000 32 root localhost NULL Sleep 74 NULL 0.000 333 root localhost NULL Query 0 starting show full processlist 0.000 *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: 172.31.71.127 Master_User: repl Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.000003 Read_Master_Log_Pos: 900981713 Relay_Log_File: ip-172-31-64-255-relay-bin.000008 Relay_Log_Pos: 878801096 Relay_Master_Log_File: mysql-bin.000003 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: 878800801 Relay_Log_Space: 1974793078 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: 1559 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: 1 Master_SSL_Crl: Master_SSL_Crlpath: Using_Gtid: Slave_Pos Gtid_IO_Pos: 201-1-82021 Replicate_Do_Domain_Ids: Replicate_Ignore_Domain_Ids: Parallel_Mode: optimistic SQL_Delay: 0 SQL_Remaining_Delay: NULL Slave_SQL_Running_State: Slave has read all relay log; waiting for more updates Slave_DDL_Groups: 0 Slave_Non_Transactional_Groups: 16386 Slave_Transactional_Groups: 0 sleep(10) 0 Id User Host db Command Time State Info Progress 11 root localhost NULL Sleep 1910 NULL 0.000 16 system user NULL Slave_IO 2212 Waiting for master to send event NULL 0.000 18 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 19 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 20 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 21 system user NULL Slave_worker 0 closing tables NULL 0.000 17 system user NULL Slave_SQL 1591 Slave has read all relay log; waiting for more updates NULL 0.000 32 root localhost NULL Sleep 104 NULL 0.000 339 root localhost NULL Query 0 starting show full processlist 0.000 *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: 172.31.71.127 Master_User: repl Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.000003 Read_Master_Log_Pos: 900981713 Relay_Log_File: ip-172-31-64-255-relay-bin.000008 Relay_Log_Pos: 878945422 Relay_Master_Log_File: mysql-bin.000003 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: 878945127 Relay_Log_Space: 1974793078 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: 1602 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: 1 Master_SSL_Crl: Master_SSL_Crlpath: Using_Gtid: Slave_Pos Gtid_IO_Pos: 201-1-82021 Replicate_Do_Domain_Ids: Replicate_Ignore_Domain_Ids: Parallel_Mode: optimistic SQL_Delay: 0 SQL_Remaining_Delay: NULL Slave_SQL_Running_State: Slave has read all relay log; waiting for more updates Slave_DDL_Groups: 0 Slave_Non_Transactional_Groups: 16813 Slave_Transactional_Groups: 0 sleep(10) 0 Id User Host db Command Time State Info Progress 11 root localhost NULL Sleep 1953 NULL 0.000 16 system user NULL Slave_IO 2255 Waiting for master to send event NULL 0.000 18 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 19 system user NULL Slave_worker 0 closing tables NULL 0.000 20 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 21 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 17 system user NULL Slave_SQL 1635 Slave has read all relay log; waiting for more updates NULL 0.000 32 root localhost NULL Sleep 7 NULL 0.000 346 root localhost NULL Query 0 starting show full processlist 0.000 *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: 172.31.71.127 Master_User: repl Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.000003 Read_Master_Log_Pos: 900981713 Relay_Log_File: ip-172-31-64-255-relay-bin.000008 Relay_Log_Pos: 879348318 Relay_Master_Log_File: mysql-bin.000003 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: 879348023 Relay_Log_Space: 1974793078 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: 1721 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: 1 Master_SSL_Crl: Master_SSL_Crlpath: Using_Gtid: Slave_Pos Gtid_IO_Pos: 201-1-82021 Replicate_Do_Domain_Ids: Replicate_Ignore_Domain_Ids: Parallel_Mode: optimistic SQL_Delay: 0 SQL_Remaining_Delay: NULL Slave_SQL_Running_State: Slave has read all relay log; waiting for more updates Slave_DDL_Groups: 0 Slave_Non_Transactional_Groups: 18005 Slave_Transactional_Groups: 0 sleep(10) 0 Id User Host db Command Time State Info Progress 11 root localhost NULL Sleep 2074 NULL 0.000 16 system user NULL Slave_IO 2376 Waiting for master to send event NULL 0.000 18 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 19 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 20 system user NULL Slave_worker 0 closing tables NULL 0.000 21 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 17 system user NULL Slave_SQL 1755 Slave has read all relay log; waiting for more updates NULL 0.000 32 root localhost NULL Sleep 7 NULL 0.000 366 root localhost NULL Query 0 starting show full processlist 0.000 *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: 172.31.71.127 Master_User: repl Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.000003 Read_Master_Log_Pos: 900981713 Relay_Log_File: ip-172-31-64-255-relay-bin.000008 Relay_Log_Pos: 879585256 Relay_Master_Log_File: mysql-bin.000003 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: 879584961 Relay_Log_Space: 1974793078 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: 1791 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: 1 Master_SSL_Crl: Master_SSL_Crlpath: Using_Gtid: Slave_Pos Gtid_IO_Pos: 201-1-82021 Replicate_Do_Domain_Ids: Replicate_Ignore_Domain_Ids: Parallel_Mode: optimistic SQL_Delay: 0 SQL_Remaining_Delay: NULL Slave_SQL_Running_State: Slave has read all relay log; waiting for more updates Slave_DDL_Groups: 0 Slave_Non_Transactional_Groups: 18706 Slave_Transactional_Groups: 0 sleep(10) 0 Id User Host db Command Time State Info Progress 11 root localhost NULL Sleep 2145 NULL 0.000 16 system user NULL Slave_IO 2447 Waiting for master to send event NULL 0.000 18 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 19 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 20 system user NULL Slave_worker 0 closing tables NULL 0.000 21 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 17 system user NULL Slave_SQL 1826 Slave has read all relay log; waiting for more updates NULL 0.000 32 root localhost NULL Sleep 7 NULL 0.000 378 root localhost NULL Query 0 starting show full processlist 0.000 *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: 172.31.71.127 Master_User: repl Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.000003 Read_Master_Log_Pos: 900981713 Relay_Log_File: ip-172-31-64-255-relay-bin.000008 Relay_Log_Pos: 879822194 Relay_Master_Log_File: mysql-bin.000003 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: 879821899 Relay_Log_Space: 1974793078 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: 1861 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: 1 Master_SSL_Crl: Master_SSL_Crlpath: Using_Gtid: Slave_Pos Gtid_IO_Pos: 201-1-82021 Replicate_Do_Domain_Ids: Replicate_Ignore_Domain_Ids: Parallel_Mode: optimistic SQL_Delay: 0 SQL_Remaining_Delay: NULL Slave_SQL_Running_State: Slave has read all relay log; waiting for more updates Slave_DDL_Groups: 0 Slave_Non_Transactional_Groups: 19407 Slave_Transactional_Groups: 0 sleep(10) 0 Id User Host db Command Time State Info Progress 11 root localhost NULL Sleep 2216 NULL 0.000 16 system user NULL Slave_IO 2518 Waiting for master to send event NULL 0.000 18 system user NULL Slave_worker 0 closing tables NULL 0.000 19 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 20 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 21 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 17 system user NULL Slave_SQL 1897 Slave has read all relay log; waiting for more updates NULL 0.000 32 root localhost NULL Sleep 0 NULL 0.000 390 root localhost NULL Query 0 starting show full processlist 0.000 *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: 172.31.71.127 Master_User: repl Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.000003 Read_Master_Log_Pos: 900981713 Relay_Log_File: ip-172-31-64-255-relay-bin.000008 Relay_Log_Pos: 880028036 Relay_Master_Log_File: mysql-bin.000003 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: 880027741 Relay_Log_Space: 1974793078 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: 1922 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: 1 Master_SSL_Crl: Master_SSL_Crlpath: Using_Gtid: Slave_Pos Gtid_IO_Pos: 201-1-82021 Replicate_Do_Domain_Ids: Replicate_Ignore_Domain_Ids: Parallel_Mode: optimistic SQL_Delay: 0 SQL_Remaining_Delay: NULL Slave_SQL_Running_State: Slave has read all relay log; waiting for more updates Slave_DDL_Groups: 0 Slave_Non_Transactional_Groups: 20016 Slave_Transactional_Groups: 0 sleep(10) 0 Id User Host db Command Time State Info Progress 11 root localhost NULL Sleep 2277 NULL 0.000 16 system user NULL Slave_IO 2580 Waiting for master to send event NULL 0.000 18 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 19 system user NULL Slave_worker 0 closing tables NULL 0.000 20 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 21 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 17 system user NULL Slave_SQL 1959 Slave has read all relay log; waiting for more updates NULL 0.000 32 root localhost NULL Sleep 14 NULL 0.000 400 root localhost NULL Query 0 starting show full processlist 0.000 *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: 172.31.71.127 Master_User: repl Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.000003 Read_Master_Log_Pos: 900981713 Relay_Log_File: ip-172-31-64-255-relay-bin.000008 Relay_Log_Pos: 880215288 Relay_Master_Log_File: mysql-bin.000003 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: 880214993 Relay_Log_Space: 1974793078 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: 1978 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: 1 Master_SSL_Crl: Master_SSL_Crlpath: Using_Gtid: Slave_Pos Gtid_IO_Pos: 201-1-82021 Replicate_Do_Domain_Ids: Replicate_Ignore_Domain_Ids: Parallel_Mode: optimistic SQL_Delay: 0 SQL_Remaining_Delay: NULL Slave_SQL_Running_State: Slave has read all relay log; waiting for more updates Slave_DDL_Groups: 0 Slave_Non_Transactional_Groups: 20570 Slave_Transactional_Groups: 0 sleep(10) 0 Id User Host db Command Time State Info Progress 11 root localhost NULL Sleep 2334 NULL 0.000 16 system user NULL Slave_IO 2636 Waiting for master to send event NULL 0.000 18 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 19 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 20 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 21 system user NULL Slave_worker 0 closing tables NULL 0.000 17 system user NULL Slave_SQL 2015 Slave has read all relay log; waiting for more updates NULL 0.000 32 root localhost NULL Sleep 7 NULL 0.000 410 root localhost NULL Query 0 starting show full processlist 0.000 *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: 172.31.71.127 Master_User: repl Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.000003 Read_Master_Log_Pos: 900981713 Relay_Log_File: ip-172-31-64-255-relay-bin.000008 Relay_Log_Pos: 880361980 Relay_Master_Log_File: mysql-bin.000003 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: 880361685 Relay_Log_Space: 1974793078 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: 2021 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: 1 Master_SSL_Crl: Master_SSL_Crlpath: Using_Gtid: Slave_Pos Gtid_IO_Pos: 201-1-82021 Replicate_Do_Domain_Ids: Replicate_Ignore_Domain_Ids: Parallel_Mode: optimistic SQL_Delay: 0 SQL_Remaining_Delay: NULL Slave_SQL_Running_State: Slave has read all relay log; waiting for more updates Slave_DDL_Groups: 0 Slave_Non_Transactional_Groups: 21004 Slave_Transactional_Groups: 0 sleep(10) 0 Id User Host db Command Time State Info Progress 11 root localhost NULL Sleep 2378 NULL 0.000 16 system user NULL Slave_IO 2680 Waiting for master to send event NULL 0.000 18 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 19 system user NULL Slave_worker 0 closing tables NULL 0.000 20 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 21 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 17 system user NULL Slave_SQL 2059 Slave has read all relay log; waiting for more updates NULL 0.000 32 root localhost NULL Sleep 13 NULL 0.000 418 root localhost NULL Query 0 starting show full processlist 0.000 *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: 172.31.71.127 Master_User: repl Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.000003 Read_Master_Log_Pos: 900981713 Relay_Log_File: ip-172-31-64-255-relay-bin.000008 Relay_Log_Pos: 880692206 Relay_Master_Log_File: mysql-bin.000003 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: 880691911 Relay_Log_Space: 1974793078 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: 2118 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: 1 Master_SSL_Crl: Master_SSL_Crlpath: Using_Gtid: Slave_Pos Gtid_IO_Pos: 201-1-82021 Replicate_Do_Domain_Ids: Replicate_Ignore_Domain_Ids: Parallel_Mode: optimistic SQL_Delay: 0 SQL_Remaining_Delay: NULL Slave_SQL_Running_State: Slave has read all relay log; waiting for more updates Slave_DDL_Groups: 0 Slave_Non_Transactional_Groups: 21981 Slave_Transactional_Groups: 0 sleep(10) 0 Id User Host db Command Time State Info Progress 11 root localhost NULL Sleep 2477 NULL 0.000 16 system user NULL Slave_IO 2779 Waiting for master to send event NULL 0.000 18 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 19 system user NULL Slave_worker 0 closing tables NULL 0.000 20 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 21 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 17 system user NULL Slave_SQL 2158 Slave has read all relay log; waiting for more updates NULL 0.000 32 root localhost NULL Sleep 18 NULL 0.000 434 root localhost NULL Query 0 starting show full processlist 0.000 *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: 172.31.71.127 Master_User: repl Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.000003 Read_Master_Log_Pos: 900981713 Relay_Log_File: ip-172-31-64-255-relay-bin.000008 Relay_Log_Pos: 880876416 Relay_Master_Log_File: mysql-bin.000003 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: 880876121 Relay_Log_Space: 1974793078 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: 2173 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: 1 Master_SSL_Crl: Master_SSL_Crlpath: Using_Gtid: Slave_Pos Gtid_IO_Pos: 201-1-82021 Replicate_Do_Domain_Ids: Replicate_Ignore_Domain_Ids: Parallel_Mode: optimistic SQL_Delay: 0 SQL_Remaining_Delay: NULL Slave_SQL_Running_State: Slave has read all relay log; waiting for more updates Slave_DDL_Groups: 0 Slave_Non_Transactional_Groups: 22526 Slave_Transactional_Groups: 0 sleep(10) 0 Id User Host db Command Time State Info Progress 11 root localhost NULL Sleep 2532 NULL 0.000 16 system user NULL Slave_IO 2834 Waiting for master to send event NULL 0.000 18 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 19 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 20 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 21 system user NULL Slave_worker 0 closing tables NULL 0.000 17 system user NULL Slave_SQL 2214 Slave has read all relay log; waiting for more updates NULL 0.000 32 root localhost NULL Sleep 73 NULL 0.000 443 root localhost NULL Query 0 starting show full processlist 0.000 *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: 172.31.71.127 Master_User: repl Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.000003 Read_Master_Log_Pos: 900981713 Relay_Log_File: ip-172-31-64-255-relay-bin.000008 Relay_Log_Pos: 881036628 Relay_Master_Log_File: mysql-bin.000003 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: 881036333 Relay_Log_Space: 1974793078 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: 2221 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: 1 Master_SSL_Crl: Master_SSL_Crlpath: Using_Gtid: Slave_Pos Gtid_IO_Pos: 201-1-82021 Replicate_Do_Domain_Ids: Replicate_Ignore_Domain_Ids: Parallel_Mode: optimistic SQL_Delay: 0 SQL_Remaining_Delay: NULL Slave_SQL_Running_State: Slave has read all relay log; waiting for more updates Slave_DDL_Groups: 0 Slave_Non_Transactional_Groups: 23000 Slave_Transactional_Groups: 0 sleep(10) 0 Id User Host db Command Time State Info Progress 11 root localhost NULL Sleep 2580 NULL 0.000 16 system user NULL Slave_IO 2882 Waiting for master to send event NULL 0.000 18 system user NULL Slave_worker 0 closing tables NULL 0.000 19 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 20 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 21 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 17 system user NULL Slave_SQL 2261 Slave has read all relay log; waiting for more updates NULL 0.000 32 root localhost NULL Sleep 4 NULL 0.000 452 root localhost NULL Query 0 starting show full processlist 0.000 *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: 172.31.71.127 Master_User: repl Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.000003 Read_Master_Log_Pos: 900981713 Relay_Log_File: ip-172-31-64-255-relay-bin.000008 Relay_Log_Pos: 881243822 Relay_Master_Log_File: mysql-bin.000003 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: 881243527 Relay_Log_Space: 1974793078 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: 2282 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: 1 Master_SSL_Crl: Master_SSL_Crlpath: Using_Gtid: Slave_Pos Gtid_IO_Pos: 201-1-82021 Replicate_Do_Domain_Ids: Replicate_Ignore_Domain_Ids: Parallel_Mode: optimistic SQL_Delay: 0 SQL_Remaining_Delay: NULL Slave_SQL_Running_State: Slave has read all relay log; waiting for more updates Slave_DDL_Groups: 0 Slave_Non_Transactional_Groups: 23613 Slave_Transactional_Groups: 0 sleep(10) 0 Id User Host db Command Time State Info Progress 11 root localhost NULL Sleep 2642 NULL 0.000 16 system user NULL Slave_IO 2944 Waiting for master to send event NULL 0.000 18 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 19 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 20 system user NULL Slave_worker 0 closing tables NULL 0.000 21 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 17 system user NULL Slave_SQL 2324 Slave has read all relay log; waiting for more updates NULL 0.000 32 root localhost NULL Sleep 66 NULL 0.000 462 root localhost NULL Query 0 starting show full processlist 0.000 *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: 172.31.71.127 Master_User: repl Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.000003 Read_Master_Log_Pos: 900981713 Relay_Log_File: ip-172-31-64-255-relay-bin.000008 Relay_Log_Pos: 881503068 Relay_Master_Log_File: mysql-bin.000003 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: 881502773 Relay_Log_Space: 1974793078 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: 2359 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: 1 Master_SSL_Crl: Master_SSL_Crlpath: Using_Gtid: Slave_Pos Gtid_IO_Pos: 201-1-82021 Replicate_Do_Domain_Ids: Replicate_Ignore_Domain_Ids: Parallel_Mode: optimistic SQL_Delay: 0 SQL_Remaining_Delay: NULL Slave_SQL_Running_State: Slave has read all relay log; waiting for more updates Slave_DDL_Groups: 0 Slave_Non_Transactional_Groups: 24380 Slave_Transactional_Groups: 0 sleep(10) 0 Id User Host db Command Time State Info Progress 11 root localhost NULL Sleep 2720 NULL 0.000 16 system user NULL Slave_IO 3022 Waiting for master to send event NULL 0.000 18 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 19 system user NULL Slave_worker 0 closing tables NULL 0.000 20 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 21 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 17 system user NULL Slave_SQL 2401 Slave has read all relay log; waiting for more updates NULL 0.000 32 root localhost NULL Sleep 7 NULL 0.000 475 root localhost NULL Query 0 starting show full processlist 0.000 *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: 172.31.71.127 Master_User: repl Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.000003 Read_Master_Log_Pos: 900981713 Relay_Log_File: ip-172-31-64-255-relay-bin.000008 Relay_Log_Pos: 881659224 Relay_Master_Log_File: mysql-bin.000003 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: 881658929 Relay_Log_Space: 1974793078 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: 2404 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: 1 Master_SSL_Crl: Master_SSL_Crlpath: Using_Gtid: Slave_Pos Gtid_IO_Pos: 201-1-82021 Replicate_Do_Domain_Ids: Replicate_Ignore_Domain_Ids: Parallel_Mode: optimistic SQL_Delay: 0 SQL_Remaining_Delay: NULL Slave_SQL_Running_State: Slave has read all relay log; waiting for more updates Slave_DDL_Groups: 0 Slave_Non_Transactional_Groups: 24842 Slave_Transactional_Groups: 0 sleep(10) 0 Id User Host db Command Time State Info Progress 11 root localhost NULL Sleep 2766 NULL 0.000 16 system user NULL Slave_IO 3069 Waiting for master to send event NULL 0.000 18 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 19 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 20 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 21 system user NULL Slave_worker 0 closing tables NULL 0.000 17 system user NULL Slave_SQL 2448 Slave has read all relay log; waiting for more updates NULL 0.000 32 root localhost NULL Sleep 4 NULL 0.000 484 root localhost NULL Query 0 starting show full processlist 0.000 *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: 172.31.71.127 Master_User: repl Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.000003 Read_Master_Log_Pos: 900981713 Relay_Log_File: ip-172-31-64-255-relay-bin.000008 Relay_Log_Pos: 881883994 Relay_Master_Log_File: mysql-bin.000003 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: 881883699 Relay_Log_Space: 1974793078 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: 2471 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: 1 Master_SSL_Crl: Master_SSL_Crlpath: Using_Gtid: Slave_Pos Gtid_IO_Pos: 201-1-82021 Replicate_Do_Domain_Ids: Replicate_Ignore_Domain_Ids: Parallel_Mode: optimistic SQL_Delay: 0 SQL_Remaining_Delay: NULL Slave_SQL_Running_State: Slave has read all relay log; waiting for more updates Slave_DDL_Groups: 0 Slave_Non_Transactional_Groups: 25507 Slave_Transactional_Groups: 0 sleep(10) 0 Id User Host db Command Time State Info Progress 11 root localhost NULL Sleep 2834 NULL 0.000 16 system user NULL Slave_IO 3136 Waiting for master to send event NULL 0.000 18 system user NULL Slave_worker 0 closing tables NULL 0.000 19 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 20 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 21 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 17 system user NULL Slave_SQL 2516 Slave has read all relay log; waiting for more updates NULL 0.000 495 root localhost NULL Query 0 starting show full processlist 0.000 *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: 172.31.71.127 Master_User: repl Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.000003 Read_Master_Log_Pos: 900981713 Relay_Log_File: ip-172-31-64-255-relay-bin.000008 Relay_Log_Pos: 882056036 Relay_Master_Log_File: mysql-bin.000003 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: 882055741 Relay_Log_Space: 1974793078 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: 2522 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: 1 Master_SSL_Crl: Master_SSL_Crlpath: Using_Gtid: Slave_Pos Gtid_IO_Pos: 201-1-82021 Replicate_Do_Domain_Ids: Replicate_Ignore_Domain_Ids: Parallel_Mode: optimistic SQL_Delay: 0 SQL_Remaining_Delay: NULL Slave_SQL_Running_State: Slave has read all relay log; waiting for more updates Slave_DDL_Groups: 0 Slave_Non_Transactional_Groups: 26016 Slave_Transactional_Groups: 0 sleep(10) 0 Id User Host db Command Time State Info Progress 11 root localhost NULL Sleep 2885 NULL 0.000 16 system user NULL Slave_IO 3188 Waiting for master to send event NULL 0.000 18 system user NULL Slave_worker 0 closing tables NULL 0.000 19 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 20 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 21 system user NULL Slave_worker 0 Waiting for prior transaction to commit NULL 0.000 17 system user NULL Slave_SQL 2567 Slave has read all relay log; waiting for more updates NULL 0.000 504 root localhost NULL Query 0 starting show full processlist 0.000