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