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