1SET @start_global_value = @@GLOBAL.thread_pool_high_prio_mode;
2SET @@GLOBAL.thread_pool_high_prio_mode=DEFAULT;
3SELECT @@GLOBAL.thread_pool_high_prio_mode;
4@@GLOBAL.thread_pool_high_prio_mode
5transactions
6SET @@SESSION.thread_pool_high_prio_mode=DEFAULT;
7SELECT @@SESSION.thread_pool_high_prio_mode;
8@@SESSION.thread_pool_high_prio_mode
9transactions
10SHOW GLOBAL VARIABLES LIKE 'thread_pool_high_prio_mode';
11Variable_name	Value
12thread_pool_high_prio_mode	transactions
13SHOW SESSION VARIABLES LIKE 'thread_pool_high_prio_mode';
14Variable_name	Value
15thread_pool_high_prio_mode	transactions
16SET @@thread_pool_high_prio_mode='transactions';
17SELECT @@thread_pool_high_prio_mode;
18@@thread_pool_high_prio_mode
19transactions
20SET @@thread_pool_high_prio_mode='statements';
21SELECT @@thread_pool_high_prio_mode;
22@@thread_pool_high_prio_mode
23statements
24SET @@thread_pool_high_prio_mode='none';
25SELECT @@thread_pool_high_prio_mode;
26@@thread_pool_high_prio_mode
27none
28SET @@thread_pool_high_prio_mode='foo';
29ERROR 42000: Variable 'thread_pool_high_prio_mode' can't be set to the value of 'foo'
30SET @@thread_pool_high_prio_mode=1.1;
31ERROR 42000: Incorrect argument type to variable 'thread_pool_high_prio_mode'
32SET @@thread_pool_high_prio_mode=1e1;
33ERROR 42000: Incorrect argument type to variable 'thread_pool_high_prio_mode'
34SET @@GLOBAL.thread_pool_high_prio_mode = @start_global_value;
35