diff options
Diffstat (limited to 'mysql-test/suite/innodb_zip/r/cmp_per_index.result')
-rw-r--r-- | mysql-test/suite/innodb_zip/r/cmp_per_index.result | 94 |
1 files changed, 94 insertions, 0 deletions
diff --git a/mysql-test/suite/innodb_zip/r/cmp_per_index.result b/mysql-test/suite/innodb_zip/r/cmp_per_index.result new file mode 100644 index 00000000000..5b899e9ff71 --- /dev/null +++ b/mysql-test/suite/innodb_zip/r/cmp_per_index.result @@ -0,0 +1,94 @@ +SET GLOBAL innodb_cmp_per_index_enabled=ON; +SELECT * FROM information_schema.innodb_cmp_per_index; +CREATE TABLE t ( +a INT, +b VARCHAR(512), +c VARCHAR(16), +PRIMARY KEY (a), +INDEX (b(512)), +INDEX (c(16)) +) ENGINE=INNODB KEY_BLOCK_SIZE=2; +SELECT +database_name, +table_name, +index_name, +compress_ops, +compress_ops_ok, +uncompress_ops +FROM information_schema.innodb_cmp_per_index +ORDER BY 1, 2, 3; +database_name test +table_name t +index_name b +compress_ops 1 +compress_ops_ok 1 +uncompress_ops 0 +database_name test +table_name t +index_name c +compress_ops 1 +compress_ops_ok 1 +uncompress_ops 0 +database_name test +table_name t +index_name PRIMARY +compress_ops 1 +compress_ops_ok 1 +uncompress_ops 0 +BEGIN; +COMMIT; +ALTER TABLE t DROP INDEX c; +GRANT USAGE ON *.* TO 'tuser01'@'localhost' IDENTIFIED BY 'cDJvI9s_Uq'; +Warnings: +Level Warning +Code 1287 +Message Using GRANT for creating new user is deprecated and will be removed in future release. Create new user with CREATE USER statement. +FLUSH PRIVILEGES; +SELECT * FROM information_schema.innodb_cmp_per_index; +ERROR 42000: Access denied; you need (at least one of) the PROCESS privilege(s) for this operation +DROP USER 'tuser01'@'localhost'; +SELECT +database_name, +table_name, +index_name, +CASE WHEN compress_ops=47 and @@innodb_compression_level IN (4,8,9) THEN 65 +ELSE compress_ops END as compress_ops, +CASE WHEN compress_ops_ok=47 and @@innodb_compression_level IN (4,8,9) THEN 65 +ELSE compress_ops_ok END as compress_ops_ok, +uncompress_ops +FROM information_schema.innodb_cmp_per_index +ORDER BY 1, 2, 3; +database_name test +table_name t +index_name b +compress_ops 43 +compress_ops_ok 43 +uncompress_ops 0 +database_name test +table_name t +index_name PRIMARY +compress_ops 65 +compress_ops_ok 65 +uncompress_ops 0 +# restart +SET GLOBAL innodb_cmp_per_index_enabled=ON; +SELECT COUNT(*) FROM t; +COUNT(*) 128 +SELECT +database_name, +table_name, +index_name, +compress_ops, +compress_ops_ok, +CASE WHEN uncompress_ops=6 and @@innodb_compression_level IN (4,8,9) THEN 9 +ELSE uncompress_ops END as uncompress_ops +FROM information_schema.innodb_cmp_per_index +ORDER BY 1, 2, 3; +database_name test +table_name t +index_name PRIMARY +compress_ops 0 +compress_ops_ok 0 +uncompress_ops 9 +DROP TABLE t; +SET GLOBAL innodb_cmp_per_index_enabled=default; |