Debian Codegraph @

mysql-test/suite/ndb/r/ndb_pfs_tables.result

raw
1 SHOW TABLES IN performance_schema LIKE 'ndb%';
2 Tables_in_performance_schema (ndb%)
3 ndb_sync_excluded_objects
4 ndb_sync_pending_objects
5 SHOW CREATE TABLE performance_schema.ndb_sync_pending_objects;
6 Table Create Table
7 ndb_sync_pending_objects CREATE TABLE `ndb_sync_pending_objects` (
8 `SCHEMA_NAME` varchar(64) DEFAULT NULL,
9 `NAME` varchar(64) DEFAULT NULL,
10 `TYPE` enum('LOGFILE GROUP','TABLESPACE','SCHEMA','TABLE') NOT NULL
11 ) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
12 SHOW CREATE TABLE performance_schema.ndb_sync_excluded_objects;
13 Table Create Table
14 ndb_sync_excluded_objects CREATE TABLE `ndb_sync_excluded_objects` (
15 `SCHEMA_NAME` varchar(64) DEFAULT NULL,
16 `NAME` varchar(64) DEFAULT NULL,
17 `TYPE` enum('LOGFILE GROUP','TABLESPACE','SCHEMA','TABLE') NOT NULL,
18 `REASON` varchar(256) NOT NULL
19 ) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
20 SELECT * FROM performance_schema.ndb_sync_pending_objects;
21 SCHEMA_NAME NAME TYPE
22 SELECT * FROM performance_schema.ndb_sync_excluded_objects;
23 SCHEMA_NAME NAME TYPE REASON
24 INSERT INTO performance_schema.ndb_sync_pending_objects VALUES('test','t1','TABLE');
25 ERROR 42000: INSERT command denied to user 'root'@'localhost' for table 'ndb_sync_pending_objects'
26 INSERT INTO performance_schema.ndb_sync_excluded_objects VALUES('test','t1','TABLE','Excluded');
27 ERROR 42000: INSERT command denied to user 'root'@'localhost' for table 'ndb_sync_excluded_objects'