Debian Codegraph @

mysql-test/suite/encryption/t/innodb_encryption-page-compression.test

raw
1 -- source include/have_innodb.inc
2 -- source include/have_example_key_management_plugin.inc
3 -- source include/not_embedded.inc
4 # This test is too slow for valgrind and causes innnodb semaphores to time out
5 -- source include/not_valgrind.inc
6
7 let $innodb_encrypt_tables_orig = `SELECT @@innodb_encrypt_tables`;
8 let $innodb_encryption_threads_orig = `SELECT @@innodb_encryption_threads`;
9
10 SET GLOBAL innodb_encryption_threads = 4;
11
12 # zlib
13 set global innodb_compression_algorithm = 1;
14
15 create table innodb_normal (c1 int, b char(20)) engine=innodb;
16 show warnings;
17 create table innodb_page_compressed1 (c1 int, b char(20)) engine=innodb page_compressed=1 page_compression_level=1;
18 show warnings;
19 show create table innodb_page_compressed1;
20 create table innodb_page_compressed2 (c1 int, b char(20)) engine=innodb page_compressed=1 page_compression_level=2;
21 show warnings;
22 show create table innodb_page_compressed2;
23 create table innodb_page_compressed3 (c1 int, b char(20)) engine=innodb page_compressed=1 page_compression_level=3;
24 show warnings;
25 show create table innodb_page_compressed3;
26 create table innodb_page_compressed4 (c1 int, b char(20)) engine=innodb page_compressed=1 page_compression_level=4;
27 show warnings;
28 show create table innodb_page_compressed4;
29 create table innodb_page_compressed5 (c1 int, b char(20)) engine=innodb page_compressed=1 page_compression_level=5;
30 show warnings;
31 show create table innodb_page_compressed5;
32 create table innodb_page_compressed6 (c1 int, b char(20)) engine=innodb page_compressed=1 page_compression_level=6;
33 show warnings;
34 show create table innodb_page_compressed6;
35 create table innodb_page_compressed7 (c1 int, b char(20)) engine=innodb page_compressed=1 page_compression_level=7;
36 show warnings;
37 show create table innodb_page_compressed7;
38 create table innodb_page_compressed8 (c1 int, b char(20)) engine=innodb page_compressed=1 page_compression_level=8;
39 show warnings;
40 show create table innodb_page_compressed8;
41 create table innodb_page_compressed9 (c1 int, b char(20)) engine=innodb page_compressed=1 page_compression_level=9;
42 show warnings;
43 show create table innodb_page_compressed9;
44 delimiter //;
45 create procedure innodb_insert_proc (repeat_count int)
46 begin
47 declare current_num int;
48 set current_num = 0;
49 while current_num < repeat_count do
50 insert into innodb_normal values(current_num,'testing..');
51 set current_num = current_num + 1;
52 end while;
53 end//
54 delimiter ;//
55 commit;
56
57 begin;
58 call innodb_insert_proc(2000);
59 insert into innodb_page_compressed1 select * from innodb_normal;
60 insert into innodb_page_compressed2 select * from innodb_normal;
61 insert into innodb_page_compressed3 select * from innodb_normal;
62 insert into innodb_page_compressed4 select * from innodb_normal;
63 insert into innodb_page_compressed5 select * from innodb_normal;
64 insert into innodb_page_compressed6 select * from innodb_normal;
65 insert into innodb_page_compressed7 select * from innodb_normal;
66 insert into innodb_page_compressed8 select * from innodb_normal;
67 insert into innodb_page_compressed9 select * from innodb_normal;
68 commit;
69
70 select count(*) from innodb_page_compressed1 where c1 < 500000;
71 select count(*) from innodb_page_compressed2 where c1 < 500000;
72 select count(*) from innodb_page_compressed3 where c1 < 500000;
73 select count(*) from innodb_page_compressed4 where c1 < 500000;
74 select count(*) from innodb_page_compressed5 where c1 < 500000;
75 select count(*) from innodb_page_compressed6 where c1 < 500000;
76 select count(*) from innodb_page_compressed7 where c1 < 500000;
77 select count(*) from innodb_page_compressed8 where c1 < 500000;
78 select count(*) from innodb_page_compressed9 where c1 < 500000;
79
80 flush tables innodb_page_compressed1, innodb_page_compressed2,
81 innodb_page_compressed3, innodb_page_compressed4,
82 innodb_page_compressed5, innodb_page_compressed6,
83 innodb_page_compressed7, innodb_page_compressed8,
84 innodb_page_compressed9 for export;
85
86 unlock tables;
87
88 --echo # Wait until dirty pages are compressed and encrypted
89 let $wait_condition= select variable_value > 0 from information_schema.global_status where variable_name = 'INNODB_NUM_PAGES_PAGE_COMPRESSED';
90 --source include/wait_condition.inc
91 let $wait_condition= select variable_value > 0 from information_schema.global_status where variable_name = 'INNODB_NUM_PAGES_ENCRYPTED';
92 --source include/wait_condition.inc
93
94 SELECT variable_value > 0 FROM information_schema.global_status WHERE variable_name = 'innodb_num_pages_encrypted';
95 SELECT variable_value > 0 FROM information_schema.global_status WHERE variable_name = 'innodb_num_pages_page_compressed';
96
97 --source include/restart_mysqld.inc
98
99 SET GLOBAL innodb_encryption_threads = 4;
100 SET GLOBAL innodb_encrypt_tables = off;
101
102 update innodb_page_compressed1 set c1 = c1 + 1;
103 update innodb_page_compressed2 set c1 = c1 + 1;
104 update innodb_page_compressed3 set c1 = c1 + 1;
105 update innodb_page_compressed4 set c1 = c1 + 1;
106 update innodb_page_compressed5 set c1 = c1 + 1;
107 update innodb_page_compressed6 set c1 = c1 + 1;
108 update innodb_page_compressed7 set c1 = c1 + 1;
109 update innodb_page_compressed8 set c1 = c1 + 1;
110 update innodb_page_compressed9 set c1 = c1 + 1;
111
112 flush tables innodb_page_compressed1, innodb_page_compressed2,
113 innodb_page_compressed3, innodb_page_compressed4,
114 innodb_page_compressed5, innodb_page_compressed6,
115 innodb_page_compressed7, innodb_page_compressed8,
116 innodb_page_compressed9 for export;
117
118 unlock tables;
119
120 --echo # Wait until dirty pages are compressed and encrypted 2
121 let $wait_condition= select variable_value > 0 from information_schema.global_status where variable_name = 'INNODB_NUM_PAGES_PAGE_COMPRESSED';
122 --source include/wait_condition.inc
123 let $wait_condition= select variable_value > 0 from information_schema.global_status where variable_name = 'INNODB_NUM_PAGES_DECRYPTED';
124 --source include/wait_condition.inc
125
126 SELECT variable_value > 0 FROM information_schema.global_status WHERE variable_name = 'innodb_num_pages_decrypted';
127 SELECT variable_value > 0 FROM information_schema.global_status WHERE variable_name = 'innodb_num_pages_page_compressed';
128 SELECT variable_value > 0 FROM information_schema.global_status WHERE variable_name = 'innodb_num_pages_page_decompressed';
129
130 drop procedure innodb_insert_proc;
131 drop table innodb_normal;
132 drop table innodb_page_compressed1;
133 drop table innodb_page_compressed2;
134 drop table innodb_page_compressed3;
135 drop table innodb_page_compressed4;
136 drop table innodb_page_compressed5;
137 drop table innodb_page_compressed6;
138 drop table innodb_page_compressed7;
139 drop table innodb_page_compressed8;
140 drop table innodb_page_compressed9;
141
142 # reset system
143 --disable_query_log
144 EVAL SET GLOBAL innodb_encrypt_tables = $innodb_encrypt_tables_orig;
145 EVAL SET GLOBAL innodb_encryption_threads = $innodb_encryption_threads_orig;
146 --enable_query_log