text: SET GLOBAL innodb_encryption_threads=4;
  
  create table innodb_normal(c1 bigint not null, b char(200)) engine=innodb;
  create table innodb_compact(c1 bigint not null, b char(200)) engine=innodb row_format=compact;
  create table innodb_dynamic(c1 bigint not null, b char(200)) engine=innodb row_format=dynamic;
  create table innodb_compressed(c1 bigint not null, b char(200)) engine=innodb row_format=compressed;
  create table innodb_redundant(c1 bigint not null, b char(200)) engine=innodb row_format=redundant;
  
  show warnings;
  
  show create table innodb_normal;
  show create table innodb_compact;
  show create table innodb_dynamic;
  show create table innodb_compressed;
  show create table innodb_redundant;
  
  delimiter //;
  create procedure innodb_insert_proc (repeat_count int)
  begin
    declare current_num int;
    set current_num = 0;
    while current_num < repeat_count do
      insert into innodb_normal values(current_num, substring(MD5(RAND()), -64));
      set current_num = current_num + 1;
    end while;
  end//
  delimiter ;//
  commit;
  
  set autocommit=0;
  call innodb_insert_proc(2000);
  commit;
  set autocommit=1;
  
  insert into innodb_compact select * from innodb_normal;
  insert into innodb_dynamic select * from innodb_normal;
  insert into innodb_compressed select * from innodb_normal;
  insert into innodb_redundant select * from innodb_normal;
  
  update innodb_normal set c1 = c1 + 1;
  update innodb_compact set c1 = c1 + 1;
  update innodb_dynamic set c1 = c1 + 1;
  update innodb_compressed set c1 = c1 + 1;
  update innodb_redundant set c1 = c1 + 1;
  select count(*) from innodb_normal;
  select count(*) from innodb_compact where c1 < 1500000;
  select count(*) from innodb_dynamic where c1 < 1500000;
  select count(*) from innodb_compressed where c1 < 1500000;
  select count(*) from innodb_redundant where c1 < 1500000;
  select count(*) from innodb_compact t1, innodb_normal t2 where
  t1.c1 = t2.c1 and t1.b = t2.b;
  select count(*) from innodb_dynamic t1, innodb_normal t2 where
  t1.c1 = t2.c1 and t1.b = t2.b;
  select count(*) from innodb_compressed t1, innodb_normal t2 where
  t1.c1 = t2.c1 and t1.b = t2.b;
  select count(*) from innodb_redundant t1, innodb_normal t2 where
  t1.c1 = t2.c1 and t1.b = t2.b;
  
  --let $assert_text= Some pages should have been encrypted by now
  --let $assert_cond= "[SELECT COUNT FROM INFORMATION_SCHEMA.INNODB_METRICS WHERE NAME = \\'pages_encrypted\\']" > 0
  --source include/assert.inc
  
  --let restart_parameters=restart:--innodb-encryption-threads=4
  --source include/restart_mysqld.inc
  
  update innodb_normal set c1 = c1 + 1;
  update innodb_compact set c1 = c1 + 1;
  update innodb_dynamic set c1 = c1 + 1;
  update innodb_compressed set c1 = c1 + 1;
  update innodb_redundant set c1 = c1 + 1;
  select count(*) from innodb_normal;
  select count(*) from innodb_compact where c1 < 1500000;
  select count(*) from innodb_dynamic where c1 < 1500000;
  select count(*) from innodb_compressed where c1 < 1500000;
  select count(*) from innodb_redundant where c1 < 1500000;
  select count(*) from innodb_compact t1, innodb_normal t2 where
  t1.c1 = t2.c1 and t1.b = t2.b;
  select count(*) from innodb_dynamic t1, innodb_normal t2 where
  t1.c1 = t2.c1 and t1.b = t2.b;
  select count(*) from innodb_compressed t1, innodb_normal t2 where
  t1.c1 = t2.c1 and t1.b = t2.b;
  select count(*) from innodb_redundant t1, innodb_normal t2 where
  t1.c1 = t2.c1 and t1.b = t2.b;
  
  --let $assert_text= There should be some pages decrypted
  --let $assert_cond= "[SELECT COUNT FROM INFORMATION_SCHEMA.INNODB_METRICS WHERE NAME = \\'pages_decrypted\\']" > 0
  --source include/assert.inc
  
  drop procedure innodb_insert_proc;
  drop table innodb_normal;
  drop table innodb_compact;
  drop table innodb_dynamic;
  drop table innodb_compressed;
  drop table innodb_redundant;
  
  # Decrypt all tables
  SET GLOBAL innodb_encryption_threads=0;
  SET GLOBAL default_table_encryption = ONLINE_FROM_KEYRING_TO_UNENCRYPTED;
  SET GLOBAL innodb_encryption_threads=4;
  --let $wait_timeout= 600
  --let $wait_condition=SELECT COUNT(*) = 0 FROM INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION WHERE MIN_KEY_VERSION <> 0
  --source include/wait_condition.inc
  
  SET GLOBAL innodb_encryption_threads=0;
  SET GLOBAL default_table_encryption = ONLINE_TO_KEYRING;
  