Debian Codegraph @

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

raw
1 CREATE TABLE autorecalc (a INT, PRIMARY KEY (a)) ENGINE=INNODB;
2 SELECT n_rows, clustered_index_size FROM mysql.innodb_table_stats WHERE table_name = 'autorecalc';
3 n_rows 0
4 clustered_index_size 1
5 SELECT index_name, stat_name, stat_value FROM mysql.innodb_index_stats WHERE table_name = 'autorecalc';
6 index_name PRIMARY
7 stat_name n_diff_pfx01
8 stat_value 0
9 index_name PRIMARY
10 stat_name n_leaf_pages
11 stat_value 1
12 index_name PRIMARY
13 stat_name size
14 stat_value 1
15 INSERT INTO autorecalc VALUES (1);
16 INSERT INTO autorecalc VALUES (2);
17 SELECT n_rows, clustered_index_size FROM mysql.innodb_table_stats WHERE table_name = 'autorecalc';
18 n_rows 2
19 clustered_index_size 1
20 SELECT index_name, stat_name, stat_value FROM mysql.innodb_index_stats WHERE table_name = 'autorecalc';
21 index_name PRIMARY
22 stat_name n_diff_pfx01
23 stat_value 2
24 index_name PRIMARY
25 stat_name n_leaf_pages
26 stat_value 1
27 index_name PRIMARY
28 stat_name size
29 stat_value 1
30 DELETE FROM autorecalc;
31 SELECT n_rows, clustered_index_size FROM mysql.innodb_table_stats WHERE table_name = 'autorecalc';
32 n_rows 0
33 clustered_index_size 1
34 SELECT index_name, stat_name, stat_value FROM mysql.innodb_index_stats WHERE table_name = 'autorecalc';
35 index_name PRIMARY
36 stat_name n_diff_pfx01
37 stat_value 0
38 index_name PRIMARY
39 stat_name n_leaf_pages
40 stat_value 1
41 index_name PRIMARY
42 stat_name size
43 stat_value 1
44 DROP TABLE autorecalc;