Debian Codegraph @

mysql-test/suite/ndb_opt/index_stat_tables.result

raw
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