| 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' |