EVOLUTION-MANAGER

Edit File: innodb_lotoftables.result

SET GLOBAL innodb_fast_shutdown=0; SHOW VARIABLES LIKE 'innodb_encrypt%'; Variable_name Value innodb_encrypt_log OFF innodb_encrypt_tables OFF innodb_encryption_rotate_key_age 1 innodb_encryption_rotation_iops 100 innodb_encryption_threads 0 create database innodb_encrypted_1; use innodb_encrypted_1; show status like 'innodb_pages0_read%'; Variable_name Value Innodb_pages0_read 4 set autocommit=0; set autocommit=1; commit work; show status like 'innodb_pages0_read%'; Variable_name Value Innodb_pages0_read 4 # should be empty SELECT NAME FROM INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION WHERE NAME LIKE 'innodb_encrypted%'; NAME create database innodb_encrypted_2; use innodb_encrypted_2; show status like 'innodb_pages0_read%'; Variable_name Value Innodb_pages0_read 4 set autocommit=0; commit work; set autocommit=1; show status like 'innodb_pages0_read%'; Variable_name Value Innodb_pages0_read 4 # should contain 100 tables SELECT NAME FROM INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION WHERE MIN_KEY_VERSION <> 0 AND NAME LIKE 'innodb_encrypted%' ORDER BY NAME; NAME innodb_encrypted_2/t_1 innodb_encrypted_2/t_10 innodb_encrypted_2/t_100 innodb_encrypted_2/t_11 innodb_encrypted_2/t_12 innodb_encrypted_2/t_13 innodb_encrypted_2/t_14 innodb_encrypted_2/t_15 innodb_encrypted_2/t_16 innodb_encrypted_2/t_17 innodb_encrypted_2/t_18 innodb_encrypted_2/t_19 innodb_encrypted_2/t_2 innodb_encrypted_2/t_20 innodb_encrypted_2/t_21 innodb_encrypted_2/t_22 innodb_encrypted_2/t_23 innodb_encrypted_2/t_24 innodb_encrypted_2/t_25 innodb_encrypted_2/t_26 innodb_encrypted_2/t_27 innodb_encrypted_2/t_28 innodb_encrypted_2/t_29 innodb_encrypted_2/t_3 innodb_encrypted_2/t_30 innodb_encrypted_2/t_31 innodb_encrypted_2/t_32 innodb_encrypted_2/t_33 innodb_encrypted_2/t_34 innodb_encrypted_2/t_35 innodb_encrypted_2/t_36 innodb_encrypted_2/t_37 innodb_encrypted_2/t_38 innodb_encrypted_2/t_39 innodb_encrypted_2/t_4 innodb_encrypted_2/t_40 innodb_encrypted_2/t_41 innodb_encrypted_2/t_42 innodb_encrypted_2/t_43 innodb_encrypted_2/t_44 innodb_encrypted_2/t_45 innodb_encrypted_2/t_46 innodb_encrypted_2/t_47 innodb_encrypted_2/t_48 innodb_encrypted_2/t_49 innodb_encrypted_2/t_5 innodb_encrypted_2/t_50 innodb_encrypted_2/t_51 innodb_encrypted_2/t_52 innodb_encrypted_2/t_53 innodb_encrypted_2/t_54 innodb_encrypted_2/t_55 innodb_encrypted_2/t_56 innodb_encrypted_2/t_57 innodb_encrypted_2/t_58 innodb_encrypted_2/t_59 innodb_encrypted_2/t_6 innodb_encrypted_2/t_60 innodb_encrypted_2/t_61 innodb_encrypted_2/t_62 innodb_encrypted_2/t_63 innodb_encrypted_2/t_64 innodb_encrypted_2/t_65 innodb_encrypted_2/t_66 innodb_encrypted_2/t_67 innodb_encrypted_2/t_68 innodb_encrypted_2/t_69 innodb_encrypted_2/t_7 innodb_encrypted_2/t_70 innodb_encrypted_2/t_71 innodb_encrypted_2/t_72 innodb_encrypted_2/t_73 innodb_encrypted_2/t_74 innodb_encrypted_2/t_75 innodb_encrypted_2/t_76 innodb_encrypted_2/t_77 innodb_encrypted_2/t_78 innodb_encrypted_2/t_79 innodb_encrypted_2/t_8 innodb_encrypted_2/t_80 innodb_encrypted_2/t_81 innodb_encrypted_2/t_82 innodb_encrypted_2/t_83 innodb_encrypted_2/t_84 innodb_encrypted_2/t_85 innodb_encrypted_2/t_86 innodb_encrypted_2/t_87 innodb_encrypted_2/t_88 innodb_encrypted_2/t_89 innodb_encrypted_2/t_9 innodb_encrypted_2/t_90 innodb_encrypted_2/t_91 innodb_encrypted_2/t_92 innodb_encrypted_2/t_93 innodb_encrypted_2/t_94 innodb_encrypted_2/t_95 innodb_encrypted_2/t_96 innodb_encrypted_2/t_97 innodb_encrypted_2/t_98 innodb_encrypted_2/t_99 # should contain 0 tables SELECT NAME FROM INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION WHERE MIN_KEY_VERSION = 0 AND NAME LIKE 'innodb_encrypted%' ORDER BY NAME; NAME create database innodb_encrypted_3; use innodb_encrypted_3; show status like 'innodb_pages0_read%'; Variable_name Value Innodb_pages0_read 4 set autocommit=0; commit work; set autocommit=1; show status like 'innodb_pages0_read%'; Variable_name Value Innodb_pages0_read 4 # should contain 100 tables SELECT NAME FROM INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION WHERE MIN_KEY_VERSION <> 0 AND NAME LIKE 'innodb_encrypted%' ORDER BY NAME; NAME innodb_encrypted_2/t_1 innodb_encrypted_2/t_10 innodb_encrypted_2/t_100 innodb_encrypted_2/t_11 innodb_encrypted_2/t_12 innodb_encrypted_2/t_13 innodb_encrypted_2/t_14 innodb_encrypted_2/t_15 innodb_encrypted_2/t_16 innodb_encrypted_2/t_17 innodb_encrypted_2/t_18 innodb_encrypted_2/t_19 innodb_encrypted_2/t_2 innodb_encrypted_2/t_20 innodb_encrypted_2/t_21 innodb_encrypted_2/t_22 innodb_encrypted_2/t_23 innodb_encrypted_2/t_24 innodb_encrypted_2/t_25 innodb_encrypted_2/t_26 innodb_encrypted_2/t_27 innodb_encrypted_2/t_28 innodb_encrypted_2/t_29 innodb_encrypted_2/t_3 innodb_encrypted_2/t_30 innodb_encrypted_2/t_31 innodb_encrypted_2/t_32 innodb_encrypted_2/t_33 innodb_encrypted_2/t_34 innodb_encrypted_2/t_35 innodb_encrypted_2/t_36 innodb_encrypted_2/t_37 innodb_encrypted_2/t_38 innodb_encrypted_2/t_39 innodb_encrypted_2/t_4 innodb_encrypted_2/t_40 innodb_encrypted_2/t_41 innodb_encrypted_2/t_42 innodb_encrypted_2/t_43 innodb_encrypted_2/t_44 innodb_encrypted_2/t_45 innodb_encrypted_2/t_46 innodb_encrypted_2/t_47 innodb_encrypted_2/t_48 innodb_encrypted_2/t_49 innodb_encrypted_2/t_5 innodb_encrypted_2/t_50 innodb_encrypted_2/t_51 innodb_encrypted_2/t_52 innodb_encrypted_2/t_53 innodb_encrypted_2/t_54 innodb_encrypted_2/t_55 innodb_encrypted_2/t_56 innodb_encrypted_2/t_57 innodb_encrypted_2/t_58 innodb_encrypted_2/t_59 innodb_encrypted_2/t_6 innodb_encrypted_2/t_60 innodb_encrypted_2/t_61 innodb_encrypted_2/t_62 innodb_encrypted_2/t_63 innodb_encrypted_2/t_64 innodb_encrypted_2/t_65 innodb_encrypted_2/t_66 innodb_encrypted_2/t_67 innodb_encrypted_2/t_68 innodb_encrypted_2/t_69 innodb_encrypted_2/t_7 innodb_encrypted_2/t_70 innodb_encrypted_2/t_71 innodb_encrypted_2/t_72 innodb_encrypted_2/t_73 innodb_encrypted_2/t_74 innodb_encrypted_2/t_75 innodb_encrypted_2/t_76 innodb_encrypted_2/t_77 innodb_encrypted_2/t_78 innodb_encrypted_2/t_79 innodb_encrypted_2/t_8 innodb_encrypted_2/t_80 innodb_encrypted_2/t_81 innodb_encrypted_2/t_82 innodb_encrypted_2/t_83 innodb_encrypted_2/t_84 innodb_encrypted_2/t_85 innodb_encrypted_2/t_86 innodb_encrypted_2/t_87 innodb_encrypted_2/t_88 innodb_encrypted_2/t_89 innodb_encrypted_2/t_9 innodb_encrypted_2/t_90 innodb_encrypted_2/t_91 innodb_encrypted_2/t_92 innodb_encrypted_2/t_93 innodb_encrypted_2/t_94 innodb_encrypted_2/t_95 innodb_encrypted_2/t_96 innodb_encrypted_2/t_97 innodb_encrypted_2/t_98 innodb_encrypted_2/t_99 # should contain 100 tables SELECT NAME FROM INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION WHERE MIN_KEY_VERSION = 0 AND NAME LIKE 'innodb_encrypted%' ORDER BY NAME; NAME innodb_encrypted_3/t_1 innodb_encrypted_3/t_10 innodb_encrypted_3/t_100 innodb_encrypted_3/t_11 innodb_encrypted_3/t_12 innodb_encrypted_3/t_13 innodb_encrypted_3/t_14 innodb_encrypted_3/t_15 innodb_encrypted_3/t_16 innodb_encrypted_3/t_17 innodb_encrypted_3/t_18 innodb_encrypted_3/t_19 innodb_encrypted_3/t_2 innodb_encrypted_3/t_20 innodb_encrypted_3/t_21 innodb_encrypted_3/t_22 innodb_encrypted_3/t_23 innodb_encrypted_3/t_24 innodb_encrypted_3/t_25 innodb_encrypted_3/t_26 innodb_encrypted_3/t_27 innodb_encrypted_3/t_28 innodb_encrypted_3/t_29 innodb_encrypted_3/t_3 innodb_encrypted_3/t_30 innodb_encrypted_3/t_31 innodb_encrypted_3/t_32 innodb_encrypted_3/t_33 innodb_encrypted_3/t_34 innodb_encrypted_3/t_35 innodb_encrypted_3/t_36 innodb_encrypted_3/t_37 innodb_encrypted_3/t_38 innodb_encrypted_3/t_39 innodb_encrypted_3/t_4 innodb_encrypted_3/t_40 innodb_encrypted_3/t_41 innodb_encrypted_3/t_42 innodb_encrypted_3/t_43 innodb_encrypted_3/t_44 innodb_encrypted_3/t_45 innodb_encrypted_3/t_46 innodb_encrypted_3/t_47 innodb_encrypted_3/t_48 innodb_encrypted_3/t_49 innodb_encrypted_3/t_5 innodb_encrypted_3/t_50 innodb_encrypted_3/t_51 innodb_encrypted_3/t_52 innodb_encrypted_3/t_53 innodb_encrypted_3/t_54 innodb_encrypted_3/t_55 innodb_encrypted_3/t_56 innodb_encrypted_3/t_57 innodb_encrypted_3/t_58 innodb_encrypted_3/t_59 innodb_encrypted_3/t_6 innodb_encrypted_3/t_60 innodb_encrypted_3/t_61 innodb_encrypted_3/t_62 innodb_encrypted_3/t_63 innodb_encrypted_3/t_64 innodb_encrypted_3/t_65 innodb_encrypted_3/t_66 innodb_encrypted_3/t_67 innodb_encrypted_3/t_68 innodb_encrypted_3/t_69 innodb_encrypted_3/t_7 innodb_encrypted_3/t_70 innodb_encrypted_3/t_71 innodb_encrypted_3/t_72 innodb_encrypted_3/t_73 innodb_encrypted_3/t_74 innodb_encrypted_3/t_75 innodb_encrypted_3/t_76 innodb_encrypted_3/t_77 innodb_encrypted_3/t_78 innodb_encrypted_3/t_79 innodb_encrypted_3/t_8 innodb_encrypted_3/t_80 innodb_encrypted_3/t_81 innodb_encrypted_3/t_82 innodb_encrypted_3/t_83 innodb_encrypted_3/t_84 innodb_encrypted_3/t_85 innodb_encrypted_3/t_86 innodb_encrypted_3/t_87 innodb_encrypted_3/t_88 innodb_encrypted_3/t_89 innodb_encrypted_3/t_9 innodb_encrypted_3/t_90 innodb_encrypted_3/t_91 innodb_encrypted_3/t_92 innodb_encrypted_3/t_93 innodb_encrypted_3/t_94 innodb_encrypted_3/t_95 innodb_encrypted_3/t_96 innodb_encrypted_3/t_97 innodb_encrypted_3/t_98 innodb_encrypted_3/t_99 use test; show status like 'innodb_pages0_read%'; Variable_name Value Innodb_pages0_read 4 SELECT NAME FROM INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION WHERE MIN_KEY_VERSION <> 0 AND NAME LIKE 'innodb_encrypted%' ORDER BY NAME; NAME innodb_encrypted_2/t_1 innodb_encrypted_2/t_10 innodb_encrypted_2/t_100 innodb_encrypted_2/t_11 innodb_encrypted_2/t_12 innodb_encrypted_2/t_13 innodb_encrypted_2/t_14 innodb_encrypted_2/t_15 innodb_encrypted_2/t_16 innodb_encrypted_2/t_17 innodb_encrypted_2/t_18 innodb_encrypted_2/t_19 innodb_encrypted_2/t_2 innodb_encrypted_2/t_20 innodb_encrypted_2/t_21 innodb_encrypted_2/t_22 innodb_encrypted_2/t_23 innodb_encrypted_2/t_24 innodb_encrypted_2/t_25 innodb_encrypted_2/t_26 innodb_encrypted_2/t_27 innodb_encrypted_2/t_28 innodb_encrypted_2/t_29 innodb_encrypted_2/t_3 innodb_encrypted_2/t_30 innodb_encrypted_2/t_31 innodb_encrypted_2/t_32 innodb_encrypted_2/t_33 innodb_encrypted_2/t_34 innodb_encrypted_2/t_35 innodb_encrypted_2/t_36 innodb_encrypted_2/t_37 innodb_encrypted_2/t_38 innodb_encrypted_2/t_39 innodb_encrypted_2/t_4 innodb_encrypted_2/t_40 innodb_encrypted_2/t_41 innodb_encrypted_2/t_42 innodb_encrypted_2/t_43 innodb_encrypted_2/t_44 innodb_encrypted_2/t_45 innodb_encrypted_2/t_46 innodb_encrypted_2/t_47 innodb_encrypted_2/t_48 innodb_encrypted_2/t_49 innodb_encrypted_2/t_5 innodb_encrypted_2/t_50 innodb_encrypted_2/t_51 innodb_encrypted_2/t_52 innodb_encrypted_2/t_53 innodb_encrypted_2/t_54 innodb_encrypted_2/t_55 innodb_encrypted_2/t_56 innodb_encrypted_2/t_57 innodb_encrypted_2/t_58 innodb_encrypted_2/t_59 innodb_encrypted_2/t_6 innodb_encrypted_2/t_60 innodb_encrypted_2/t_61 innodb_encrypted_2/t_62 innodb_encrypted_2/t_63 innodb_encrypted_2/t_64 innodb_encrypted_2/t_65 innodb_encrypted_2/t_66 innodb_encrypted_2/t_67 innodb_encrypted_2/t_68 innodb_encrypted_2/t_69 innodb_encrypted_2/t_7 innodb_encrypted_2/t_70 innodb_encrypted_2/t_71 innodb_encrypted_2/t_72 innodb_encrypted_2/t_73 innodb_encrypted_2/t_74 innodb_encrypted_2/t_75 innodb_encrypted_2/t_76 innodb_encrypted_2/t_77 innodb_encrypted_2/t_78 innodb_encrypted_2/t_79 innodb_encrypted_2/t_8 innodb_encrypted_2/t_80 innodb_encrypted_2/t_81 innodb_encrypted_2/t_82 innodb_encrypted_2/t_83 innodb_encrypted_2/t_84 innodb_encrypted_2/t_85 innodb_encrypted_2/t_86 innodb_encrypted_2/t_87 innodb_encrypted_2/t_88 innodb_encrypted_2/t_89 innodb_encrypted_2/t_9 innodb_encrypted_2/t_90 innodb_encrypted_2/t_91 innodb_encrypted_2/t_92 innodb_encrypted_2/t_93 innodb_encrypted_2/t_94 innodb_encrypted_2/t_95 innodb_encrypted_2/t_96 innodb_encrypted_2/t_97 innodb_encrypted_2/t_98 innodb_encrypted_2/t_99 SELECT NAME FROM INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION WHERE MIN_KEY_VERSION = 0 AND NAME LIKE 'innodb_encrypted%' ORDER BY NAME; NAME innodb_encrypted_3/t_1 innodb_encrypted_3/t_10 innodb_encrypted_3/t_100 innodb_encrypted_3/t_11 innodb_encrypted_3/t_12 innodb_encrypted_3/t_13 innodb_encrypted_3/t_14 innodb_encrypted_3/t_15 innodb_encrypted_3/t_16 innodb_encrypted_3/t_17 innodb_encrypted_3/t_18 innodb_encrypted_3/t_19 innodb_encrypted_3/t_2 innodb_encrypted_3/t_20 innodb_encrypted_3/t_21 innodb_encrypted_3/t_22 innodb_encrypted_3/t_23 innodb_encrypted_3/t_24 innodb_encrypted_3/t_25 innodb_encrypted_3/t_26 innodb_encrypted_3/t_27 innodb_encrypted_3/t_28 innodb_encrypted_3/t_29 innodb_encrypted_3/t_3 innodb_encrypted_3/t_30 innodb_encrypted_3/t_31 innodb_encrypted_3/t_32 innodb_encrypted_3/t_33 innodb_encrypted_3/t_34 innodb_encrypted_3/t_35 innodb_encrypted_3/t_36 innodb_encrypted_3/t_37 innodb_encrypted_3/t_38 innodb_encrypted_3/t_39 innodb_encrypted_3/t_4 innodb_encrypted_3/t_40 innodb_encrypted_3/t_41 innodb_encrypted_3/t_42 innodb_encrypted_3/t_43 innodb_encrypted_3/t_44 innodb_encrypted_3/t_45 innodb_encrypted_3/t_46 innodb_encrypted_3/t_47 innodb_encrypted_3/t_48 innodb_encrypted_3/t_49 innodb_encrypted_3/t_5 innodb_encrypted_3/t_50 innodb_encrypted_3/t_51 innodb_encrypted_3/t_52 innodb_encrypted_3/t_53 innodb_encrypted_3/t_54 innodb_encrypted_3/t_55 innodb_encrypted_3/t_56 innodb_encrypted_3/t_57 innodb_encrypted_3/t_58 innodb_encrypted_3/t_59 innodb_encrypted_3/t_6 innodb_encrypted_3/t_60 innodb_encrypted_3/t_61 innodb_encrypted_3/t_62 innodb_encrypted_3/t_63 innodb_encrypted_3/t_64 innodb_encrypted_3/t_65 innodb_encrypted_3/t_66 innodb_encrypted_3/t_67 innodb_encrypted_3/t_68 innodb_encrypted_3/t_69 innodb_encrypted_3/t_7 innodb_encrypted_3/t_70 innodb_encrypted_3/t_71 innodb_encrypted_3/t_72 innodb_encrypted_3/t_73 innodb_encrypted_3/t_74 innodb_encrypted_3/t_75 innodb_encrypted_3/t_76 innodb_encrypted_3/t_77 innodb_encrypted_3/t_78 innodb_encrypted_3/t_79 innodb_encrypted_3/t_8 innodb_encrypted_3/t_80 innodb_encrypted_3/t_81 innodb_encrypted_3/t_82 innodb_encrypted_3/t_83 innodb_encrypted_3/t_84 innodb_encrypted_3/t_85 innodb_encrypted_3/t_86 innodb_encrypted_3/t_87 innodb_encrypted_3/t_88 innodb_encrypted_3/t_89 innodb_encrypted_3/t_9 innodb_encrypted_3/t_90 innodb_encrypted_3/t_91 innodb_encrypted_3/t_92 innodb_encrypted_3/t_93 innodb_encrypted_3/t_94 innodb_encrypted_3/t_95 innodb_encrypted_3/t_96 innodb_encrypted_3/t_97 innodb_encrypted_3/t_98 innodb_encrypted_3/t_99 SET GLOBAL innodb_encrypt_tables = on; SET GLOBAL innodb_encryption_threads=4; SELECT NAME FROM INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION WHERE MIN_KEY_VERSION <> 0 AND NAME LIKE 'innodb_encrypted%' ORDER BY NAME; NAME innodb_encrypted_2/t_1 innodb_encrypted_2/t_10 innodb_encrypted_2/t_100 innodb_encrypted_2/t_11 innodb_encrypted_2/t_12 innodb_encrypted_2/t_13 innodb_encrypted_2/t_14 innodb_encrypted_2/t_15 innodb_encrypted_2/t_16 innodb_encrypted_2/t_17 innodb_encrypted_2/t_18 innodb_encrypted_2/t_19 innodb_encrypted_2/t_2 innodb_encrypted_2/t_20 innodb_encrypted_2/t_21 innodb_encrypted_2/t_22 innodb_encrypted_2/t_23 innodb_encrypted_2/t_24 innodb_encrypted_2/t_25 innodb_encrypted_2/t_26 innodb_encrypted_2/t_27 innodb_encrypted_2/t_28 innodb_encrypted_2/t_29 innodb_encrypted_2/t_3 innodb_encrypted_2/t_30 innodb_encrypted_2/t_31 innodb_encrypted_2/t_32 innodb_encrypted_2/t_33 innodb_encrypted_2/t_34 innodb_encrypted_2/t_35 innodb_encrypted_2/t_36 innodb_encrypted_2/t_37 innodb_encrypted_2/t_38 innodb_encrypted_2/t_39 innodb_encrypted_2/t_4 innodb_encrypted_2/t_40 innodb_encrypted_2/t_41 innodb_encrypted_2/t_42 innodb_encrypted_2/t_43 innodb_encrypted_2/t_44 innodb_encrypted_2/t_45 innodb_encrypted_2/t_46 innodb_encrypted_2/t_47 innodb_encrypted_2/t_48 innodb_encrypted_2/t_49 innodb_encrypted_2/t_5 innodb_encrypted_2/t_50 innodb_encrypted_2/t_51 innodb_encrypted_2/t_52 innodb_encrypted_2/t_53 innodb_encrypted_2/t_54 innodb_encrypted_2/t_55 innodb_encrypted_2/t_56 innodb_encrypted_2/t_57 innodb_encrypted_2/t_58 innodb_encrypted_2/t_59 innodb_encrypted_2/t_6 innodb_encrypted_2/t_60 innodb_encrypted_2/t_61 innodb_encrypted_2/t_62 innodb_encrypted_2/t_63 innodb_encrypted_2/t_64 innodb_encrypted_2/t_65 innodb_encrypted_2/t_66 innodb_encrypted_2/t_67 innodb_encrypted_2/t_68 innodb_encrypted_2/t_69 innodb_encrypted_2/t_7 innodb_encrypted_2/t_70 innodb_encrypted_2/t_71 innodb_encrypted_2/t_72 innodb_encrypted_2/t_73 innodb_encrypted_2/t_74 innodb_encrypted_2/t_75 innodb_encrypted_2/t_76 innodb_encrypted_2/t_77 innodb_encrypted_2/t_78 innodb_encrypted_2/t_79 innodb_encrypted_2/t_8 innodb_encrypted_2/t_80 innodb_encrypted_2/t_81 innodb_encrypted_2/t_82 innodb_encrypted_2/t_83 innodb_encrypted_2/t_84 innodb_encrypted_2/t_85 innodb_encrypted_2/t_86 innodb_encrypted_2/t_87 innodb_encrypted_2/t_88 innodb_encrypted_2/t_89 innodb_encrypted_2/t_9 innodb_encrypted_2/t_90 innodb_encrypted_2/t_91 innodb_encrypted_2/t_92 innodb_encrypted_2/t_93 innodb_encrypted_2/t_94 innodb_encrypted_2/t_95 innodb_encrypted_2/t_96 innodb_encrypted_2/t_97 innodb_encrypted_2/t_98 innodb_encrypted_2/t_99 SELECT NAME FROM INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION WHERE MIN_KEY_VERSION = 0 AND NAME LIKE 'innodb_encrypted%' ORDER BY NAME; NAME innodb_encrypted_3/t_1 innodb_encrypted_3/t_10 innodb_encrypted_3/t_100 innodb_encrypted_3/t_11 innodb_encrypted_3/t_12 innodb_encrypted_3/t_13 innodb_encrypted_3/t_14 innodb_encrypted_3/t_15 innodb_encrypted_3/t_16 innodb_encrypted_3/t_17 innodb_encrypted_3/t_18 innodb_encrypted_3/t_19 innodb_encrypted_3/t_2 innodb_encrypted_3/t_20 innodb_encrypted_3/t_21 innodb_encrypted_3/t_22 innodb_encrypted_3/t_23 innodb_encrypted_3/t_24 innodb_encrypted_3/t_25 innodb_encrypted_3/t_26 innodb_encrypted_3/t_27 innodb_encrypted_3/t_28 innodb_encrypted_3/t_29 innodb_encrypted_3/t_3 innodb_encrypted_3/t_30 innodb_encrypted_3/t_31 innodb_encrypted_3/t_32 innodb_encrypted_3/t_33 innodb_encrypted_3/t_34 innodb_encrypted_3/t_35 innodb_encrypted_3/t_36 innodb_encrypted_3/t_37 innodb_encrypted_3/t_38 innodb_encrypted_3/t_39 innodb_encrypted_3/t_4 innodb_encrypted_3/t_40 innodb_encrypted_3/t_41 innodb_encrypted_3/t_42 innodb_encrypted_3/t_43 innodb_encrypted_3/t_44 innodb_encrypted_3/t_45 innodb_encrypted_3/t_46 innodb_encrypted_3/t_47 innodb_encrypted_3/t_48 innodb_encrypted_3/t_49 innodb_encrypted_3/t_5 innodb_encrypted_3/t_50 innodb_encrypted_3/t_51 innodb_encrypted_3/t_52 innodb_encrypted_3/t_53 innodb_encrypted_3/t_54 innodb_encrypted_3/t_55 innodb_encrypted_3/t_56 innodb_encrypted_3/t_57 innodb_encrypted_3/t_58 innodb_encrypted_3/t_59 innodb_encrypted_3/t_6 innodb_encrypted_3/t_60 innodb_encrypted_3/t_61 innodb_encrypted_3/t_62 innodb_encrypted_3/t_63 innodb_encrypted_3/t_64 innodb_encrypted_3/t_65 innodb_encrypted_3/t_66 innodb_encrypted_3/t_67 innodb_encrypted_3/t_68 innodb_encrypted_3/t_69 innodb_encrypted_3/t_7 innodb_encrypted_3/t_70 innodb_encrypted_3/t_71 innodb_encrypted_3/t_72 innodb_encrypted_3/t_73 innodb_encrypted_3/t_74 innodb_encrypted_3/t_75 innodb_encrypted_3/t_76 innodb_encrypted_3/t_77 innodb_encrypted_3/t_78 innodb_encrypted_3/t_79 innodb_encrypted_3/t_8 innodb_encrypted_3/t_80 innodb_encrypted_3/t_81 innodb_encrypted_3/t_82 innodb_encrypted_3/t_83 innodb_encrypted_3/t_84 innodb_encrypted_3/t_85 innodb_encrypted_3/t_86 innodb_encrypted_3/t_87 innodb_encrypted_3/t_88 innodb_encrypted_3/t_89 innodb_encrypted_3/t_9 innodb_encrypted_3/t_90 innodb_encrypted_3/t_91 innodb_encrypted_3/t_92 innodb_encrypted_3/t_93 innodb_encrypted_3/t_94 innodb_encrypted_3/t_95 innodb_encrypted_3/t_96 innodb_encrypted_3/t_97 innodb_encrypted_3/t_98 innodb_encrypted_3/t_99 show status like 'innodb_pages0_read%'; Variable_name Value Innodb_pages0_read 4 # Success! # Restart mysqld --innodb_encrypt_tables=0 --innodb_encryption_threads=0 # Restart Success! SELECT variable_value <= 303 FROM information_schema.global_status WHERE variable_name = 'innodb_pages0_read'; variable_value <= 303 1 use test; SELECT variable_value <= 303 FROM information_schema.global_status WHERE variable_name = 'innodb_pages0_read'; variable_value <= 303 1 use innodb_encrypted_1; SELECT variable_value <= 303 FROM information_schema.global_status WHERE variable_name = 'innodb_pages0_read'; variable_value <= 303 1 use innodb_encrypted_2; SELECT variable_value <= 303 FROM information_schema.global_status WHERE variable_name = 'innodb_pages0_read'; variable_value <= 303 1 use innodb_encrypted_3; SELECT variable_value <= 303 FROM information_schema.global_status WHERE variable_name = 'innodb_pages0_read'; variable_value <= 303 1 use innodb_encrypted_1; SELECT variable_value <= 303 FROM information_schema.global_status WHERE variable_name = 'innodb_pages0_read'; variable_value <= 303 1 use innodb_encrypted_2; SELECT variable_value <= 303 FROM information_schema.global_status WHERE variable_name = 'innodb_pages0_read'; variable_value <= 303 1 use innodb_encrypted_3; SELECT variable_value <= 303 FROM information_schema.global_status WHERE variable_name = 'innodb_pages0_read'; variable_value <= 303 1 SELECT NAME FROM INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION WHERE MIN_KEY_VERSION = 0 AND NAME LIKE 'innodb_encrypted%' ORDER BY NAME; NAME innodb_encrypted_3/t_1 innodb_encrypted_3/t_10 innodb_encrypted_3/t_100 innodb_encrypted_3/t_11 innodb_encrypted_3/t_12 innodb_encrypted_3/t_13 innodb_encrypted_3/t_14 innodb_encrypted_3/t_15 innodb_encrypted_3/t_16 innodb_encrypted_3/t_17 innodb_encrypted_3/t_18 innodb_encrypted_3/t_19 innodb_encrypted_3/t_2 innodb_encrypted_3/t_20 innodb_encrypted_3/t_21 innodb_encrypted_3/t_22 innodb_encrypted_3/t_23 innodb_encrypted_3/t_24 innodb_encrypted_3/t_25 innodb_encrypted_3/t_26 innodb_encrypted_3/t_27 innodb_encrypted_3/t_28 innodb_encrypted_3/t_29 innodb_encrypted_3/t_3 innodb_encrypted_3/t_30 innodb_encrypted_3/t_31 innodb_encrypted_3/t_32 innodb_encrypted_3/t_33 innodb_encrypted_3/t_34 innodb_encrypted_3/t_35 innodb_encrypted_3/t_36 innodb_encrypted_3/t_37 innodb_encrypted_3/t_38 innodb_encrypted_3/t_39 innodb_encrypted_3/t_4 innodb_encrypted_3/t_40 innodb_encrypted_3/t_41 innodb_encrypted_3/t_42 innodb_encrypted_3/t_43 innodb_encrypted_3/t_44 innodb_encrypted_3/t_45 innodb_encrypted_3/t_46 innodb_encrypted_3/t_47 innodb_encrypted_3/t_48 innodb_encrypted_3/t_49 innodb_encrypted_3/t_5 innodb_encrypted_3/t_50 innodb_encrypted_3/t_51 innodb_encrypted_3/t_52 innodb_encrypted_3/t_53 innodb_encrypted_3/t_54 innodb_encrypted_3/t_55 innodb_encrypted_3/t_56 innodb_encrypted_3/t_57 innodb_encrypted_3/t_58 innodb_encrypted_3/t_59 innodb_encrypted_3/t_6 innodb_encrypted_3/t_60 innodb_encrypted_3/t_61 innodb_encrypted_3/t_62 innodb_encrypted_3/t_63 innodb_encrypted_3/t_64 innodb_encrypted_3/t_65 innodb_encrypted_3/t_66 innodb_encrypted_3/t_67 innodb_encrypted_3/t_68 innodb_encrypted_3/t_69 innodb_encrypted_3/t_7 innodb_encrypted_3/t_70 innodb_encrypted_3/t_71 innodb_encrypted_3/t_72 innodb_encrypted_3/t_73 innodb_encrypted_3/t_74 innodb_encrypted_3/t_75 innodb_encrypted_3/t_76 innodb_encrypted_3/t_77 innodb_encrypted_3/t_78 innodb_encrypted_3/t_79 innodb_encrypted_3/t_8 innodb_encrypted_3/t_80 innodb_encrypted_3/t_81 innodb_encrypted_3/t_82 innodb_encrypted_3/t_83 innodb_encrypted_3/t_84 innodb_encrypted_3/t_85 innodb_encrypted_3/t_86 innodb_encrypted_3/t_87 innodb_encrypted_3/t_88 innodb_encrypted_3/t_89 innodb_encrypted_3/t_9 innodb_encrypted_3/t_90 innodb_encrypted_3/t_91 innodb_encrypted_3/t_92 innodb_encrypted_3/t_93 innodb_encrypted_3/t_94 innodb_encrypted_3/t_95 innodb_encrypted_3/t_96 innodb_encrypted_3/t_97 innodb_encrypted_3/t_98 innodb_encrypted_3/t_99 SELECT NAME FROM INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION WHERE MIN_KEY_VERSION <> 0 AND NAME LIKE 'innodb_encrypted%' ORDER BY NAME; NAME innodb_encrypted_2/t_1 innodb_encrypted_2/t_10 innodb_encrypted_2/t_100 innodb_encrypted_2/t_11 innodb_encrypted_2/t_12 innodb_encrypted_2/t_13 innodb_encrypted_2/t_14 innodb_encrypted_2/t_15 innodb_encrypted_2/t_16 innodb_encrypted_2/t_17 innodb_encrypted_2/t_18 innodb_encrypted_2/t_19 innodb_encrypted_2/t_2 innodb_encrypted_2/t_20 innodb_encrypted_2/t_21 innodb_encrypted_2/t_22 innodb_encrypted_2/t_23 innodb_encrypted_2/t_24 innodb_encrypted_2/t_25 innodb_encrypted_2/t_26 innodb_encrypted_2/t_27 innodb_encrypted_2/t_28 innodb_encrypted_2/t_29 innodb_encrypted_2/t_3 innodb_encrypted_2/t_30 innodb_encrypted_2/t_31 innodb_encrypted_2/t_32 innodb_encrypted_2/t_33 innodb_encrypted_2/t_34 innodb_encrypted_2/t_35 innodb_encrypted_2/t_36 innodb_encrypted_2/t_37 innodb_encrypted_2/t_38 innodb_encrypted_2/t_39 innodb_encrypted_2/t_4 innodb_encrypted_2/t_40 innodb_encrypted_2/t_41 innodb_encrypted_2/t_42 innodb_encrypted_2/t_43 innodb_encrypted_2/t_44 innodb_encrypted_2/t_45 innodb_encrypted_2/t_46 innodb_encrypted_2/t_47 innodb_encrypted_2/t_48 innodb_encrypted_2/t_49 innodb_encrypted_2/t_5 innodb_encrypted_2/t_50 innodb_encrypted_2/t_51 innodb_encrypted_2/t_52 innodb_encrypted_2/t_53 innodb_encrypted_2/t_54 innodb_encrypted_2/t_55 innodb_encrypted_2/t_56 innodb_encrypted_2/t_57 innodb_encrypted_2/t_58 innodb_encrypted_2/t_59 innodb_encrypted_2/t_6 innodb_encrypted_2/t_60 innodb_encrypted_2/t_61 innodb_encrypted_2/t_62 innodb_encrypted_2/t_63 innodb_encrypted_2/t_64 innodb_encrypted_2/t_65 innodb_encrypted_2/t_66 innodb_encrypted_2/t_67 innodb_encrypted_2/t_68 innodb_encrypted_2/t_69 innodb_encrypted_2/t_7 innodb_encrypted_2/t_70 innodb_encrypted_2/t_71 innodb_encrypted_2/t_72 innodb_encrypted_2/t_73 innodb_encrypted_2/t_74 innodb_encrypted_2/t_75 innodb_encrypted_2/t_76 innodb_encrypted_2/t_77 innodb_encrypted_2/t_78 innodb_encrypted_2/t_79 innodb_encrypted_2/t_8 innodb_encrypted_2/t_80 innodb_encrypted_2/t_81 innodb_encrypted_2/t_82 innodb_encrypted_2/t_83 innodb_encrypted_2/t_84 innodb_encrypted_2/t_85 innodb_encrypted_2/t_86 innodb_encrypted_2/t_87 innodb_encrypted_2/t_88 innodb_encrypted_2/t_89 innodb_encrypted_2/t_9 innodb_encrypted_2/t_90 innodb_encrypted_2/t_91 innodb_encrypted_2/t_92 innodb_encrypted_2/t_93 innodb_encrypted_2/t_94 innodb_encrypted_2/t_95 innodb_encrypted_2/t_96 innodb_encrypted_2/t_97 innodb_encrypted_2/t_98 innodb_encrypted_2/t_99 SET GLOBAL innodb_encrypt_tables = off; SET GLOBAL innodb_encryption_threads=4; SELECT NAME FROM INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION WHERE MIN_KEY_VERSION <> 0 AND NAME LIKE 'innodb_encrypted%' ORDER BY NAME; NAME innodb_encrypted_2/t_1 innodb_encrypted_2/t_10 innodb_encrypted_2/t_100 innodb_encrypted_2/t_11 innodb_encrypted_2/t_12 innodb_encrypted_2/t_13 innodb_encrypted_2/t_14 innodb_encrypted_2/t_15 innodb_encrypted_2/t_16 innodb_encrypted_2/t_17 innodb_encrypted_2/t_18 innodb_encrypted_2/t_19 innodb_encrypted_2/t_2 innodb_encrypted_2/t_20 innodb_encrypted_2/t_21 innodb_encrypted_2/t_22 innodb_encrypted_2/t_23 innodb_encrypted_2/t_24 innodb_encrypted_2/t_25 innodb_encrypted_2/t_26 innodb_encrypted_2/t_27 innodb_encrypted_2/t_28 innodb_encrypted_2/t_29 innodb_encrypted_2/t_3 innodb_encrypted_2/t_30 innodb_encrypted_2/t_31 innodb_encrypted_2/t_32 innodb_encrypted_2/t_33 innodb_encrypted_2/t_34 innodb_encrypted_2/t_35 innodb_encrypted_2/t_36 innodb_encrypted_2/t_37 innodb_encrypted_2/t_38 innodb_encrypted_2/t_39 innodb_encrypted_2/t_4 innodb_encrypted_2/t_40 innodb_encrypted_2/t_41 innodb_encrypted_2/t_42 innodb_encrypted_2/t_43 innodb_encrypted_2/t_44 innodb_encrypted_2/t_45 innodb_encrypted_2/t_46 innodb_encrypted_2/t_47 innodb_encrypted_2/t_48 innodb_encrypted_2/t_49 innodb_encrypted_2/t_5 innodb_encrypted_2/t_50 innodb_encrypted_2/t_51 innodb_encrypted_2/t_52 innodb_encrypted_2/t_53 innodb_encrypted_2/t_54 innodb_encrypted_2/t_55 innodb_encrypted_2/t_56 innodb_encrypted_2/t_57 innodb_encrypted_2/t_58 innodb_encrypted_2/t_59 innodb_encrypted_2/t_6 innodb_encrypted_2/t_60 innodb_encrypted_2/t_61 innodb_encrypted_2/t_62 innodb_encrypted_2/t_63 innodb_encrypted_2/t_64 innodb_encrypted_2/t_65 innodb_encrypted_2/t_66 innodb_encrypted_2/t_67 innodb_encrypted_2/t_68 innodb_encrypted_2/t_69 innodb_encrypted_2/t_7 innodb_encrypted_2/t_70 innodb_encrypted_2/t_71 innodb_encrypted_2/t_72 innodb_encrypted_2/t_73 innodb_encrypted_2/t_74 innodb_encrypted_2/t_75 innodb_encrypted_2/t_76 innodb_encrypted_2/t_77 innodb_encrypted_2/t_78 innodb_encrypted_2/t_79 innodb_encrypted_2/t_8 innodb_encrypted_2/t_80 innodb_encrypted_2/t_81 innodb_encrypted_2/t_82 innodb_encrypted_2/t_83 innodb_encrypted_2/t_84 innodb_encrypted_2/t_85 innodb_encrypted_2/t_86 innodb_encrypted_2/t_87 innodb_encrypted_2/t_88 innodb_encrypted_2/t_89 innodb_encrypted_2/t_9 innodb_encrypted_2/t_90 innodb_encrypted_2/t_91 innodb_encrypted_2/t_92 innodb_encrypted_2/t_93 innodb_encrypted_2/t_94 innodb_encrypted_2/t_95 innodb_encrypted_2/t_96 innodb_encrypted_2/t_97 innodb_encrypted_2/t_98 innodb_encrypted_2/t_99 SELECT NAME FROM INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION WHERE MIN_KEY_VERSION = 0 AND NAME LIKE 'innodb_encrypted%' ORDER BY NAME; NAME innodb_encrypted_3/t_1 innodb_encrypted_3/t_10 innodb_encrypted_3/t_100 innodb_encrypted_3/t_11 innodb_encrypted_3/t_12 innodb_encrypted_3/t_13 innodb_encrypted_3/t_14 innodb_encrypted_3/t_15 innodb_encrypted_3/t_16 innodb_encrypted_3/t_17 innodb_encrypted_3/t_18 innodb_encrypted_3/t_19 innodb_encrypted_3/t_2 innodb_encrypted_3/t_20 innodb_encrypted_3/t_21 innodb_encrypted_3/t_22 innodb_encrypted_3/t_23 innodb_encrypted_3/t_24 innodb_encrypted_3/t_25 innodb_encrypted_3/t_26 innodb_encrypted_3/t_27 innodb_encrypted_3/t_28 innodb_encrypted_3/t_29 innodb_encrypted_3/t_3 innodb_encrypted_3/t_30 innodb_encrypted_3/t_31 innodb_encrypted_3/t_32 innodb_encrypted_3/t_33 innodb_encrypted_3/t_34 innodb_encrypted_3/t_35 innodb_encrypted_3/t_36 innodb_encrypted_3/t_37 innodb_encrypted_3/t_38 innodb_encrypted_3/t_39 innodb_encrypted_3/t_4 innodb_encrypted_3/t_40 innodb_encrypted_3/t_41 innodb_encrypted_3/t_42 innodb_encrypted_3/t_43 innodb_encrypted_3/t_44 innodb_encrypted_3/t_45 innodb_encrypted_3/t_46 innodb_encrypted_3/t_47 innodb_encrypted_3/t_48 innodb_encrypted_3/t_49 innodb_encrypted_3/t_5 innodb_encrypted_3/t_50 innodb_encrypted_3/t_51 innodb_encrypted_3/t_52 innodb_encrypted_3/t_53 innodb_encrypted_3/t_54 innodb_encrypted_3/t_55 innodb_encrypted_3/t_56 innodb_encrypted_3/t_57 innodb_encrypted_3/t_58 innodb_encrypted_3/t_59 innodb_encrypted_3/t_6 innodb_encrypted_3/t_60 innodb_encrypted_3/t_61 innodb_encrypted_3/t_62 innodb_encrypted_3/t_63 innodb_encrypted_3/t_64 innodb_encrypted_3/t_65 innodb_encrypted_3/t_66 innodb_encrypted_3/t_67 innodb_encrypted_3/t_68 innodb_encrypted_3/t_69 innodb_encrypted_3/t_7 innodb_encrypted_3/t_70 innodb_encrypted_3/t_71 innodb_encrypted_3/t_72 innodb_encrypted_3/t_73 innodb_encrypted_3/t_74 innodb_encrypted_3/t_75 innodb_encrypted_3/t_76 innodb_encrypted_3/t_77 innodb_encrypted_3/t_78 innodb_encrypted_3/t_79 innodb_encrypted_3/t_8 innodb_encrypted_3/t_80 innodb_encrypted_3/t_81 innodb_encrypted_3/t_82 innodb_encrypted_3/t_83 innodb_encrypted_3/t_84 innodb_encrypted_3/t_85 innodb_encrypted_3/t_86 innodb_encrypted_3/t_87 innodb_encrypted_3/t_88 innodb_encrypted_3/t_89 innodb_encrypted_3/t_9 innodb_encrypted_3/t_90 innodb_encrypted_3/t_91 innodb_encrypted_3/t_92 innodb_encrypted_3/t_93 innodb_encrypted_3/t_94 innodb_encrypted_3/t_95 innodb_encrypted_3/t_96 innodb_encrypted_3/t_97 innodb_encrypted_3/t_98 innodb_encrypted_3/t_99 use test; drop database innodb_encrypted_1; drop database innodb_encrypted_2; drop database innodb_encrypted_3;