Group Replication: Transction Hanged

Question

I have configured group replication on mysql 5.7.22 and I found if insert 10k rows then its work fine but once I increase transaction rows upto 20k then its hanged my instance and still not available for any work. I am simple running this statement.

insert into test select * from test1 limit 20000

Answer 1

You should not use large transactions.

If an individual transaction results in message contents which are large enough that the message cannot be copied between group members over the network within a 5-second window, members can be suspected of having failed, and then expelled, just because they are busy processing the transaction. Large transactions can also cause the system to slow due to problems with memory allocation.

You can check the full text on mysql page. Group Replication Limitations