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