Debian Codegraph @

mysql-test/suite/sys_vars/t/innodb_cmp_per_index_enabled_basic.test

raw
1 # CREATE TABLE ... KEY_BLOCK_SIZE=8; does not work with page size = 4k
2
3 # Check the default value
4 SELECT @@global.innodb_cmp_per_index_enabled;
5
6 # should be a boolean
7 -- error ER_WRONG_VALUE_FOR_VAR
8 SET GLOBAL innodb_stats_persistent=123;
9
10 -- error ER_WRONG_VALUE_FOR_VAR
11 SET GLOBAL innodb_stats_persistent='foo';
12
13 # Check that changing value works and that setting the same value again
14 # is as expected
15 SET GLOBAL innodb_cmp_per_index_enabled=ON;
16 SELECT @@global.innodb_cmp_per_index_enabled;
17
18 SET GLOBAL innodb_cmp_per_index_enabled=ON;
19 SELECT @@global.innodb_cmp_per_index_enabled;
20
21 SET GLOBAL innodb_cmp_per_index_enabled=OFF;
22 SELECT @@global.innodb_cmp_per_index_enabled;
23
24 SET GLOBAL innodb_cmp_per_index_enabled=OFF;
25 SELECT @@global.innodb_cmp_per_index_enabled;
26
27 -- vertical_results
28
29 # Check that enabling after being disabled resets the stats
30
31 SET GLOBAL innodb_cmp_per_index_enabled=ON;
32
33 CREATE TABLE t (a INT) ENGINE=INNODB KEY_BLOCK_SIZE=8;
34
35 INSERT INTO t VALUES (1);
36
37 SELECT * FROM information_schema.innodb_cmp_per_index;
38
39 SET GLOBAL innodb_cmp_per_index_enabled=OFF;
40 SET GLOBAL innodb_cmp_per_index_enabled=ON;
41
42 SELECT * FROM information_schema.innodb_cmp_per_index;
43
44 DROP TABLE t;
45
46 # Check that enabling after being enabled does not reset the stats
47
48 SET GLOBAL innodb_cmp_per_index_enabled=ON;
49
50 CREATE TABLE t (a INT) ENGINE=INNODB KEY_BLOCK_SIZE=8;
51
52 INSERT INTO t VALUES (1);
53
54 SELECT * FROM information_schema.innodb_cmp_per_index;
55
56 SET GLOBAL innodb_cmp_per_index_enabled=ON;
57
58 SELECT * FROM information_schema.innodb_cmp_per_index;
59
60 DROP TABLE t;
61
62 #
63
64 SET GLOBAL innodb_cmp_per_index_enabled=default;