Debian Codegraph @

mysql-test/suite/innodb/r/innodb_stats_auto_recalc_ddl.result

raw
1 CREATE TABLE arddl (a INT, b INT, PRIMARY KEY (a)) ENGINE=INNODB;
2 INSERT INTO arddl VALUES (1, 10);
3 INSERT INTO arddl VALUES (2, 10);
4 ALTER TABLE arddl ADD INDEX (b);
5 SELECT n_rows FROM mysql.innodb_table_stats WHERE table_name = 'arddl' ORDER BY 1;
6 n_rows 2
7 SELECT index_name, stat_name, stat_value FROM mysql.innodb_index_stats WHERE table_name = 'arddl' AND index_name = 'PRIMARY' ORDER BY 1, 2, 3;
8 index_name PRIMARY
9 stat_name n_diff_pfx01
10 stat_value 2
11 index_name PRIMARY
12 stat_name n_leaf_pages
13 stat_value 1
14 index_name PRIMARY
15 stat_name size
16 stat_value 1
17 DROP TABLE arddl;
18 CREATE TABLE arddl (a INT, b INT, PRIMARY KEY (a), KEY (b)) ENGINE=INNODB;
19 INSERT INTO arddl VALUES (3, 10);
20 INSERT INTO arddl VALUES (4, 10);
21 ALTER TABLE arddl DROP INDEX b;
22 SELECT n_rows FROM mysql.innodb_table_stats WHERE table_name = 'arddl' ORDER BY 1;
23 n_rows 2
24 SELECT index_name, stat_name, stat_value FROM mysql.innodb_index_stats WHERE table_name = 'arddl' AND index_name = 'PRIMARY' ORDER BY 1, 2, 3;
25 index_name PRIMARY
26 stat_name n_diff_pfx01
27 stat_value 2
28 index_name PRIMARY
29 stat_name n_leaf_pages
30 stat_value 1
31 index_name PRIMARY
32 stat_name size
33 stat_value 1
34 DROP TABLE arddl;