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: a21badd5–6bcb–11e7–928e–f0d5bf747fb1

COUNT_TRANSACTIONS_IN_QUEUE: 0

COUNT_TRANSACTIONS_CHECKED: 14

COUNT_CONFLICTS_DETECTED: 1

COUNT_TRANSACTIONS_ROWS_VALIDATING: 0

TRANSACTIONS_COMMITTED_ALL_MEMBERS: a2f9372b–6bcb–11e7–928e–f0d5bf747fb1:1–6:1000003–1000012

LAST_CONFLICT_FREE_TRANSACTION: a2f9372b–6bcb–11e7–928e–f0d5bf747fb1: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: a256fdee–6bcb–11e7–922d–f0d5bf747fb1

COUNT_TRANSACTIONS_IN_QUEUE: 0

COUNT_TRANSACTIONS_CHECKED: 14

COUNT_CONFLICTS_DETECTED: 1

COUNT_TRANSACTIONS_ROWS_VALIDATING: 0

TRANSACTIONS_COMMITTED_ALL_MEMBERS: a2f9372b–6bcb–11e7–928e–f0d5bf747fb1:1–6:1000003–1000012

LAST_CONFLICT_FREE_TRANSACTION: a2f9372b–6bcb–11e7–928e–f0d5bf747fb1: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: a2a32054–6bcb–11e7–9266–f0d5bf747fb1

COUNT_TRANSACTIONS_IN_QUEUE: 0

COUNT_TRANSACTIONS_CHECKED: 14

COUNT_CONFLICTS_DETECTED: 1

COUNT_TRANSACTIONS_ROWS_VALIDATING: 0

TRANSACTIONS_COMMITTED_ALL_MEMBERS: a2f9372b–6bcb–11e7–928e–f0d5bf747fb1:1–6:1000003–1000012

LAST_CONFLICT_FREE_TRANSACTION: a2f9372b–6bcb–11e7–928e–f0d5bf747fb1: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.