Debian Codegraph @

mysql-test/suite/encryption/r/innodb_encryption_tables.result

raw
1 create table innodb_normal(c1 bigint not null, b char(200)) engine=innodb;
2 create table innodb_compact(c1 bigint not null, b char(200)) engine=innodb row_format=compact;
3 create table innodb_dynamic(c1 bigint not null, b char(200)) engine=innodb row_format=dynamic;
4 create table innodb_compressed(c1 bigint not null, b char(200)) engine=innodb row_format=compressed;
5 create table innodb_redundant(c1 bigint not null, b char(200)) engine=innodb row_format=redundant;
6 show warnings;
7 Level Code Message
8 show create table innodb_normal;
9 Table Create Table
10 innodb_normal CREATE TABLE `innodb_normal` (
11 `c1` bigint(20) NOT NULL,
12 `b` char(200) DEFAULT NULL
13 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
14 show create table innodb_compact;
15 Table Create Table
16 innodb_compact CREATE TABLE `innodb_compact` (
17 `c1` bigint(20) NOT NULL,
18 `b` char(200) DEFAULT NULL
19 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci ROW_FORMAT=COMPACT
20 show create table innodb_dynamic;
21 Table Create Table
22 innodb_dynamic CREATE TABLE `innodb_dynamic` (
23 `c1` bigint(20) NOT NULL,
24 `b` char(200) DEFAULT NULL
25 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci ROW_FORMAT=DYNAMIC
26 show create table innodb_compressed;
27 Table Create Table
28 innodb_compressed CREATE TABLE `innodb_compressed` (
29 `c1` bigint(20) NOT NULL,
30 `b` char(200) DEFAULT NULL
31 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci ROW_FORMAT=COMPRESSED
32 show create table innodb_redundant;
33 Table Create Table
34 innodb_redundant CREATE TABLE `innodb_redundant` (
35 `c1` bigint(20) NOT NULL,
36 `b` char(200) DEFAULT NULL
37 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci ROW_FORMAT=REDUNDANT
38 create procedure innodb_insert_proc (repeat_count int)
39 begin
40 declare current_num int;
41 set current_num = 0;
42 while current_num < repeat_count do
43 insert into innodb_normal values(current_num, substring(MD5(RAND()), -64));
44 set current_num = current_num + 1;
45 end while;
46 end//
47 commit;
48 set autocommit=0;
49 call innodb_insert_proc(2000);
50 commit;
51 set autocommit=1;
52 insert into innodb_compact select * from innodb_normal;
53 insert into innodb_dynamic select * from innodb_normal;
54 insert into innodb_compressed select * from innodb_normal;
55 insert into innodb_redundant select * from innodb_normal;
56 update innodb_normal set c1 = c1 + 1;
57 update innodb_compact set c1 = c1 + 1;
58 update innodb_dynamic set c1 = c1 + 1;
59 update innodb_compressed set c1 = c1 + 1;
60 update innodb_redundant set c1 = c1 + 1;
61 select count(*) from innodb_normal;
62 count(*)
63 2000
64 select count(*) from innodb_compact where c1 < 1500000;
65 count(*)
66 2000
67 select count(*) from innodb_dynamic where c1 < 1500000;
68 count(*)
69 2000
70 select count(*) from innodb_compressed where c1 < 1500000;
71 count(*)
72 2000
73 select count(*) from innodb_redundant where c1 < 1500000;
74 count(*)
75 2000
76 select count(*) from innodb_compact t1, innodb_normal t2 where
77 t1.c1 = t2.c1 and t1.b = t2.b;
78 count(*)
79 2000
80 select count(*) from innodb_dynamic t1, innodb_normal t2 where
81 t1.c1 = t2.c1 and t1.b = t2.b;
82 count(*)
83 2000
84 select count(*) from innodb_compressed t1, innodb_normal t2 where
85 t1.c1 = t2.c1 and t1.b = t2.b;
86 count(*)
87 2000
88 select count(*) from innodb_redundant t1, innodb_normal t2 where
89 t1.c1 = t2.c1 and t1.b = t2.b;
90 count(*)
91 2000
92 SELECT variable_value >= 0 FROM information_schema.global_status WHERE variable_name = 'innodb_num_pages_encrypted';
93 variable_value >= 0
94 1
95 SELECT variable_value >= 0 FROM information_schema.global_status WHERE variable_name = 'innodb_num_pages_decrypted';
96 variable_value >= 0
97 1
98 SELECT variable_value >= 0 FROM information_schema.global_status WHERE variable_name = 'innodb_num_pages_page_compressed';
99 variable_value >= 0
100 1
101 SELECT variable_value >= 0 FROM information_schema.global_status WHERE variable_name = 'innodb_num_pages_page_decompressed';
102 variable_value >= 0
103 1
104 # restart
105 update innodb_normal set c1 = c1 + 1;
106 update innodb_compact set c1 = c1 + 1;
107 update innodb_dynamic set c1 = c1 + 1;
108 update innodb_compressed set c1 = c1 + 1;
109 update innodb_redundant set c1 = c1 + 1;
110 select count(*) from innodb_normal;
111 count(*)
112 2000
113 select count(*) from innodb_compact where c1 < 1500000;
114 count(*)
115 2000
116 select count(*) from innodb_dynamic where c1 < 1500000;
117 count(*)
118 2000
119 select count(*) from innodb_compressed where c1 < 1500000;
120 count(*)
121 2000
122 select count(*) from innodb_redundant where c1 < 1500000;
123 count(*)
124 2000
125 select count(*) from innodb_compact t1, innodb_normal t2 where
126 t1.c1 = t2.c1 and t1.b = t2.b;
127 count(*)
128 2000
129 select count(*) from innodb_dynamic t1, innodb_normal t2 where
130 t1.c1 = t2.c1 and t1.b = t2.b;
131 count(*)
132 2000
133 select count(*) from innodb_compressed t1, innodb_normal t2 where
134 t1.c1 = t2.c1 and t1.b = t2.b;
135 count(*)
136 2000
137 select count(*) from innodb_redundant t1, innodb_normal t2 where
138 t1.c1 = t2.c1 and t1.b = t2.b;
139 count(*)
140 2000
141 SELECT variable_value >= 0 FROM information_schema.global_status WHERE variable_name = 'innodb_num_pages_encrypted';
142 variable_value >= 0
143 1
144 SELECT variable_value >= 0 FROM information_schema.global_status WHERE variable_name = 'innodb_num_pages_decrypted';
145 variable_value >= 0
146 1
147 SELECT variable_value >= 0 FROM information_schema.global_status WHERE variable_name = 'innodb_num_pages_page_compressed';
148 variable_value >= 0
149 1
150 SELECT variable_value >= 0 FROM information_schema.global_status WHERE variable_name = 'innodb_num_pages_page_decompressed';
151 variable_value >= 0
152 1
153 drop procedure innodb_insert_proc;
154 drop table innodb_normal;
155 drop table innodb_compact;
156 drop table innodb_dynamic;
157 drop table innodb_compressed;
158 drop table innodb_redundant;