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