Debian Codegraph @

mysql-test/suite/innodb_zip/r/cmp_per_index.result

raw
1 ALTER DATABASE test CHARACTER SET latin1 COLLATE latin1_swedish_ci;
2 SET @save_enabled= @@GLOBAL.innodb_cmp_per_index_enabled;
3 SET GLOBAL innodb_cmp_per_index_enabled=ON;
4 SELECT * FROM information_schema.innodb_cmp_per_index;
5 CREATE TABLE t (
6 a INT,
7 b VARCHAR(512),
8 c VARCHAR(16),
9 PRIMARY KEY (a),
10 INDEX (b(512)),
11 INDEX (c(16))
12 ) ENGINE=INNODB KEY_BLOCK_SIZE=2;
13 SELECT
14 database_name,
15 table_name,
16 index_name,
17 compress_ops,
18 compress_ops_ok,
19 uncompress_ops
20 FROM information_schema.innodb_cmp_per_index
21 ORDER BY 1, 2, 3;
22 database_name test
23 table_name t
24 index_name b
25 compress_ops 1
26 compress_ops_ok 1
27 uncompress_ops 0
28 database_name test
29 table_name t
30 index_name c
31 compress_ops 1
32 compress_ops_ok 1
33 uncompress_ops 0
34 database_name test
35 table_name t
36 index_name PRIMARY
37 compress_ops 1
38 compress_ops_ok 1
39 uncompress_ops 0
40 BEGIN;
41 COMMIT;
42 ALTER TABLE t DROP INDEX c;
43 GRANT USAGE ON *.* TO 'tuser01'@'localhost' IDENTIFIED BY 'cDJvI9s_Uq';
44 FLUSH PRIVILEGES;
45 connect con1,localhost,tuser01,cDJvI9s_Uq,;
46 connection con1;
47 SELECT * FROM information_schema.innodb_cmp_per_index;
48 ERROR 42000: Access denied; you need (at least one of) the PROCESS privilege(s) for this operation
49 connection default;
50 disconnect con1;
51 DROP USER 'tuser01'@'localhost';
52 SELECT
53 database_name,
54 table_name,
55 index_name,
56 compress_ops,
57 compress_ops_ok,
58 uncompress_ops
59 FROM information_schema.innodb_cmp_per_index
60 ORDER BY 1, 2, 3;
61 database_name test
62 table_name t
63 index_name b
64 compress_ops 52
65 compress_ops_ok 52
66 uncompress_ops 0
67 database_name test
68 table_name t
69 index_name PRIMARY
70 compress_ops 64
71 compress_ops_ok 64
72 uncompress_ops 0
73 DROP TABLE t;
74 SET GLOBAL innodb_cmp_per_index_enabled=@save_enabled;
75 ALTER DATABASE test CHARACTER SET utf8mb4 COLLATE utf8mb4_uca1400_ai_ci;