1SET @start_value = @@GLOBAL.innodb_sched_priority_purge;
2SELECT @@GLOBAL.innodb_sched_priority_purge;
3@@GLOBAL.innodb_sched_priority_purge
419
5SELECT @@SESSION.innodb_sched_priority_purge;
6ERROR HY000: Variable 'innodb_sched_priority_purge' is a GLOBAL variable
7SET GLOBAL innodb_sched_priority_purge=19;
8SELECT @@GLOBAL.innodb_sched_priority_purge;
9@@GLOBAL.innodb_sched_priority_purge
1019
11SET GLOBAL innodb_sched_priority_purge=5;
12SELECT @@GLOBAL.innodb_sched_priority_purge;
13@@GLOBAL.innodb_sched_priority_purge
145
15SET GLOBAL innodb_sched_priority_purge=0;
16SELECT @@GLOBAL.innodb_sched_priority_purge;
17@@GLOBAL.innodb_sched_priority_purge
180
19SET GLOBAL innodb_sched_priority_purge=-1;
20Warnings:
21Warning	1292	Truncated incorrect innodb_sched_priority_purge value: '-1'
22SELECT @@GLOBAL.innodb_sched_priority_purge;
23@@GLOBAL.innodb_sched_priority_purge
240
25SET GLOBAL innodb_sched_priority_purge=1.1;
26ERROR 42000: Incorrect argument type to variable 'innodb_sched_priority_purge'
27SET GLOBAL innodb_sched_priority_purge=1e1;
28ERROR 42000: Incorrect argument type to variable 'innodb_sched_priority_purge'
29SET GLOBAL innodb_sched_priority_purge='foo';
30ERROR 42000: Incorrect argument type to variable 'innodb_sched_priority_purge'
31# restart
32