1SET @start_global_value = @@global.thread_pool_oversubscribe; 2select @@global.thread_pool_oversubscribe; 3@@global.thread_pool_oversubscribe 43 5select @@session.thread_pool_oversubscribe; 6ERROR HY000: Variable 'thread_pool_oversubscribe' is a GLOBAL variable 7show global variables like 'thread_pool_oversubscribe'; 8Variable_name Value 9thread_pool_oversubscribe 3 10show session variables like 'thread_pool_oversubscribe'; 11Variable_name Value 12thread_pool_oversubscribe 3 13select * from information_schema.global_variables where variable_name='thread_pool_oversubscribe'; 14VARIABLE_NAME VARIABLE_VALUE 15THREAD_POOL_OVERSUBSCRIBE 3 16Warnings: 17Warning 1287 'INFORMATION_SCHEMA.GLOBAL_VARIABLES' is deprecated and will be removed in a future release. Please use performance_schema.global_variables instead 18select * from information_schema.session_variables where variable_name='thread_pool_oversubscribe'; 19VARIABLE_NAME VARIABLE_VALUE 20THREAD_POOL_OVERSUBSCRIBE 3 21Warnings: 22Warning 1287 'INFORMATION_SCHEMA.SESSION_VARIABLES' is deprecated and will be removed in a future release. Please use performance_schema.session_variables instead 23set global thread_pool_oversubscribe=60; 24select @@global.thread_pool_oversubscribe; 25@@global.thread_pool_oversubscribe 2660 27set global thread_pool_oversubscribe=1000; 28select @@global.thread_pool_oversubscribe; 29@@global.thread_pool_oversubscribe 301000 31set session thread_pool_oversubscribe=1; 32ERROR HY000: Variable 'thread_pool_oversubscribe' is a GLOBAL variable and should be set with SET GLOBAL 33set global thread_pool_oversubscribe=1.1; 34ERROR 42000: Incorrect argument type to variable 'thread_pool_oversubscribe' 35set global thread_pool_oversubscribe=1e1; 36ERROR 42000: Incorrect argument type to variable 'thread_pool_oversubscribe' 37set global thread_pool_oversubscribe="foo"; 38ERROR 42000: Incorrect argument type to variable 'thread_pool_oversubscribe' 39set global thread_pool_oversubscribe=-1; 40Warnings: 41Warning 1292 Truncated incorrect thread_pool_oversubscribe value: '-1' 42select @@global.thread_pool_oversubscribe; 43@@global.thread_pool_oversubscribe 441 45set global thread_pool_oversubscribe=10000000000; 46Warnings: 47Warning 1292 Truncated incorrect thread_pool_oversubscribe value: '10000000000' 48select @@global.thread_pool_oversubscribe; 49@@global.thread_pool_oversubscribe 501000 51set @@global.thread_pool_oversubscribe = @start_global_value; 52