Debian Codegraph @

mysql-test/suite/sys_vars/r/innodb_cmp_per_index_enabled_basic.result

raw
1 SELECT @@global.innodb_cmp_per_index_enabled;
2 @@global.innodb_cmp_per_index_enabled
3 0
4 SET GLOBAL innodb_stats_persistent=123;
5 ERROR 42000: Variable 'innodb_stats_persistent' can't be set to the value of '123'
6 SET GLOBAL innodb_stats_persistent='foo';
7 ERROR 42000: Variable 'innodb_stats_persistent' can't be set to the value of 'foo'
8 SET GLOBAL innodb_cmp_per_index_enabled=ON;
9 SELECT @@global.innodb_cmp_per_index_enabled;
10 @@global.innodb_cmp_per_index_enabled
11 1
12 SET GLOBAL innodb_cmp_per_index_enabled=ON;
13 SELECT @@global.innodb_cmp_per_index_enabled;
14 @@global.innodb_cmp_per_index_enabled
15 1
16 SET GLOBAL innodb_cmp_per_index_enabled=OFF;
17 SELECT @@global.innodb_cmp_per_index_enabled;
18 @@global.innodb_cmp_per_index_enabled
19 0
20 SET GLOBAL innodb_cmp_per_index_enabled=OFF;
21 SELECT @@global.innodb_cmp_per_index_enabled;
22 @@global.innodb_cmp_per_index_enabled
23 0
24 SET GLOBAL innodb_cmp_per_index_enabled=ON;
25 CREATE TABLE t (a INT) ENGINE=INNODB KEY_BLOCK_SIZE=8;
26 INSERT INTO t VALUES (1);
27 SELECT * FROM information_schema.innodb_cmp_per_index;
28 database_name test
29 table_name t
30 index_name GEN_CLUST_INDEX
31 compress_ops 1
32 compress_ops_ok 1
33 compress_time 0
34 uncompress_ops 0
35 uncompress_time 0
36 SET GLOBAL innodb_cmp_per_index_enabled=OFF;
37 SET GLOBAL innodb_cmp_per_index_enabled=ON;
38 SELECT * FROM information_schema.innodb_cmp_per_index;
39 DROP TABLE t;
40 SET GLOBAL innodb_cmp_per_index_enabled=ON;
41 CREATE TABLE t (a INT) ENGINE=INNODB KEY_BLOCK_SIZE=8;
42 INSERT INTO t VALUES (1);
43 SELECT * FROM information_schema.innodb_cmp_per_index;
44 database_name test
45 table_name t
46 index_name GEN_CLUST_INDEX
47 compress_ops 1
48 compress_ops_ok 1
49 compress_time 0
50 uncompress_ops 0
51 uncompress_time 0
52 SET GLOBAL innodb_cmp_per_index_enabled=ON;
53 SELECT * FROM information_schema.innodb_cmp_per_index;
54 database_name test
55 table_name t
56 index_name GEN_CLUST_INDEX
57 compress_ops 1
58 compress_ops_ok 1
59 compress_time 0
60 uncompress_ops 0
61 uncompress_time 0
62 DROP TABLE t;
63 SET GLOBAL innodb_cmp_per_index_enabled=default;