1SET @start_global_value = @@global.thread_pool_max_threads;
2select @@global.thread_pool_max_threads;
3@@global.thread_pool_max_threads
465536
5select @@session.thread_pool_max_threads;
6ERROR HY000: Variable 'thread_pool_max_threads' is a GLOBAL variable
7show global variables like 'thread_pool_max_threads';
8Variable_name	Value
9thread_pool_max_threads	65536
10show session variables like 'thread_pool_max_threads';
11Variable_name	Value
12thread_pool_max_threads	65536
13select * from information_schema.global_variables where variable_name='thread_pool_max_threads';
14VARIABLE_NAME	VARIABLE_VALUE
15THREAD_POOL_MAX_THREADS	65536
16select * from information_schema.session_variables where variable_name='thread_pool_max_threads';
17VARIABLE_NAME	VARIABLE_VALUE
18THREAD_POOL_MAX_THREADS	65536
19set global thread_pool_max_threads=1;
20select @@global.thread_pool_max_threads;
21@@global.thread_pool_max_threads
221
23set global thread_pool_max_threads=65536;
24select @@global.thread_pool_max_threads;
25@@global.thread_pool_max_threads
2665536
27set session thread_pool_max_threads=1;
28ERROR HY000: Variable 'thread_pool_max_threads' is a GLOBAL variable and should be set with SET GLOBAL
29set global thread_pool_max_threads=1.1;
30ERROR 42000: Incorrect argument type to variable 'thread_pool_max_threads'
31set global thread_pool_max_threads=1e1;
32ERROR 42000: Incorrect argument type to variable 'thread_pool_max_threads'
33set global thread_pool_max_threads="foo";
34ERROR 42000: Incorrect argument type to variable 'thread_pool_max_threads'
35set global thread_pool_max_threads=0;
36Warnings:
37Warning	1292	Truncated incorrect thread_pool_max_threads value: '0'
38select @@global.thread_pool_max_threads;
39@@global.thread_pool_max_threads
401
41set global thread_pool_max_threads=10000000000;
42Warnings:
43Warning	1292	Truncated incorrect thread_pool_max_threads value: '10000000000'
44select @@global.thread_pool_max_threads;
45@@global.thread_pool_max_threads
4665536
47SET @@global.thread_pool_max_threads = @start_global_value;
48