1SET @start_global_value = @@global.innodb_temp_tablespace_encrypt; 2SELECT @start_global_value; 3@start_global_value 40 5SELECT @@global.innodb_temp_tablespace_encrypt IN (0, 1); 6@@global.innodb_temp_tablespace_encrypt IN (0, 1) 71 8SELECT @@global.innodb_temp_tablespace_encrypt; 9@@global.innodb_temp_tablespace_encrypt 100 11SELECT @@session.innodb_temp_tablespace_encrypt; 12ERROR HY000: Variable 'innodb_temp_tablespace_encrypt' is a GLOBAL variable 13SHOW GLOBAL VARIABLES LIKE 'innodb_temp_tablespace_encrypt'; 14Variable_name Value 15innodb_temp_tablespace_encrypt OFF 16SHOW SESSION VARIABLES LIKE 'innodb_temp_tablespace_encrypt'; 17Variable_name Value 18innodb_temp_tablespace_encrypt OFF 19SELECT * FROM performance_schema.global_variables WHERE variable_name = 'innodb_temp_tablespace_encrypt'; 20VARIABLE_NAME VARIABLE_VALUE 21innodb_temp_tablespace_encrypt OFF 22SELECT * FROM performance_schema.session_variables WHERE variable_name = 'innodb_temp_tablespace_encrypt'; 23VARIABLE_NAME VARIABLE_VALUE 24innodb_temp_tablespace_encrypt OFF 25SET GLOBAL innodb_temp_tablespace_encrypt = 1; 26Warnings: 27Warning 1210 Temporary tablespace couldn't be encrypted. Check if keyring plugin is loaded. 28SELECT @@global.innodb_temp_tablespace_encrypt; 29@@global.innodb_temp_tablespace_encrypt 300 31SELECT * FROM performance_schema.global_variables WHERE variable_name = 'innodb_temp_tablespace_encrypt'; 32VARIABLE_NAME VARIABLE_VALUE 33innodb_temp_tablespace_encrypt OFF 34SELECT * FROM performance_schema.session_variables WHERE variable_name = 'innodb_temp_tablespace_encrypt'; 35VARIABLE_NAME VARIABLE_VALUE 36innodb_temp_tablespace_encrypt OFF 37SET @@global.innodb_temp_tablespace_encrypt = 0; 38SELECT @@global.innodb_temp_tablespace_encrypt; 39@@global.innodb_temp_tablespace_encrypt 400 41SELECT * FROM performance_schema.global_variables WHERE variable_name = 'innodb_temp_tablespace_encrypt'; 42VARIABLE_NAME VARIABLE_VALUE 43innodb_temp_tablespace_encrypt OFF 44SELECT * FROM performance_schema.session_variables WHERE variable_name = 'innodb_temp_tablespace_encrypt'; 45VARIABLE_NAME VARIABLE_VALUE 46innodb_temp_tablespace_encrypt OFF 47SET SESSION innodb_temp_tablespace_encrypt = 'some'; 48ERROR HY000: Variable 'innodb_temp_tablespace_encrypt' is a GLOBAL variable and should be set with SET GLOBAL 49SET @@session.innodb_temp_tablespace_encrypt = 'some'; 50ERROR HY000: Variable 'innodb_temp_tablespace_encrypt' is a GLOBAL variable and should be set with SET GLOBAL 51SET GLOBAL innodb_temp_tablespace_encrypt = 1.1; 52ERROR 42000: Incorrect argument type to variable 'innodb_temp_tablespace_encrypt' 53SET GLOBAL innodb_temp_tablespace_encrypt = 'foo'; 54ERROR 42000: Variable 'innodb_temp_tablespace_encrypt' can't be set to the value of 'foo' 55SET GLOBAL innodb_temp_tablespace_encrypt = -2; 56ERROR 42000: Variable 'innodb_temp_tablespace_encrypt' can't be set to the value of '-2' 57SET GLOBAL innodb_temp_tablespace_encrypt = 1e1; 58ERROR 42000: Incorrect argument type to variable 'innodb_temp_tablespace_encrypt' 59SET GLOBAL innodb_temp_tablespace_encrypt = 2; 60ERROR 42000: Variable 'innodb_temp_tablespace_encrypt' can't be set to the value of '2' 61SET @@global.innodb_temp_tablespace_encrypt = @start_global_value; 62SELECT @@global.innodb_temp_tablespace_encrypt; 63@@global.innodb_temp_tablespace_encrypt 640 65