Debian Codegraph @

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

raw
1 SET @start_global_value = @@global.innodb_encryption_threads;
2 SHOW VARIABLES LIKE 'innodb_encrypt%';
3 Variable_name Value
4 innodb_encrypt_log ON
5 innodb_encrypt_tables ON
6 innodb_encrypt_temporary_tables OFF
7 innodb_encryption_rotate_key_age 15
8 innodb_encryption_rotation_iops 100
9 innodb_encryption_threads 4
10 SET GLOBAL innodb_encrypt_tables = ON;
11 # Wait max 10 min for key encryption threads to encrypt all spaces
12 SELECT NAME FROM INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION WHERE MIN_KEY_VERSION = 0
13 AND NAME NOT LIKE 'innodb_undo%' AND NAME NOT LIKE 'mysql/innodb_%_stats' AND NAME NOT LIKE 'mysql/transaction_registry';
14 NAME
15 SELECT NAME FROM INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION WHERE MIN_KEY_VERSION <> 0
16 AND NAME NOT LIKE 'innodb_undo%' AND NAME NOT LIKE 'mysql/innodb_%_stats' AND NAME NOT LIKE 'mysql/transaction_registry';
17 NAME
18 innodb_system
19 # Success!
20 # Now turn off encryption and wait for threads to decrypt everything
21 SET GLOBAL innodb_encrypt_tables = off;
22 # Wait max 10 min for key encryption threads to decrypt all spaces
23 SELECT NAME FROM INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION WHERE MIN_KEY_VERSION = 0
24 AND NAME NOT LIKE 'innodb_undo%' AND NAME NOT LIKE 'mysql/innodb_%_stats' AND NAME NOT LIKE 'mysql/transaction_registry';
25 NAME
26 innodb_system
27 SELECT NAME FROM INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION WHERE MIN_KEY_VERSION <> 0
28 AND NAME NOT LIKE 'innodb_undo%' AND NAME NOT LIKE 'mysql/innodb_%_stats' AND NAME NOT LIKE 'mysql/transaction_registry';
29 NAME
30 # Success!
31 # Shutdown innodb_encryption_threads
32 SET GLOBAL innodb_encryption_threads=0;
33 # Turn on encryption
34 # since threads are off tables should remain unencrypted
35 SET GLOBAL innodb_encrypt_tables = on;
36 # Wait 15s to check that nothing gets encrypted
37 SELECT NAME FROM INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION WHERE MIN_KEY_VERSION = 0
38 AND NAME NOT LIKE 'innodb_undo%' AND NAME NOT LIKE 'mysql/innodb_%_stats' AND NAME NOT LIKE 'mysql/transaction_registry';
39 NAME
40 innodb_system
41 SELECT NAME FROM INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION WHERE MIN_KEY_VERSION <> 0
42 AND NAME NOT LIKE 'innodb_undo%' AND NAME NOT LIKE 'mysql/innodb_%_stats' AND NAME NOT LIKE 'mysql/transaction_registry';
43 NAME
44 # Success!
45 # Startup innodb_encryption_threads
46 SET GLOBAL innodb_encryption_threads=@start_global_value;
47 # Wait max 10 min for key encryption threads to encrypt all spaces
48 SELECT NAME FROM INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION WHERE MIN_KEY_VERSION = 0
49 AND NAME NOT LIKE 'innodb_undo%' AND NAME NOT LIKE 'mysql/innodb_%_stats' AND NAME NOT LIKE 'mysql/transaction_registry';
50 NAME
51 SELECT NAME FROM INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION WHERE MIN_KEY_VERSION <> 0
52 AND NAME NOT LIKE 'innodb_undo%' AND NAME NOT LIKE 'mysql/innodb_%_stats' AND NAME NOT LIKE 'mysql/transaction_registry';
53 NAME
54 innodb_system
55 # Success!
56 # Restart mysqld --innodb_encrypt_tables=0 --innodb_encryption_threads=0
57 # restart: --innodb_encrypt_tables=0 --innodb_encryption_threads=0
58 SHOW VARIABLES LIKE 'innodb_encrypt%';
59 Variable_name Value
60 innodb_encrypt_log ON
61 innodb_encrypt_tables OFF
62 innodb_encrypt_temporary_tables OFF
63 innodb_encryption_rotate_key_age 15
64 innodb_encryption_rotation_iops 100
65 innodb_encryption_threads 0
66 SELECT NAME FROM INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION WHERE MIN_KEY_VERSION <> 0
67 AND NAME NOT LIKE 'innodb_undo%' AND NAME NOT LIKE 'mysql/innodb_%_stats' AND NAME NOT LIKE 'mysql/transaction_registry';
68 NAME
69 innodb_system
70 SELECT NAME FROM INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION WHERE MIN_KEY_VERSION = 0
71 AND NAME NOT LIKE 'innodb_undo%' AND NAME NOT LIKE 'mysql/innodb_%_stats' AND NAME NOT LIKE 'mysql/transaction_registry';
72 NAME