1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
|
show create table performance_schema.replication_group_member_stats;
Table Create Table
replication_group_member_stats CREATE TABLE `replication_group_member_stats` (
`CHANNEL_NAME` char(64) NOT NULL,
`VIEW_ID` char(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
`MEMBER_ID` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
`COUNT_TRANSACTIONS_IN_QUEUE` bigint unsigned NOT NULL,
`COUNT_TRANSACTIONS_CHECKED` bigint unsigned NOT NULL,
`COUNT_CONFLICTS_DETECTED` bigint unsigned NOT NULL,
`COUNT_TRANSACTIONS_ROWS_VALIDATING` bigint unsigned NOT NULL,
`TRANSACTIONS_COMMITTED_ALL_MEMBERS` longtext NOT NULL,
`LAST_CONFLICT_FREE_TRANSACTION` text NOT NULL,
`COUNT_TRANSACTIONS_REMOTE_IN_APPLIER_QUEUE` bigint unsigned NOT NULL,
`COUNT_TRANSACTIONS_REMOTE_APPLIED` bigint unsigned NOT NULL,
`COUNT_TRANSACTIONS_LOCAL_PROPOSED` bigint unsigned NOT NULL,
`COUNT_TRANSACTIONS_LOCAL_ROLLBACK` bigint unsigned NOT NULL
) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
select * from INFORMATION_SCHEMA.STATISTICS
where TABLE_SCHEMA = "performance_schema"
and TABLE_NAME = "replication_group_member_stats";
TABLE_CATALOG TABLE_SCHEMA TABLE_NAME NON_UNIQUE INDEX_SCHEMA INDEX_NAME SEQ_IN_INDEX COLUMN_NAME COLLATION CARDINALITY SUB_PART PACKED NULLABLE INDEX_TYPE COMMENT INDEX_COMMENT IS_VISIBLE EXPRESSION
|
