1SET @start_global_value = @@global.thread_pool_high_prio_tickets; 2set @@global.thread_pool_high_prio_tickets=default; 3select @@global.thread_pool_high_prio_tickets; 4@@global.thread_pool_high_prio_tickets 54294967295 6set @@session.thread_pool_high_prio_tickets=default; 7select @@session.thread_pool_high_prio_tickets; 8@@session.thread_pool_high_prio_tickets 94294967295 10show global variables like 'thread_pool_high_prio_tickets'; 11Variable_name Value 12thread_pool_high_prio_tickets 4294967295 13show session variables like 'thread_pool_high_prio_tickets'; 14Variable_name Value 15thread_pool_high_prio_tickets 4294967295 16select * from information_schema.global_variables where variable_name='thread_pool_high_prio_tickets'; 17VARIABLE_NAME VARIABLE_VALUE 18THREAD_POOL_HIGH_PRIO_TICKETS 4294967295 19select * from information_schema.session_variables where variable_name='thread_pool_high_prio_tickets'; 20VARIABLE_NAME VARIABLE_VALUE 21THREAD_POOL_HIGH_PRIO_TICKETS 4294967295 22set global thread_pool_high_prio_tickets=60; 23select @@global.thread_pool_high_prio_tickets; 24@@global.thread_pool_high_prio_tickets 2560 26set global thread_pool_high_prio_tickets=4294967295; 27select @@global.thread_pool_high_prio_tickets; 28@@global.thread_pool_high_prio_tickets 294294967295 30set session thread_pool_high_prio_tickets=1; 31select @@session.thread_pool_high_prio_tickets; 32@@session.thread_pool_high_prio_tickets 331 34set global thread_pool_high_prio_tickets=1.1; 35ERROR 42000: Incorrect argument type to variable 'thread_pool_high_prio_tickets' 36set global thread_pool_high_prio_tickets=1e1; 37ERROR 42000: Incorrect argument type to variable 'thread_pool_high_prio_tickets' 38set global thread_pool_high_prio_tickets="foo"; 39ERROR 42000: Incorrect argument type to variable 'thread_pool_high_prio_tickets' 40set global thread_pool_high_prio_tickets=-1; 41Warnings: 42Warning 1292 Truncated incorrect thread_pool_high_prio_tickets value: '-1' 43select @@global.thread_pool_high_prio_tickets; 44@@global.thread_pool_high_prio_tickets 450 46set global thread_pool_high_prio_tickets=10000000000; 47Warnings: 48Warning 1292 Truncated incorrect thread_pool_high_prio_tickets value: '10000000000' 49select @@global.thread_pool_high_prio_tickets; 50@@global.thread_pool_high_prio_tickets 514294967295 52set @@global.thread_pool_high_prio_tickets = @start_global_value; 53