Debian Codegraph @

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

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