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