SET @start_value = @@GLOBAL.innodb_priority_master; SELECT @@GLOBAL.innodb_priority_master; @@GLOBAL.innodb_priority_master 0 SELECT @@SESSION.innodb_priority_master; ERROR HY000: Variable 'innodb_priority_master' is a GLOBAL variable SET GLOBAL innodb_priority_master='OFF'; SELECT @@GLOBAL.innodb_priority_master; @@GLOBAL.innodb_priority_master 0 SET GLOBAL innodb_priority_master='ON'; SELECT @@GLOBAL.innodb_priority_master; @@GLOBAL.innodb_priority_master 1 SET GLOBAL innodb_priority_master=0; SELECT @@GLOBAL.innodb_priority_master; @@GLOBAL.innodb_priority_master 0 SET GLOBAL innodb_priority_master=1; SELECT @@GLOBAL.innodb_priority_master; @@GLOBAL.innodb_priority_master 1 SET GLOBAL innodb_priority_master=1.1; ERROR 42000: Incorrect argument type to variable 'innodb_priority_master' SET GLOBAL innodb_priority_master=1e1; ERROR 42000: Incorrect argument type to variable 'innodb_priority_master' SET GLOBAL innodb_priority_master=2; ERROR 42000: Variable 'innodb_priority_master' can't be set to the value of '2' SET GLOBAL innodb_priority_master='foo'; ERROR 42000: Variable 'innodb_priority_master' can't be set to the value of 'foo' SET GLOBAL innodb_priority_master = @start_value;