| 1 |
Verify that the index stat tables are not present in the Server |
| 2 |
SHOW TABLES IN mysql LIKE 'ndb_index_stat%'; |
| 3 |
Tables_in_mysql (ndb_index_stat%) |
| 4 |
Verify that the tables can't be discovered |
| 5 |
SHOW CREATE TABLE mysql.ndb_index_stat_head; |
| 6 |
ERROR 42S02: Table 'mysql.ndb_index_stat_head' doesn't exist |
| 7 |
SHOW WARNINGS; |
| 8 |
Level Code Message |
| 9 |
Error 1146 Table 'mysql.ndb_index_stat_head' doesn't exist |
| 10 |
Verify that the tables aren't readabale |
| 11 |
SELECT * FROM mysql.ndb_index_stat_sample; |
| 12 |
ERROR 42S02: Table 'mysql.ndb_index_stat_sample' doesn't exist |
| 13 |
SHOW WARNINGS; |
| 14 |
Level Code Message |
| 15 |
Error 1146 Table 'mysql.ndb_index_stat_sample' doesn't exist |
| 16 |
SHOW CREATE VIEW ndbinfo.index_stats; |
| 17 |
View Create View character_set_client collation_connection |
| 18 |
index_stats CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY INVOKER VIEW `ndbinfo`.`index_stats` AS select `ndbinfo`.`ndb$index_stats`.`index_id` AS `index_id`,`ndbinfo`.`ndb$index_stats`.`index_version` AS `index_version`,`ndbinfo`.`ndb$index_stats`.`sample_version` AS `sample_version`,`ndbinfo`.`ndb$index_stats`.`load_time` AS `load_time`,`ndbinfo`.`ndb$index_stats`.`sample_count` AS `sample_count` from `ndbinfo`.`ndb$index_stats` utf8mb4 utf8mb4_0900_ai_ci |