1SET @start_global_value = @@global.innodb_encryption_threads; 2select @@global.innodb_encryption_threads; 3@@global.innodb_encryption_threads 40 5select @@session.innodb_encryption_threads; 6ERROR HY000: Variable 'innodb_encryption_threads' is a GLOBAL variable 7show global variables like 'innodb_encryption_threads'; 8Variable_name Value 9innodb_encryption_threads 0 10show session variables like 'innodb_encryption_threads'; 11Variable_name Value 12innodb_encryption_threads 0 13select * from information_schema.global_variables 14where variable_name='innodb_encryption_threads'; 15VARIABLE_NAME VARIABLE_VALUE 16INNODB_ENCRYPTION_THREADS 0 17select * from information_schema.session_variables 18where variable_name='innodb_encryption_threads'; 19VARIABLE_NAME VARIABLE_VALUE 20INNODB_ENCRYPTION_THREADS 0 21set global innodb_encryption_threads=0; 22select @@global.innodb_encryption_threads; 23@@global.innodb_encryption_threads 240 25set global innodb_encryption_threads=5; 26select @@global.innodb_encryption_threads; 27@@global.innodb_encryption_threads 285 29set global innodb_encryption_threads=1; 30select @@global.innodb_encryption_threads; 31@@global.innodb_encryption_threads 321 33set session innodb_encryption_threads=1; 34ERROR HY000: Variable 'innodb_encryption_threads' is a GLOBAL variable and should be set with SET GLOBAL 35set global innodb_encryption_threads=1.1; 36ERROR 42000: Incorrect argument type to variable 'innodb_encryption_threads' 37set global innodb_encryption_threads=1e1; 38ERROR 42000: Incorrect argument type to variable 'innodb_encryption_threads' 39set global innodb_encryption_threads="foo"; 40ERROR 42000: Incorrect argument type to variable 'innodb_encryption_threads' 41SET @@global.innodb_encryption_threads = @start_global_value; 42