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