Group Replication – Extending Group Replication performance_schema tables

  • in Blog Posts
  • by
  • 21 7 月, 2017
  • 在〈Group Replication – Extending Group Replication performance_schema tables〉中留言功能已關閉

mysql> select * from performance_schema.replication_group_member_statsG

*************************** 1. row ***************************

CHANNEL_NAME: group_replication_applier

VIEW_ID: 15003908034996377:3

MEMBER_ID: a21badd56bcb11e7928ef0d5bf747fb1

COUNT_TRANSACTIONS_IN_QUEUE: 0

COUNT_TRANSACTIONS_CHECKED: 14

COUNT_CONFLICTS_DETECTED: 1

COUNT_TRANSACTIONS_ROWS_VALIDATING: 0

TRANSACTIONS_COMMITTED_ALL_MEMBERS: a2f9372b6bcb11e7928ef0d5bf747fb1:16:10000031000012

LAST_CONFLICT_FREE_TRANSACTION: a2f9372b6bcb11e7928ef0d5bf747fb1:1000012

COUNT_TRANSACTIONS_REMOTE_IN_APPLIER_QUEUE: 0

COUNT_TRANSACTIONS_REMOTE_APPLIED: 10

COUNT_TRANSACTIONS_LOCAL_PROPOSED: 4

COUNT_TRANSACTIONS_LOCAL_ROLLBACK: 1

*************************** 2. row ***************************

CHANNEL_NAME: group_replication_applier

VIEW_ID: 15003908034996377:3

MEMBER_ID: a256fdee6bcb11e7922df0d5bf747fb1

COUNT_TRANSACTIONS_IN_QUEUE: 0

COUNT_TRANSACTIONS_CHECKED: 14

COUNT_CONFLICTS_DETECTED: 1

COUNT_TRANSACTIONS_ROWS_VALIDATING: 0

TRANSACTIONS_COMMITTED_ALL_MEMBERS: a2f9372b6bcb11e7928ef0d5bf747fb1:16:10000031000012

LAST_CONFLICT_FREE_TRANSACTION: a2f9372b6bcb11e7928ef0d5bf747fb1:1000012

COUNT_TRANSACTIONS_REMOTE_IN_APPLIER_QUEUE: 0

COUNT_TRANSACTIONS_REMOTE_APPLIED: 4

COUNT_TRANSACTIONS_LOCAL_PROPOSED: 10

COUNT_TRANSACTIONS_LOCAL_ROLLBACK: 0

*************************** 3. row ***************************

CHANNEL_NAME: group_replication_applier

VIEW_ID: 15003908034996377:3

MEMBER_ID: a2a320546bcb11e79266f0d5bf747fb1

COUNT_TRANSACTIONS_IN_QUEUE: 0

COUNT_TRANSACTIONS_CHECKED: 14

COUNT_CONFLICTS_DETECTED: 1

COUNT_TRANSACTIONS_ROWS_VALIDATING: 0

TRANSACTIONS_COMMITTED_ALL_MEMBERS: a2f9372b6bcb11e7928ef0d5bf747fb1:16:10000031000012

LAST_CONFLICT_FREE_TRANSACTION: a2f9372b6bcb11e7928ef0d5bf747fb1:1000012

COUNT_TRANSACTIONS_REMOTE_IN_APPLIER_QUEUE: 0

COUNT_TRANSACTIONS_REMOTE_APPLIED: 15

COUNT_TRANSACTIONS_LOCAL_PROPOSED: 0

COUNT_TRANSACTIONS_LOCAL_ROLLBACK: 0

3 rows in set (0.00 sec)

Comments are closed.