1SET @start_global_value = @@global.innodb_undo_log_encrypt; 2SELECT @start_global_value; 3@start_global_value 40 5select @@global.innodb_undo_log_encrypt in (0, 1); 6@@global.innodb_undo_log_encrypt in (0, 1) 71 8select @@global.innodb_undo_log_encrypt; 9@@global.innodb_undo_log_encrypt 100 11select @@session.innodb_undo_log_encrypt; 12ERROR HY000: Variable 'innodb_undo_log_encrypt' is a GLOBAL variable 13show global variables like 'innodb_undo_log_encrypt'; 14Variable_name Value 15innodb_undo_log_encrypt OFF 16show session variables like 'innodb_undo_log_encrypt'; 17Variable_name Value 18innodb_undo_log_encrypt OFF 19select * from performance_schema.global_variables where variable_name='innodb_undo_log_encrypt'; 20VARIABLE_NAME VARIABLE_VALUE 21innodb_undo_log_encrypt OFF 22select * from performance_schema.session_variables where variable_name='innodb_undo_log_encrypt'; 23VARIABLE_NAME VARIABLE_VALUE 24innodb_undo_log_encrypt OFF 25set global innodb_undo_log_encrypt=1; 26select @@global.innodb_undo_log_encrypt; 27@@global.innodb_undo_log_encrypt 280 29select * from performance_schema.global_variables where variable_name='innodb_undo_log_encrypt'; 30VARIABLE_NAME VARIABLE_VALUE 31innodb_undo_log_encrypt OFF 32select * from performance_schema.session_variables where variable_name='innodb_undo_log_encrypt'; 33VARIABLE_NAME VARIABLE_VALUE 34innodb_undo_log_encrypt OFF 35set @@global.innodb_undo_log_encrypt=0; 36select @@global.innodb_undo_log_encrypt; 37@@global.innodb_undo_log_encrypt 380 39select * from performance_schema.global_variables where variable_name='innodb_undo_log_encrypt'; 40VARIABLE_NAME VARIABLE_VALUE 41innodb_undo_log_encrypt OFF 42select * from performance_schema.session_variables where variable_name='innodb_undo_log_encrypt'; 43VARIABLE_NAME VARIABLE_VALUE 44innodb_undo_log_encrypt OFF 45set session innodb_undo_log_encrypt='some'; 46ERROR HY000: Variable 'innodb_undo_log_encrypt' is a GLOBAL variable and should be set with SET GLOBAL 47set @@session.innodb_undo_log_encrypt='some'; 48ERROR HY000: Variable 'innodb_undo_log_encrypt' is a GLOBAL variable and should be set with SET GLOBAL 49set global innodb_undo_log_encrypt=1.1; 50ERROR 42000: Incorrect argument type to variable 'innodb_undo_log_encrypt' 51set global innodb_undo_log_encrypt='foo'; 52ERROR 42000: Variable 'innodb_undo_log_encrypt' can't be set to the value of 'foo' 53set global innodb_undo_log_encrypt=-2; 54ERROR 42000: Variable 'innodb_undo_log_encrypt' can't be set to the value of '-2' 55set global innodb_undo_log_encrypt=1e1; 56ERROR 42000: Incorrect argument type to variable 'innodb_undo_log_encrypt' 57set global innodb_undo_log_encrypt=2; 58ERROR 42000: Variable 'innodb_undo_log_encrypt' can't be set to the value of '2' 59SET @@global.innodb_undo_log_encrypt = @start_global_value; 60SELECT @@global.innodb_undo_log_encrypt; 61@@global.innodb_undo_log_encrypt 620 63