Debian Codegraph @

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

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