Advanced MySQL 8

replication_group_member_stats

This table contains statistics for two processes: certifier and applier. It is helpful to maintain flow control for group replication for every member in the group. The stats related to the transactions, which are checked for conflict, need to be applied helps the certifier process to manage its workload. As well as transactions that are certified but need to be executed on local helps applier process to manage workloads.

For each member of the group, it tries to keep the following information:

• Count_transactions_in_queue
• Count_transactions_checked
• Count_conflict_detected
• Count_transactions_rows_validating
• Transaction_committed_all_members ( periodic update )
• Last_conflict_free_transaction
• Count_transactions_remote_in_applier_queue ...