1SET @start_value = @@GLOBAL.innodb_priority_purge; 2SELECT @@GLOBAL.innodb_priority_purge; 3@@GLOBAL.innodb_priority_purge 40 5SELECT @@SESSION.innodb_priority_purge; 6ERROR HY000: Variable 'innodb_priority_purge' is a GLOBAL variable 7SET GLOBAL innodb_priority_purge='OFF'; 8SELECT @@GLOBAL.innodb_priority_purge; 9@@GLOBAL.innodb_priority_purge 100 11SET GLOBAL innodb_priority_purge='ON'; 12SELECT @@GLOBAL.innodb_priority_purge; 13@@GLOBAL.innodb_priority_purge 141 15SET GLOBAL innodb_priority_purge=0; 16SELECT @@GLOBAL.innodb_priority_purge; 17@@GLOBAL.innodb_priority_purge 180 19SET GLOBAL innodb_priority_purge=1; 20SELECT @@GLOBAL.innodb_priority_purge; 21@@GLOBAL.innodb_priority_purge 221 23SET GLOBAL innodb_priority_purge=1.1; 24ERROR 42000: Incorrect argument type to variable 'innodb_priority_purge' 25SET GLOBAL innodb_priority_purge=1e1; 26ERROR 42000: Incorrect argument type to variable 'innodb_priority_purge' 27SET GLOBAL innodb_priority_purge=2; 28ERROR 42000: Variable 'innodb_priority_purge' can't be set to the value of '2' 29SET GLOBAL innodb_priority_purge='foo'; 30ERROR 42000: Variable 'innodb_priority_purge' can't be set to the value of 'foo' 31SET GLOBAL innodb_priority_purge = @start_value; 32