Debian Codegraph @

mysql-test/suite/sys_vars/r/thread_pool_stall_limit_basic.result

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