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 19Warnings: 20Warning 1287 'INFORMATION_SCHEMA.GLOBAL_VARIABLES' is deprecated and will be removed in a future release. Please use performance_schema.global_variables instead 21select * from information_schema.session_variables where variable_name='thread_pool_high_prio_tickets'; 22VARIABLE_NAME VARIABLE_VALUE 23THREAD_POOL_HIGH_PRIO_TICKETS 4294967295 24Warnings: 25Warning 1287 'INFORMATION_SCHEMA.SESSION_VARIABLES' is deprecated and will be removed in a future release. Please use performance_schema.session_variables instead 26set global thread_pool_high_prio_tickets=60; 27select @@global.thread_pool_high_prio_tickets; 28@@global.thread_pool_high_prio_tickets 2960 30set global thread_pool_high_prio_tickets=4294967295; 31select @@global.thread_pool_high_prio_tickets; 32@@global.thread_pool_high_prio_tickets 334294967295 34set session thread_pool_high_prio_tickets=1; 35select @@session.thread_pool_high_prio_tickets; 36@@session.thread_pool_high_prio_tickets 371 38set global thread_pool_high_prio_tickets=1.1; 39ERROR 42000: Incorrect argument type to variable 'thread_pool_high_prio_tickets' 40set global thread_pool_high_prio_tickets=1e1; 41ERROR 42000: Incorrect argument type to variable 'thread_pool_high_prio_tickets' 42set global thread_pool_high_prio_tickets="foo"; 43ERROR 42000: Incorrect argument type to variable 'thread_pool_high_prio_tickets' 44set global thread_pool_high_prio_tickets=-1; 45Warnings: 46Warning 1292 Truncated incorrect thread_pool_high_prio_tickets value: '-1' 47select @@global.thread_pool_high_prio_tickets; 48@@global.thread_pool_high_prio_tickets 490 50set global thread_pool_high_prio_tickets=10000000000; 51Warnings: 52Warning 1292 Truncated incorrect thread_pool_high_prio_tickets value: '10000000000' 53select @@global.thread_pool_high_prio_tickets; 54@@global.thread_pool_high_prio_tickets 554294967295 56set @@global.thread_pool_high_prio_tickets = @start_global_value; 57