Debian Codegraph @

mysql-test/suite/perfschema/r/dml_replication_group_member_stats.result

raw
1 SELECT * FROM performance_schema.replication_group_member_stats
2 LIMIT 1;
3 CHANNEL_NAME VIEW_ID MEMBER_ID COUNT_TRANSACTIONS_IN_QUEUE COUNT_TRANSACTIONS_CHECKED COUNT_CONFLICTS_DETECTED COUNT_TRANSACTIONS_ROWS_VALIDATING TRANSACTIONS_COMMITTED_ALL_MEMBERS LAST_CONFLICT_FREE_TRANSACTION COUNT_TRANSACTIONS_REMOTE_IN_APPLIER_QUEUE COUNT_TRANSACTIONS_REMOTE_APPLIED COUNT_TRANSACTIONS_LOCAL_PROPOSED COUNT_TRANSACTIONS_LOCAL_ROLLBACK
4 SELECT * FROM performance_schema.replication_group_member_stats
5 WHERE channel_name='FOO';
6 CHANNEL_NAME VIEW_ID MEMBER_ID COUNT_TRANSACTIONS_IN_QUEUE COUNT_TRANSACTIONS_CHECKED COUNT_CONFLICTS_DETECTED COUNT_TRANSACTIONS_ROWS_VALIDATING TRANSACTIONS_COMMITTED_ALL_MEMBERS LAST_CONFLICT_FREE_TRANSACTION COUNT_TRANSACTIONS_REMOTE_IN_APPLIER_QUEUE COUNT_TRANSACTIONS_REMOTE_APPLIED COUNT_TRANSACTIONS_LOCAL_PROPOSED COUNT_TRANSACTIONS_LOCAL_ROLLBACK
7 INSERT INTO performance_schema.replication_group_member_stats
8 SET channel_name='FOO', node_id=1;
9 ERROR 42000: INSERT command denied to user 'root'@'localhost' for table 'replication_group_member_stats'
10 UPDATE performance_schema.replication_group_member_stats
11 SET member_id=12;
12 ERROR 42000: UPDATE command denied to user 'root'@'localhost' for table 'replication_group_member_stats'
13 UPDATE performance_schema.replication_group_member_stats
14 SET member_id=12 WHERE group_name LIKE "FOO";
15 ERROR 42000: UPDATE command denied to user 'root'@'localhost' for table 'replication_group_member_stats'
16 DELETE FROM performance_schema.replication_group_member_stats
17 WHERE member_id=1;
18 ERROR 42000: DELETE command denied to user 'root'@'localhost' for table 'replication_group_member_stats'
19 DELETE FROM performance_schema.replication_group_member_stats;
20 ERROR 42000: DELETE command denied to user 'root'@'localhost' for table 'replication_group_member_stats'
21 LOCK TABLES performance_schema.replication_group_member_stats READ;
22 ERROR 42000: SELECT, LOCK TABLES command denied to user 'root'@'localhost' for table 'replication_group_member_stats'
23 UNLOCK TABLES;
24 LOCK TABLES performance_schema.replication_group_member_stats WRITE;
25 ERROR 42000: SELECT, LOCK TABLES command denied to user 'root'@'localhost' for table 'replication_group_member_stats'
26 UNLOCK TABLES;