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