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