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