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