MariaDB [(none)]> show slave status\G *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: 172.31.24.106 Master_User: repl Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.000003 Read_Master_Log_Pos: 613 Relay_Log_File: ip-172-31-17-237-relay-bin.000002 Relay_Log_Pos: 699 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: 613 Relay_Log_Space: 1015 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: 0 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-3759 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: 3751 Slave_Transactional_Groups: 0 1 row in set (0.000 sec) MariaDB [(none)]> show slave status\G *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: 172.31.24.106 Master_User: repl Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.000003 Read_Master_Log_Pos: 137816042 Relay_Log_File: ip-172-31-17-237-relay-bin.000002 Relay_Log_Pos: 21403872 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: 21403786 Relay_Log_Space: 137816444 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-4025 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: 3795 Slave_Transactional_Groups: 0 1 row in set (0.000 sec) MariaDB [(none)]> show slave status\G *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: 172.31.24.106 Master_User: repl Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.000003 Read_Master_Log_Pos: 160785334 Relay_Log_File: ip-172-31-17-237-relay-bin.000002 Relay_Log_Pos: 26624011 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: 26623925 Relay_Log_Space: 160785736 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: 5 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-4069 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: 3805 Slave_Transactional_Groups: 0 1 row in set (0.000 sec) MariaDB [(none)]> show slave status\G *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: 172.31.24.106 Master_User: repl Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.000003 Read_Master_Log_Pos: 183754626 Relay_Log_File: ip-172-31-17-237-relay-bin.000002 Relay_Log_Pos: 30799971 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: 30799885 Relay_Log_Space: 183755028 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: 6 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-4113 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: 3813 Slave_Transactional_Groups: 0 1 row in set (0.000 sec) MariaDB [(none)]> show slave status\G *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: 172.31.24.106 Master_User: repl Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.000003 Read_Master_Log_Pos: 204635560 Relay_Log_File: ip-172-31-17-237-relay-bin.000002 Relay_Log_Pos: 33932319 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: 33932233 Relay_Log_Space: 204635962 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: 7 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-4153 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: 3819 Slave_Transactional_Groups: 0 1 row in set (0.000 sec) MariaDB [(none)]> show slave status\G *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: 172.31.24.106 Master_User: repl Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.000003 Read_Master_Log_Pos: 254748970 Relay_Log_File: ip-172-31-17-237-relay-bin.000002 Relay_Log_Pos: 42806612 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: 42806526 Relay_Log_Space: 254749372 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: 9 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-4249 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: 3836 Slave_Transactional_Groups: 0 1 row in set (0.000 sec) MariaDB [(none)]> MariaDB [(none)]> MariaDB [(none)]> show full processlist; +----+-------------+-----------+------+--------------+------+--------------------------------------------------------+-----------------------+----------+ | Id | User | Host | db | Command | Time | State | Info | Progress | +----+-------------+-----------+------+--------------+------+--------------------------------------------------------+-----------------------+----------+ | 67 | system user | | NULL | Slave_IO | 315 | Waiting for master to send event | NULL | 0.000 | | 69 | system user | | NULL | Slave_worker | 0 | Waiting for prior transaction to commit | NULL | 0.000 | | 70 | system user | | NULL | Slave_worker | 0 | closing tables | NULL | 0.000 | | 71 | system user | | NULL | Slave_worker | 0 | Waiting for prior transaction to commit | NULL | 0.000 | | 72 | system user | | NULL | Slave_worker | 0 | Waiting for prior transaction to commit | NULL | 0.000 | | 68 | system user | | NULL | Slave_SQL | 315 | Slave has read all relay log; waiting for more updates | NULL | 0.000 | | 73 | root | localhost | NULL | Query | 0 | starting | show full processlist | 0.000 | +----+-------------+-----------+------+--------------+------+--------------------------------------------------------+-----------------------+----------+ 7 rows in set (0.000 sec) MariaDB [(none)]> show slave status\G *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: 172.31.24.106 Master_User: repl Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.000003 Read_Master_Log_Pos: 565926250 Relay_Log_File: ip-172-31-17-237-relay-bin.000002 Relay_Log_Pos: 94488464 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: 94488378 Relay_Log_Space: 565926652 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: 19 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-4845 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: 3935 Slave_Transactional_Groups: 0 1 row in set (0.000 sec) MariaDB [(none)]> show full processlist; +----+-------------+-----------+------+--------------+------+--------------------------------------------------------+-----------------------+----------+ | Id | User | Host | db | Command | Time | State | Info | Progress | +----+-------------+-----------+------+--------------+------+--------------------------------------------------------+-----------------------+----------+ | 67 | system user | | NULL | Slave_IO | 321 | Waiting for master to send event | NULL | 0.000 | | 69 | system user | | NULL | Slave_worker | 0 | Waiting for prior transaction to commit | NULL | 0.000 | | 70 | system user | | NULL | Slave_worker | 0 | Waiting for prior transaction to commit | NULL | 0.000 | | 71 | system user | | NULL | Slave_worker | 0 | Write_rows_log_event::write_row(-1) | NULL | 0.000 | | 72 | system user | | NULL | Slave_worker | 0 | Waiting for prior transaction to commit | NULL | 0.000 | | 68 | system user | | NULL | Slave_SQL | 321 | Slave has read all relay log; waiting for more updates | NULL | 0.000 | | 73 | root | localhost | NULL | Query | 0 | starting | show full processlist | 0.000 | +----+-------------+-----------+------+--------------+------+--------------------------------------------------------+-----------------------+----------+ 7 rows in set (0.000 sec) MariaDB [(none)]> show slave status\G *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: 172.31.24.106 Master_User: repl Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.000003 Read_Master_Log_Pos: 779387823 Relay_Log_File: ip-172-31-17-237-relay-bin.000002 Relay_Log_Pos: 131551999 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: 131551913 Relay_Log_Space: 779388225 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: 26 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-5255 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: 4006 Slave_Transactional_Groups: 0 1 row in set (0.000 sec) MariaDB [(none)]> show full processlist; +----+-------------+-----------+------+--------------+------+-----------------------------------------------+-----------------------+----------+ | Id | User | Host | db | Command | Time | State | Info | Progress | +----+-------------+-----------+------+--------------+------+-----------------------------------------------+-----------------------+----------+ | 67 | system user | | NULL | Slave_IO | 330 | Waiting for master to send event | NULL | 0.000 | | 69 | system user | | NULL | Slave_worker | 0 | closing tables | NULL | 0.000 | | 70 | system user | | NULL | Slave_worker | 0 | Waiting for prior transaction to commit | NULL | 0.000 | | 71 | system user | | NULL | Slave_worker | 0 | Waiting for prior transaction to commit | NULL | 0.000 | | 72 | system user | | NULL | Slave_worker | 0 | Waiting for prior transaction to commit | NULL | 0.000 | | 68 | system user | | NULL | Slave_SQL | 330 | Waiting for room in worker thread event queue | NULL | 0.000 | | 73 | root | localhost | NULL | Query | 0 | starting | show full processlist | 0.000 | +----+-------------+-----------+------+--------------+------+-----------------------------------------------+-----------------------+----------+ 7 rows in set (0.000 sec) MariaDB [(none)]> show slave status\G *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: 172.31.24.106 Master_User: repl Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.000003 Read_Master_Log_Pos: 779387823 Relay_Log_File: ip-172-31-17-237-relay-bin.000002 Relay_Log_Pos: 176446215 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: 176446129 Relay_Log_Space: 779388225 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: 34 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-5255 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: 4092 Slave_Transactional_Groups: 0 1 row in set (0.000 sec) MariaDB [(none)]> show full processlist; +----+-------------+-----------+------+--------------+------+-----------------------------------------------+-----------------------+----------+ | Id | User | Host | db | Command | Time | State | Info | Progress | +----+-------------+-----------+------+--------------+------+-----------------------------------------------+-----------------------+----------+ | 67 | system user | | NULL | Slave_IO | 340 | Waiting for master to send event | NULL | 0.000 | | 69 | system user | | NULL | Slave_worker | 0 | Waiting for prior transaction to commit | NULL | 0.000 | | 70 | system user | | NULL | Slave_worker | 0 | closing tables | NULL | 0.000 | | 71 | system user | | NULL | Slave_worker | 0 | Waiting for prior transaction to commit | NULL | 0.000 | | 72 | system user | | NULL | Slave_worker | 0 | Waiting for prior transaction to commit | NULL | 0.000 | | 68 | system user | | NULL | Slave_SQL | 340 | Waiting for room in worker thread event queue | NULL | 0.000 | | 73 | root | localhost | NULL | Query | 0 | starting | show full processlist | 0.000 | +----+-------------+-----------+------+--------------+------+-----------------------------------------------+-----------------------+----------+ 7 rows in set (0.000 sec) MariaDB [(none)]> show slave status\G *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: 172.31.24.106 Master_User: repl Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.000004 Read_Master_Log_Pos: 216642276 Relay_Log_File: ip-172-31-17-237-relay-bin.000002 Relay_Log_Pos: 277196353 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: 277196267 Relay_Log_Space: 1290454097 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: 53 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-6238 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: 4285 Slave_Transactional_Groups: 0 1 row in set (0.000 sec) MariaDB [(none)]> show full processlist; +----+-------------+-----------+------+--------------+------+-----------------------------------------------+-----------------------+----------+ | Id | User | Host | db | Command | Time | State | Info | Progress | +----+-------------+-----------+------+--------------+------+-----------------------------------------------+-----------------------+----------+ | 67 | system user | | NULL | Slave_IO | 363 | Queueing master event to the relay log | NULL | 0.000 | | 69 | system user | | NULL | Slave_worker | 0 | closing tables | NULL | 0.000 | | 70 | system user | | NULL | Slave_worker | 0 | Waiting for prior transaction to commit | NULL | 0.000 | | 71 | system user | | NULL | Slave_worker | 0 | Waiting for prior transaction to commit | NULL | 0.000 | | 72 | system user | | NULL | Slave_worker | 0 | Waiting for prior transaction to commit | NULL | 0.000 | | 68 | system user | | NULL | Slave_SQL | 363 | Waiting for room in worker thread event queue | NULL | 0.000 | | 73 | root | localhost | NULL | Query | 0 | starting | show full processlist | 0.000 | +----+-------------+-----------+------+--------------+------+-----------------------------------------------+-----------------------+----------+ 7 rows in set (0.000 sec) MariaDB [(none)]> show full processlist; +----+-------------+-----------+------+--------------+------+-----------------------------------------------+-----------------------+----------+ | Id | User | Host | db | Command | Time | State | Info | Progress | +----+-------------+-----------+------+--------------+------+-----------------------------------------------+-----------------------+----------+ | 67 | system user | | NULL | Slave_IO | 376 | Waiting for master to send event | NULL | 0.000 | | 69 | system user | | NULL | Slave_worker | 0 | Waiting for prior transaction to commit | NULL | 0.000 | | 70 | system user | | NULL | Slave_worker | 0 | Waiting for prior transaction to commit | NULL | 0.000 | | 71 | system user | | NULL | Slave_worker | 0 | closing tables | NULL | 0.000 | | 72 | system user | | NULL | Slave_worker | 0 | Waiting for prior transaction to commit | NULL | 0.000 | | 68 | system user | | NULL | Slave_SQL | 376 | Waiting for room in worker thread event queue | NULL | 0.000 | | 73 | root | localhost | NULL | Query | 0 | starting | show full processlist | 0.000 | +----+-------------+-----------+------+--------------+------+-----------------------------------------------+-----------------------+----------+ 7 rows in set (0.000 sec) MariaDB [(none)]> show slave status\G *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: 172.31.24.106 Master_User: repl Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.000004 Read_Master_Log_Pos: 545521645 Relay_Log_File: ip-172-31-17-237-relay-bin.000002 Relay_Log_Pos: 372729187 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: 372729101 Relay_Log_Space: 1619333466 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: 72 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-6872 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: 4468 Slave_Transactional_Groups: 0 1 row in set (0.000 sec) MariaDB [(none)]> show slave status\G *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: 172.31.24.106 Master_User: repl Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.000004 Read_Master_Log_Pos: 581020707 Relay_Log_File: ip-172-31-17-237-relay-bin.000002 Relay_Log_Pos: 397264653 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: 397264567 Relay_Log_Space: 1654832528 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: 76 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-6940 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: 4515 Slave_Transactional_Groups: 0 1 row in set (0.000 sec) MariaDB [(none)]> show full processlist; +----+-------------+-----------+------+--------------+------+-----------------------------------------------+-----------------------+----------+ | Id | User | Host | db | Command | Time | State | Info | Progress | +----+-------------+-----------+------+--------------+------+-----------------------------------------------+-----------------------+----------+ | 67 | system user | | NULL | Slave_IO | 390 | Waiting for master to send event | NULL | 0.000 | | 69 | system user | | NULL | Slave_worker | 0 | closing tables | NULL | 0.000 | | 70 | system user | | NULL | Slave_worker | 0 | Waiting for prior transaction to commit | NULL | 0.000 | | 71 | system user | | NULL | Slave_worker | 0 | Waiting for prior transaction to commit | NULL | 0.000 | | 72 | system user | | NULL | Slave_worker | 0 | Waiting for prior transaction to commit | NULL | 0.000 | | 68 | system user | | NULL | Slave_SQL | 390 | Waiting for room in worker thread event queue | NULL | 0.000 | | 73 | root | localhost | NULL | Query | 0 | starting | show full processlist | 0.000 | +----+-------------+-----------+------+--------------+------+-----------------------------------------------+-----------------------+----------+ 7 rows in set (0.000 sec) MariaDB [(none)]> show slave status\G *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: 172.31.24.106 Master_User: repl Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.000004 Read_Master_Log_Pos: 732932025 Relay_Log_File: ip-172-31-17-237-relay-bin.000002 Relay_Log_Pos: 440591561 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: 440591475 Relay_Log_Space: 1806743846 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: 84 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-7231 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: 4598 Slave_Transactional_Groups: 0 1 row in set (0.000 sec) MariaDB [(none)]> show full processlist; +----+-------------+-----------+------+--------------+------+-----------------------------------------------+-----------------------+----------+ | Id | User | Host | db | Command | Time | State | Info | Progress | +----+-------------+-----------+------+--------------+------+-----------------------------------------------+-----------------------+----------+ | 67 | system user | | NULL | Slave_IO | 401 | Waiting for master to send event | NULL | 0.000 | | 69 | system user | | NULL | Slave_worker | 0 | Waiting for prior transaction to commit | NULL | 0.000 | | 70 | system user | | NULL | Slave_worker | 0 | Write_rows_log_event::write_row(-1) | NULL | 0.000 | | 71 | system user | | NULL | Slave_worker | 0 | Waiting for prior transaction to commit | NULL | 0.000 | | 72 | system user | | NULL | Slave_worker | 0 | Waiting for prior transaction to commit | NULL | 0.000 | | 68 | system user | | NULL | Slave_SQL | 401 | Waiting for room in worker thread event queue | NULL | 0.000 | | 73 | root | localhost | NULL | Query | 0 | starting | show full processlist | 0.000 | +----+-------------+-----------+------+--------------+------+-----------------------------------------------+-----------------------+----------+ 7 rows in set (0.000 sec) MariaDB [(none)]> show slave status\G *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: 172.31.24.106 Master_User: repl Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.000004 Read_Master_Log_Pos: 874934906 Relay_Log_File: ip-172-31-17-237-relay-bin.000002 Relay_Log_Pos: 544474614 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: 544474528 Relay_Log_Space: 1948746411 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: 104 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-8319 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: 4797 Slave_Transactional_Groups: 0 1 row in set (0.000 sec) MariaDB [(none)]> show slave status\G *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: 172.31.24.106 Master_User: repl Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.000004 Read_Master_Log_Pos: 875780582 Relay_Log_File: ip-172-31-17-237-relay-bin.000002 Relay_Log_Pos: 566921533 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: 566921447 Relay_Log_Space: 1949592087 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: 108 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-10821 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: 4840 Slave_Transactional_Groups: 0 1 row in set (0.000 sec) MariaDB [(none)]> show full processlist; +----+-------------+-----------+------+--------------+------+-----------------------------------------------+-----------------------+----------+ | Id | User | Host | db | Command | Time | State | Info | Progress | +----+-------------+-----------+------+--------------+------+-----------------------------------------------+-----------------------+----------+ | 67 | system user | | NULL | Slave_IO | 430 | Waiting for master to send event | NULL | 0.000 | | 69 | system user | | NULL | Slave_worker | 0 | Waiting for prior transaction to commit | NULL | 0.000 | | 70 | system user | | NULL | Slave_worker | 0 | closing tables | NULL | 0.000 | | 71 | system user | | NULL | Slave_worker | 0 | Waiting for prior transaction to commit | NULL | 0.000 | | 72 | system user | | NULL | Slave_worker | 0 | Waiting for prior transaction to commit | NULL | 0.000 | | 68 | system user | | NULL | Slave_SQL | 8 | Waiting for room in worker thread event queue | NULL | 0.000 | | 73 | root | localhost | NULL | Query | 0 | starting | show full processlist | 0.000 | +----+-------------+-----------+------+--------------+------+-----------------------------------------------+-----------------------+----------+ 7 rows in set (0.000 sec) MariaDB [(none)]> show slave status\G *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: 172.31.24.106 Master_User: repl Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.000004 Read_Master_Log_Pos: 879007130 Relay_Log_File: ip-172-31-17-237-relay-bin.000002 Relay_Log_Pos: 643136394 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: 643136308 Relay_Log_Space: 1952818635 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: 124 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-20367 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: 4986 Slave_Transactional_Groups: 0 1 row in set (0.000 sec) MariaDB [(none)]> show full processlist; +----+-------------+-----------+------+--------------+------+-----------------------------------------------+-----------------------+----------+ | Id | User | Host | db | Command | Time | State | Info | Progress | +----+-------------+-----------+------+--------------+------+-----------------------------------------------+-----------------------+----------+ | 67 | system user | | NULL | Slave_IO | 448 | Waiting for master to send event | NULL | 0.000 | | 69 | system user | | NULL | Slave_worker | 0 | Waiting for prior transaction to commit | NULL | 0.000 | | 70 | system user | | NULL | Slave_worker | 0 | Waiting for prior transaction to commit | NULL | 0.000 | | 71 | system user | | NULL | Slave_worker | 0 | Waiting for prior transaction to commit | NULL | 0.000 | | 72 | system user | | NULL | Slave_worker | 0 | closing tables | NULL | 0.000 | | 68 | system user | | NULL | Slave_SQL | 27 | Waiting for room in worker thread event queue | NULL | 0.000 | | 73 | root | localhost | NULL | Query | 0 | starting | show full processlist | 0.000 | +----+-------------+-----------+------+--------------+------+-----------------------------------------------+-----------------------+----------+ 7 rows in set (0.000 sec) MariaDB [(none)]> show slave status\G *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: 172.31.24.106 Master_User: repl Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.000004 Read_Master_Log_Pos: 882492924 Relay_Log_File: ip-172-31-17-237-relay-bin.000002 Relay_Log_Pos: 721962175 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: 721962089 Relay_Log_Space: 1956304429 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: 139 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-30680 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: 5137 Slave_Transactional_Groups: 0 1 row in set (0.000 sec) MariaDB [(none)]> show full processlist; +----+-------------+-----------+------+--------------+------+-----------------------------------------------+-----------------------+----------+ | Id | User | Host | db | Command | Time | State | Info | Progress | +----+-------------+-----------+------+--------------+------+-----------------------------------------------+-----------------------+----------+ | 67 | system user | | NULL | Slave_IO | 466 | Waiting for master to send event | NULL | 0.000 | | 69 | system user | | NULL | Slave_worker | 0 | Waiting for prior transaction to commit | NULL | 0.000 | | 70 | system user | | NULL | Slave_worker | 0 | closing tables | NULL | 0.000 | | 71 | system user | | NULL | Slave_worker | 0 | Waiting for prior transaction to commit | NULL | 0.000 | | 72 | system user | | NULL | Slave_worker | 0 | Waiting for prior transaction to commit | NULL | 0.000 | | 68 | system user | | NULL | Slave_SQL | 45 | Waiting for room in worker thread event queue | NULL | 0.000 | | 73 | root | localhost | NULL | Query | 0 | starting | show full processlist | 0.000 | +----+-------------+-----------+------+--------------+------+-----------------------------------------------+-----------------------+----------+ 7 rows in set (0.000 sec) MariaDB [(none)]> show slave status\G *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: 172.31.24.106 Master_User: repl Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.000004 Read_Master_Log_Pos: 883983504 Relay_Log_File: ip-172-31-17-237-relay-bin.000002 Relay_Log_Pos: 756416491 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: 756416405 Relay_Log_Space: 1957795009 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: 145 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-35090 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: 5203 Slave_Transactional_Groups: 0 1 row in set (0.000 sec) MariaDB [(none)]> show full processlist; +----+-------------+-----------+------+--------------+------+-----------------------------------------------+-----------------------+----------+ | Id | User | Host | db | Command | Time | State | Info | Progress | +----+-------------+-----------+------+--------------+------+-----------------------------------------------+-----------------------+----------+ | 67 | system user | | NULL | Slave_IO | 474 | Queueing master event to the relay log | NULL | 0.000 | | 69 | system user | | NULL | Slave_worker | 0 | closing tables | NULL | 0.000 | | 70 | system user | | NULL | Slave_worker | 0 | Waiting for prior transaction to commit | NULL | 0.000 | | 71 | system user | | NULL | Slave_worker | 0 | Waiting for prior transaction to commit | NULL | 0.000 | | 72 | system user | | NULL | Slave_worker | 0 | Waiting for prior transaction to commit | NULL | 0.000 | | 68 | system user | | NULL | Slave_SQL | 52 | Waiting for room in worker thread event queue | NULL | 0.000 | | 73 | root | localhost | NULL | Query | 0 | starting | show full processlist | 0.000 | +----+-------------+-----------+------+--------------+------+-----------------------------------------------+-----------------------+----------+ 7 rows in set (0.000 sec) MariaDB [(none)]> show slave status\G *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: 172.31.24.106 Master_User: repl Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.000004 Read_Master_Log_Pos: 887311114 Relay_Log_File: ip-172-31-17-237-relay-bin.000002 Relay_Log_Pos: 809143835 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: 809143749 Relay_Log_Space: 1961122619 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: 150 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-44935 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: 5309 Slave_Transactional_Groups: 0 1 row in set (0.000 sec) MariaDB [(none)]> show full processlist; +----+-------------+-----------+------+--------------+------+-----------------------------------------------+-----------------------+----------+ | Id | User | Host | db | Command | Time | State | Info | Progress | +----+-------------+-----------+------+--------------+------+-----------------------------------------------+-----------------------+----------+ | 67 | system user | | NULL | Slave_IO | 493 | Waiting for master to send event | NULL | 0.000 | | 69 | system user | | NULL | Slave_worker | 0 | Waiting for prior transaction to commit | NULL | 0.000 | | 70 | system user | | NULL | Slave_worker | 0 | Waiting for prior transaction to commit | NULL | 0.000 | | 71 | system user | | NULL | Slave_worker | 0 | closing tables | NULL | 0.000 | | 72 | system user | | NULL | Slave_worker | 0 | Waiting for prior transaction to commit | NULL | 0.000 | | 68 | system user | | NULL | Slave_SQL | 72 | Waiting for room in worker thread event queue | NULL | 0.000 | | 73 | root | localhost | NULL | Query | 0 | starting | show full processlist | 0.000 | +----+-------------+-----------+------+--------------+------+-----------------------------------------------+-----------------------+----------+ 7 rows in set (0.000 sec) MariaDB [(none)]> show slave status\G *************************** 1. row *************************** Slave_IO_State: Queueing master event to the relay log Master_Host: 172.31.24.106 Master_User: repl Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.000004 Read_Master_Log_Pos: 888706716 Relay_Log_File: ip-172-31-17-237-relay-bin.000002 Relay_Log_Pos: 840986097 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: 840986011 Relay_Log_Space: 1962518221 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: 156 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-49064 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: 5370 Slave_Transactional_Groups: 0 1 row in set (0.004 sec) MariaDB [(none)]> show slave status\G *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: 172.31.24.106 Master_User: repl Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.000004 Read_Master_Log_Pos: 889506762 Relay_Log_File: ip-172-31-17-237-relay-bin.000002 Relay_Log_Pos: 862911021 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: 862910935 Relay_Log_Space: 1963318267 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: 160 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-51431 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: 5412 Slave_Transactional_Groups: 0 1 row in set (0.000 sec) MariaDB [(none)]> show full processlist; +----+-------------+-----------+------+--------------+------+-----------------------------------------------+-----------------------+----------+ | Id | User | Host | db | Command | Time | State | Info | Progress | +----+-------------+-----------+------+--------------+------+-----------------------------------------------+-----------------------+----------+ | 67 | system user | | NULL | Slave_IO | 505 | Waiting for master to send event | NULL | 0.000 | | 69 | system user | | NULL | Slave_worker | 0 | Waiting for prior transaction to commit | NULL | 0.000 | | 70 | system user | | NULL | Slave_worker | 0 | Waiting for prior transaction to commit | NULL | 0.000 | | 71 | system user | | NULL | Slave_worker | 0 | closing tables | NULL | 0.000 | | 72 | system user | | NULL | Slave_worker | 0 | Waiting for prior transaction to commit | NULL | 0.000 | | 68 | system user | | NULL | Slave_SQL | 84 | Waiting for room in worker thread event queue | NULL | 0.000 | | 73 | root | localhost | NULL | Query | 0 | starting | show full processlist | 0.000 | +----+-------------+-----------+------+--------------+------+-----------------------------------------------+-----------------------+----------+ 7 rows in set (0.000 sec) MariaDB [(none)]> show slave status\G *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: 172.31.24.106 Master_User: repl Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.000004 Read_Master_Log_Pos: 889720716 Relay_Log_File: ip-172-31-17-237-relay-bin.000002 Relay_Log_Pos: 889012661 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: 889012575 Relay_Log_Space: 1963532221 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: 165 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-52064 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: 5462 Slave_Transactional_Groups: 0 1 row in set (0.000 sec) MariaDB [(none)]> show full processlist; +----+-------------+-----------+------+--------------+------+-----------------------------------------------+-----------------------+----------+ | Id | User | Host | db | Command | Time | State | Info | Progress | +----+-------------+-----------+------+--------------+------+-----------------------------------------------+-----------------------+----------+ | 67 | system user | | NULL | Slave_IO | 513 | Waiting for master to send event | NULL | 0.000 | | 69 | system user | | NULL | Slave_worker | 0 | Waiting for prior transaction to commit | NULL | 0.000 | | 70 | system user | | NULL | Slave_worker | 0 | Waiting for prior transaction to commit | NULL | 0.000 | | 71 | system user | | NULL | Slave_worker | 0 | closing tables | NULL | 0.000 | | 72 | system user | | NULL | Slave_worker | 0 | Waiting for prior transaction to commit | NULL | 0.000 | | 68 | system user | | NULL | Slave_SQL | 92 | Waiting for room in worker thread event queue | NULL | 0.000 | | 73 | root | localhost | NULL | Query | 0 | starting | show full processlist | 0.000 | +----+-------------+-----------+------+--------------+------+-----------------------------------------------+-----------------------+----------+ 7 rows in set (0.000 sec) MariaDB [(none)]> show full processlist; +----+-------------+-----------+------+--------------+------+--------------------------------------------------------+-----------------------+----------+ | Id | User | Host | db | Command | Time | State | Info | Progress | +----+-------------+-----------+------+--------------+------+--------------------------------------------------------+-----------------------+----------+ | 67 | system user | | NULL | Slave_IO | 689 | Waiting for master to send event | NULL | 0.000 | | 69 | system user | | NULL | Slave_worker | 0 | closing tables | NULL | 0.000 | | 70 | system user | | NULL | Slave_worker | 0 | Waiting for prior transaction to commit | NULL | 0.000 | | 71 | system user | | NULL | Slave_worker | 0 | Waiting for prior transaction to commit | NULL | 0.000 | | 72 | system user | | NULL | Slave_worker | 0 | Waiting for prior transaction to commit | NULL | 0.000 | | 68 | system user | | NULL | Slave_SQL | 268 | Slave has read all relay log; waiting for more updates | NULL | 0.000 | | 73 | root | localhost | NULL | Query | 0 | starting | show full processlist | 0.000 | +----+-------------+-----------+------+--------------+------+--------------------------------------------------------+-----------------------+----------+ 7 rows in set (0.000 sec) MariaDB [(none)]> show slave status\G *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: 172.31.24.106 Master_User: repl Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.000004 Read_Master_Log_Pos: 891647654 Relay_Log_File: ip-172-31-17-237-relay-bin.000005 Relay_Log_Pos: 600335951 Relay_Master_Log_File: mysql-bin.000004 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: 600335656 Relay_Log_Space: 1965459159 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: 306 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-57765 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: 6970 Slave_Transactional_Groups: 0 1 row in set (0.000 sec) MariaDB [(none)]> show slave status\G *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: 172.31.24.106 Master_User: repl Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.000004 Read_Master_Log_Pos: 891647654 Relay_Log_File: ip-172-31-17-237-relay-bin.000005 Relay_Log_Pos: 611820408 Relay_Master_Log_File: mysql-bin.000004 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: 611820113 Relay_Log_Space: 1965459159 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: 308 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-57765 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: 6992 Slave_Transactional_Groups: 0 1 row in set (0.000 sec) MariaDB [(none)]> show slave status\G *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: 172.31.24.106 Master_User: repl Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.000004 Read_Master_Log_Pos: 891647654 Relay_Log_File: ip-172-31-17-237-relay-bin.000005 Relay_Log_Pos: 616518930 Relay_Master_Log_File: mysql-bin.000004 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: 616518635 Relay_Log_Space: 1965459159 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: 308 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-57765 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: 7001 Slave_Transactional_Groups: 0 1 row in set (0.000 sec) MariaDB [(none)]> show slave status\G *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: 172.31.24.106 Master_User: repl Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.000004 Read_Master_Log_Pos: 891647654 Relay_Log_File: ip-172-31-17-237-relay-bin.000005 Relay_Log_Pos: 620695079 Relay_Master_Log_File: mysql-bin.000004 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: 620694784 Relay_Log_Space: 1965459159 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: 309 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-57765 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: 7009 Slave_Transactional_Groups: 0 1 row in set (0.000 sec) MariaDB [(none)]> show slave status\G *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: 172.31.24.106 Master_User: repl Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.000004 Read_Master_Log_Pos: 891647654 Relay_Log_File: ip-172-31-17-237-relay-bin.000005 Relay_Log_Pos: 624871228 Relay_Master_Log_File: mysql-bin.000004 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: 624870933 Relay_Log_Space: 1965459159 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: 310 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-57765 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: 7017 Slave_Transactional_Groups: 0 1 row in set (0.000 sec) MariaDB [(none)]> show slave status\G *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: 172.31.24.106 Master_User: repl Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.000004 Read_Master_Log_Pos: 891647654 Relay_Log_File: ip-172-31-17-237-relay-bin.000005 Relay_Log_Pos: 629047566 Relay_Master_Log_File: mysql-bin.000004 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: 629047271 Relay_Log_Space: 1965459159 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: 311 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-57765 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: 7025 Slave_Transactional_Groups: 0 1 row in set (0.000 sec) MariaDB [(none)]> show full processlist; +----+-------------+-----------+------+--------------+------+--------------------------------------------------------+-----------------------+----------+ | Id | User | Host | db | Command | Time | State | Info | Progress | +----+-------------+-----------+------+--------------+------+--------------------------------------------------------+-----------------------+----------+ | 67 | system user | | NULL | Slave_IO | 707 | Waiting for master to send event | NULL | 0.000 | | 69 | system user | | NULL | Slave_worker | 0 | Waiting for prior transaction to commit | NULL | 0.000 | | 70 | system user | | NULL | Slave_worker | 0 | closing tables | NULL | 0.000 | | 71 | system user | | NULL | Slave_worker | 0 | Waiting for prior transaction to commit | NULL | 0.000 | | 72 | system user | | NULL | Slave_worker | 0 | Waiting for prior transaction to commit | NULL | 0.000 | | 68 | system user | | NULL | Slave_SQL | 286 | Slave has read all relay log; waiting for more updates | NULL | 0.000 | | 73 | root | localhost | NULL | Query | 0 | starting | show full processlist | 0.000 | +----+-------------+-----------+------+--------------+------+--------------------------------------------------------+-----------------------+----------+ 7 rows in set (0.000 sec) MariaDB [(none)]> show full processlist; +----+-------------+-----------+------+--------------+------+--------------------------------------------------------+-----------------------+----------+ | Id | User | Host | db | Command | Time | State | Info | Progress | +----+-------------+-----------+------+--------------+------+--------------------------------------------------------+-----------------------+----------+ | 67 | system user | | NULL | Slave_IO | 710 | Waiting for master to send event | NULL | 0.000 | | 69 | system user | | NULL | Slave_worker | 0 | Waiting for prior transaction to commit | NULL | 0.000 | | 70 | system user | | NULL | Slave_worker | 0 | Waiting for prior transaction to commit | NULL | 0.000 | | 71 | system user | | NULL | Slave_worker | 0 | Waiting for prior transaction to commit | NULL | 0.000 | | 72 | system user | | NULL | Slave_worker | 0 | closing tables | NULL | 0.000 | | 68 | system user | | NULL | Slave_SQL | 289 | Slave has read all relay log; waiting for more updates | NULL | 0.000 | | 73 | root | localhost | NULL | Query | 0 | starting | show full processlist | 0.000 | +----+-------------+-----------+------+--------------+------+--------------------------------------------------------+-----------------------+----------+ 7 rows in set (0.000 sec) MariaDB [(none)]> show full processlist; +----+-------------+-----------+------+--------------+------+--------------------------------------------------------+-----------------------+----------+ | Id | User | Host | db | Command | Time | State | Info | Progress | +----+-------------+-----------+------+--------------+------+--------------------------------------------------------+-----------------------+----------+ | 67 | system user | | NULL | Slave_IO | 711 | Waiting for master to send event | NULL | 0.000 | | 69 | system user | | NULL | Slave_worker | 0 | closing tables | NULL | 0.000 | | 70 | system user | | NULL | Slave_worker | 0 | Waiting for prior transaction to commit | NULL | 0.000 | | 71 | system user | | NULL | Slave_worker | 0 | Waiting for prior transaction to commit | NULL | 0.000 | | 72 | system user | | NULL | Slave_worker | 0 | Waiting for prior transaction to commit | NULL | 0.000 | | 68 | system user | | NULL | Slave_SQL | 290 | Slave has read all relay log; waiting for more updates | NULL | 0.000 | | 73 | root | localhost | NULL | Query | 0 | starting | show full processlist | 0.000 | +----+-------------+-----------+------+--------------+------+--------------------------------------------------------+-----------------------+----------+ 7 rows in set (0.000 sec) MariaDB [(none)]> show full processlist; +----+-------------+-----------+------+--------------+------+--------------------------------------------------------+-----------------------+----------+ | Id | User | Host | db | Command | Time | State | Info | Progress | +----+-------------+-----------+------+--------------+------+--------------------------------------------------------+-----------------------+----------+ | 67 | system user | | NULL | Slave_IO | 713 | Waiting for master to send event | NULL | 0.000 | | 69 | system user | | NULL | Slave_worker | 0 | Waiting for prior transaction to commit | NULL | 0.000 | | 70 | system user | | NULL | Slave_worker | 0 | Waiting for prior transaction to commit | NULL | 0.000 | | 71 | system user | | NULL | Slave_worker | 0 | Waiting for prior transaction to commit | NULL | 0.000 | | 72 | system user | | NULL | Slave_worker | 0 | closing tables | NULL | 0.000 | | 68 | system user | | NULL | Slave_SQL | 292 | Slave has read all relay log; waiting for more updates | NULL | 0.000 | | 73 | root | localhost | NULL | Query | 0 | starting | show full processlist | 0.000 | +----+-------------+-----------+------+--------------+------+--------------------------------------------------------+-----------------------+----------+ 7 rows in set (0.000 sec) MariaDB [(none)]> show full processlist; +----+-------------+-----------+------+--------------+------+--------------------------------------------------------+-----------------------+----------+ | Id | User | Host | db | Command | Time | State | Info | Progress | +----+-------------+-----------+------+--------------+------+--------------------------------------------------------+-----------------------+----------+ | 67 | system user | | NULL | Slave_IO | 714 | Waiting for master to send event | NULL | 0.000 | | 69 | system user | | NULL | Slave_worker | 0 | Waiting for prior transaction to commit | NULL | 0.000 | | 70 | system user | | NULL | Slave_worker | 0 | Waiting for prior transaction to commit | NULL | 0.000 | | 71 | system user | | NULL | Slave_worker | 0 | Waiting for prior transaction to commit | NULL | 0.000 | | 72 | system user | | NULL | Slave_worker | 0 | closing tables | NULL | 0.000 | | 68 | system user | | NULL | Slave_SQL | 293 | Slave has read all relay log; waiting for more updates | NULL | 0.000 | | 73 | root | localhost | NULL | Query | 0 | starting | show full processlist | 0.000 | +----+-------------+-----------+------+--------------+------+--------------------------------------------------------+-----------------------+----------+ 7 rows in set (0.000 sec) MariaDB [(none)]> show full processlist; +----+-------------+-----------+------+--------------+------+--------------------------------------------------------+-----------------------+----------+ | Id | User | Host | db | Command | Time | State | Info | Progress | +----+-------------+-----------+------+--------------+------+--------------------------------------------------------+-----------------------+----------+ | 67 | system user | | NULL | Slave_IO | 715 | Waiting for master to send event | NULL | 0.000 | | 69 | system user | | NULL | Slave_worker | 0 | Waiting for prior transaction to commit | NULL | 0.000 | | 70 | system user | | NULL | Slave_worker | 0 | Waiting for prior transaction to commit | NULL | 0.000 | | 71 | system user | | NULL | Slave_worker | 0 | Waiting for prior transaction to commit | NULL | 0.000 | | 72 | system user | | NULL | Slave_worker | 0 | closing tables | NULL | 0.000 | | 68 | system user | | NULL | Slave_SQL | 294 | Slave has read all relay log; waiting for more updates | NULL | 0.000 | | 73 | root | localhost | NULL | Query | 0 | starting | show full processlist | 0.000 | +----+-------------+-----------+------+--------------+------+--------------------------------------------------------+-----------------------+----------+ 7 rows in set (0.000 sec) MariaDB [(none)]> show full processlist; +----+-------------+-----------+------+--------------+------+--------------------------------------------------------+-----------------------+----------+ | Id | User | Host | db | Command | Time | State | Info | Progress | +----+-------------+-----------+------+--------------+------+--------------------------------------------------------+-----------------------+----------+ | 67 | system user | | NULL | Slave_IO | 716 | Waiting for master to send event | NULL | 0.000 | | 69 | system user | | NULL | Slave_worker | 0 | Waiting for prior transaction to commit | NULL | 0.000 | | 70 | system user | | NULL | Slave_worker | 0 | Waiting for prior transaction to commit | NULL | 0.000 | | 71 | system user | | NULL | Slave_worker | 0 | Waiting for prior transaction to commit | NULL | 0.000 | | 72 | system user | | NULL | Slave_worker | 0 | closing tables | NULL | 0.000 | | 68 | system user | | NULL | Slave_SQL | 295 | Slave has read all relay log; waiting for more updates | NULL | 0.000 | | 73 | root | localhost | NULL | Query | 0 | starting | show full processlist | 0.000 | +----+-------------+-----------+------+--------------+------+--------------------------------------------------------+-----------------------+----------+ 7 rows in set (0.000 sec) MariaDB [(none)]> show full processlist; +----+-------------+-----------+------+--------------+------+--------------------------------------------------------+-----------------------+----------+ | Id | User | Host | db | Command | Time | State | Info | Progress | +----+-------------+-----------+------+--------------+------+--------------------------------------------------------+-----------------------+----------+ | 67 | system user | | NULL | Slave_IO | 717 | Waiting for master to send event | NULL | 0.000 | | 69 | system user | | NULL | Slave_worker | 0 | Waiting for prior transaction to commit | NULL | 0.000 | | 70 | system user | | NULL | Slave_worker | 0 | Waiting for prior transaction to commit | NULL | 0.000 | | 71 | system user | | NULL | Slave_worker | 0 | Waiting for prior transaction to commit | NULL | 0.000 | | 72 | system user | | NULL | Slave_worker | 0 | closing tables | NULL | 0.000 | | 68 | system user | | NULL | Slave_SQL | 296 | Slave has read all relay log; waiting for more updates | NULL | 0.000 | | 73 | root | localhost | NULL | Query | 0 | starting | show full processlist | 0.000 | +----+-------------+-----------+------+--------------+------+--------------------------------------------------------+-----------------------+----------+ 7 rows in set (0.000 sec) MariaDB [(none)]> show full processlist; +----+-------------+-----------+------+--------------+------+--------------------------------------------------------+-----------------------+----------+ | Id | User | Host | db | Command | Time | State | Info | Progress | +----+-------------+-----------+------+--------------+------+--------------------------------------------------------+-----------------------+----------+ | 67 | system user | | NULL | Slave_IO | 718 | Waiting for master to send event | NULL | 0.000 | | 69 | system user | | NULL | Slave_worker | 0 | Waiting for prior transaction to commit | NULL | 0.000 | | 70 | system user | | NULL | Slave_worker | 0 | Waiting for prior transaction to commit | NULL | 0.000 | | 71 | system user | | NULL | Slave_worker | 0 | Waiting for prior transaction to commit | NULL | 0.000 | | 72 | system user | | NULL | Slave_worker | 0 | closing tables | NULL | 0.000 | | 68 | system user | | NULL | Slave_SQL | 296 | Slave has read all relay log; waiting for more updates | NULL | 0.000 | | 73 | root | localhost | NULL | Query | 0 | starting | show full processlist | 0.000 | +----+-------------+-----------+------+--------------+------+--------------------------------------------------------+-----------------------+----------+ 7 rows in set (0.000 sec) MariaDB [(none)]> show full processlist; +----+-------------+-----------+------+--------------+------+--------------------------------------------------------+-----------------------+----------+ | Id | User | Host | db | Command | Time | State | Info | Progress | +----+-------------+-----------+------+--------------+------+--------------------------------------------------------+-----------------------+----------+ | 67 | system user | | NULL | Slave_IO | 718 | Waiting for master to send event | NULL | 0.000 | | 69 | system user | | NULL | Slave_worker | 0 | Waiting for prior transaction to commit | NULL | 0.000 | | 70 | system user | | NULL | Slave_worker | 0 | closing tables | NULL | 0.000 | | 71 | system user | | NULL | Slave_worker | 0 | Waiting for prior transaction to commit | NULL | 0.000 | | 72 | system user | | NULL | Slave_worker | 0 | Waiting for prior transaction to commit | NULL | 0.000 | | 68 | system user | | NULL | Slave_SQL | 297 | Slave has read all relay log; waiting for more updates | NULL | 0.000 | | 73 | root | localhost | NULL | Query | 0 | starting | show full processlist | 0.000 | +----+-------------+-----------+------+--------------+------+--------------------------------------------------------+-----------------------+----------+ 7 rows in set (0.000 sec) MariaDB [(none)]> show full processlist; +----+-------------+-----------+------+--------------+------+--------------------------------------------------------+-----------------------+----------+ | Id | User | Host | db | Command | Time | State | Info | Progress | +----+-------------+-----------+------+--------------+------+--------------------------------------------------------+-----------------------+----------+ | 67 | system user | | NULL | Slave_IO | 719 | Waiting for master to send event | NULL | 0.000 | | 69 | system user | | NULL | Slave_worker | 0 | Waiting for prior transaction to commit | NULL | 0.000 | | 70 | system user | | NULL | Slave_worker | 0 | Waiting for prior transaction to commit | NULL | 0.000 | | 71 | system user | | NULL | Slave_worker | 0 | closing tables | NULL | 0.000 | | 72 | system user | | NULL | Slave_worker | 0 | Waiting for prior transaction to commit | NULL | 0.000 | | 68 | system user | | NULL | Slave_SQL | 298 | Slave has read all relay log; waiting for more updates | NULL | 0.000 | | 73 | root | localhost | NULL | Query | 0 | starting | show full processlist | 0.000 | +----+-------------+-----------+------+--------------+------+--------------------------------------------------------+-----------------------+----------+ 7 rows in set (0.000 sec) MariaDB [(none)]> show full processlist; +----+-------------+-----------+------+--------------+------+--------------------------------------------------------+-----------------------+----------+ | Id | User | Host | db | Command | Time | State | Info | Progress | +----+-------------+-----------+------+--------------+------+--------------------------------------------------------+-----------------------+----------+ | 67 | system user | | NULL | Slave_IO | 720 | Waiting for master to send event | NULL | 0.000 | | 69 | system user | | NULL | Slave_worker | 0 | closing tables | NULL | 0.000 | | 70 | system user | | NULL | Slave_worker | 0 | Waiting for prior transaction to commit | NULL | 0.000 | | 71 | system user | | NULL | Slave_worker | 0 | Waiting for prior transaction to commit | NULL | 0.000 | | 72 | system user | | NULL | Slave_worker | 0 | Waiting for prior transaction to commit | NULL | 0.000 | | 68 | system user | | NULL | Slave_SQL | 299 | Slave has read all relay log; waiting for more updates | NULL | 0.000 | | 73 | root | localhost | NULL | Query | 0 | starting | show full processlist | 0.000 | +----+-------------+-----------+------+--------------+------+--------------------------------------------------------+-----------------------+----------+ 7 rows in set (0.000 sec) MariaDB [(none)]> show full processlist; +----+-------------+-----------+------+--------------+------+--------------------------------------------------------+-----------------------+----------+ | Id | User | Host | db | Command | Time | State | Info | Progress | +----+-------------+-----------+------+--------------+------+--------------------------------------------------------+-----------------------+----------+ | 67 | system user | | NULL | Slave_IO | 721 | Waiting for master to send event | NULL | 0.000 | | 69 | system user | | NULL | Slave_worker | 0 | Waiting for prior transaction to commit | NULL | 0.000 | | 70 | system user | | NULL | Slave_worker | 0 | Waiting for prior transaction to commit | NULL | 0.000 | | 71 | system user | | NULL | Slave_worker | 0 | closing tables | NULL | 0.000 | | 72 | system user | | NULL | Slave_worker | 0 | Waiting for prior transaction to commit | NULL | 0.000 | | 68 | system user | | NULL | Slave_SQL | 300 | Slave has read all relay log; waiting for more updates | NULL | 0.000 | | 73 | root | localhost | NULL | Query | 0 | starting | show full processlist | 0.000 | +----+-------------+-----------+------+--------------+------+--------------------------------------------------------+-----------------------+----------+ 7 rows in set (0.000 sec) MariaDB [(none)]> show full processlist; +----+-------------+-----------+------+--------------+------+--------------------------------------------------------+-----------------------+----------+ | Id | User | Host | db | Command | Time | State | Info | Progress | +----+-------------+-----------+------+--------------+------+--------------------------------------------------------+-----------------------+----------+ | 67 | system user | | NULL | Slave_IO | 726 | Waiting for master to send event | NULL | 0.000 | | 69 | system user | | NULL | Slave_worker | 0 | Waiting for prior transaction to commit | NULL | 0.000 | | 70 | system user | | NULL | Slave_worker | 0 | Waiting for prior transaction to commit | NULL | 0.000 | | 71 | system user | | NULL | Slave_worker | 0 | closing tables | NULL | 0.000 | | 72 | system user | | NULL | Slave_worker | 0 | Waiting for prior transaction to commit | NULL | 0.000 | | 68 | system user | | NULL | Slave_SQL | 305 | Slave has read all relay log; waiting for more updates | NULL | 0.000 | | 73 | root | localhost | NULL | Query | 0 | starting | show full processlist | 0.000 | +----+-------------+-----------+------+--------------+------+--------------------------------------------------------+-----------------------+----------+ 7 rows in set (0.000 sec) MariaDB [(none)]> show slave status\G *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: 172.31.24.106 Master_User: repl Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.000004 Read_Master_Log_Pos: 891647654 Relay_Log_File: ip-172-31-17-237-relay-bin.000005 Relay_Log_Pos: 754335249 Relay_Master_Log_File: mysql-bin.000004 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: 754334954 Relay_Log_Space: 1965459159 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: 331 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-57765 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: 7265 Slave_Transactional_Groups: 0 1 row in set (0.000 sec) MariaDB [(none)]> show slave status\G *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: 172.31.24.106 Master_User: repl Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.000004 Read_Master_Log_Pos: 891647654 Relay_Log_File: ip-172-31-17-237-relay-bin.000005 Relay_Log_Pos: 759555388 Relay_Master_Log_File: mysql-bin.000004 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: 759555093 Relay_Log_Space: 1965459159 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: 332 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-57765 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: 7275 Slave_Transactional_Groups: 0 1 row in set (0.000 sec) MariaDB [(none)]> show slave status\G *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: 172.31.24.106 Master_User: repl Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.000004 Read_Master_Log_Pos: 891647654 Relay_Log_File: ip-172-31-17-237-relay-bin.000005 Relay_Log_Pos: 763731348 Relay_Master_Log_File: mysql-bin.000004 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: 763731053 Relay_Log_Space: 1965459159 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: 333 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-57765 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: 7283 Slave_Transactional_Groups: 0 1 row in set (0.000 sec) [root@ip-172-31-17-237 centos]# iostat -dx 1 Linux 3.10.0-1062.9.1.el7.x86_64 (ip-172-31-17-237.ec2.internal) 08/11/2021 _x86_64_ (4 CPU) Device: rrqm/s wrqm/s r/s w/s rkB/s wkB/s avgrq-sz avgqu-sz await r_await w_await svctm %util xvda 0.00 2.61 3.67 69.36 115.37 7462.12 207.52 1.36 18.57 3.56 19.36 0.44 3.24 Device: rrqm/s wrqm/s r/s w/s rkB/s wkB/s avgrq-sz avgqu-sz await r_await w_await svctm %util xvda 0.00 0.00 0.00 10.00 0.00 128.00 25.60 0.01 0.90 0.00 0.90 0.90 0.90 Device: rrqm/s wrqm/s r/s w/s rkB/s wkB/s avgrq-sz avgqu-sz await r_await w_await svctm %util xvda 0.00 0.00 0.00 10.00 0.00 132.00 26.40 0.01 0.70 0.00 0.70 0.70 0.70 Device: rrqm/s wrqm/s r/s w/s rkB/s wkB/s avgrq-sz avgqu-sz await r_await w_await svctm %util xvda 0.00 0.00 0.00 9.00 0.00 116.00 25.78 0.01 0.67 0.00 0.67 0.67 0.60 Device: rrqm/s wrqm/s r/s w/s rkB/s wkB/s avgrq-sz avgqu-sz await r_await w_await svctm %util xvda 0.00 0.00 0.00 13.00 0.00 152.00 23.38 0.01 0.85 0.00 0.85 0.85 1.10 Device: rrqm/s wrqm/s r/s w/s rkB/s wkB/s avgrq-sz avgqu-sz await r_await w_await svctm %util xvda 0.00 0.00 0.00 29.00 0.00 1640.00 113.10 0.05 1.69 0.00 1.69 0.38 1.10 Device: rrqm/s wrqm/s r/s w/s rkB/s wkB/s avgrq-sz avgqu-sz await r_await w_await svctm %util xvda 0.00 0.00 0.00 10.00 0.00 124.00 24.80 0.01 0.70 0.00 0.70 0.70 0.70 Device: rrqm/s wrqm/s r/s w/s rkB/s wkB/s avgrq-sz avgqu-sz await r_await w_await svctm %util xvda 0.00 0.00 0.00 10.00 0.00 136.00 27.20 0.01 0.80 0.00 0.80 0.80 0.80 MariaDB [(none)]> MariaDB [(none)]> MariaDB [(none)]> show slave status\G *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: 172.31.24.106 Master_User: repl Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.000004 Read_Master_Log_Pos: 891647654 Relay_Log_File: ip-172-31-17-237-relay-bin.000005 Relay_Log_Pos: 874734767 Relay_Master_Log_File: mysql-bin.000004 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: 874734472 Relay_Log_Space: 1965459159 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: 365 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-57765 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: 7719 Slave_Transactional_Groups: 0 1 row in set (0.002 sec) MariaDB [(none)]> show slave status\G *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: 172.31.24.106 Master_User: repl Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.000004 Read_Master_Log_Pos: 891647654 Relay_Log_File: ip-172-31-17-237-relay-bin.000005 Relay_Log_Pos: 874738823 Relay_Master_Log_File: mysql-bin.000004 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: 874738528 Relay_Log_Space: 1965459159 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: 366 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-57765 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: 7731 Slave_Transactional_Groups: 0 1 row in set (0.000 sec) MariaDB [(none)]> show slave status\G *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: 172.31.24.106 Master_User: repl Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.000004 Read_Master_Log_Pos: 891647654 Relay_Log_File: ip-172-31-17-237-relay-bin.000005 Relay_Log_Pos: 874742203 Relay_Master_Log_File: mysql-bin.000004 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: 874741908 Relay_Log_Space: 1965459159 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: 367 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-57765 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: 7741 Slave_Transactional_Groups: 0 1 row in set (0.000 sec)