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