1SET @start_global_value = @@global.innodb_debug_force_scrubbing; 2# 3# exists as global only 4# 5select @@global.innodb_debug_force_scrubbing; 6@@global.innodb_debug_force_scrubbing 70 8select @@session.innodb_debug_force_scrubbing; 9ERROR HY000: Variable 'innodb_debug_force_scrubbing' is a GLOBAL variable 10show global variables like 'innodb_debug_force_scrubbing'; 11Variable_name Value 12innodb_debug_force_scrubbing OFF 13show session variables like 'innodb_debug_force_scrubbing'; 14Variable_name Value 15innodb_debug_force_scrubbing OFF 16select * from information_schema.global_variables 17where variable_name='innodb_debug_force_scrubbing'; 18VARIABLE_NAME VARIABLE_VALUE 19INNODB_DEBUG_FORCE_SCRUBBING OFF 20select * from information_schema.session_variables 21where variable_name='innodb_debug_force_scrubbing'; 22VARIABLE_NAME VARIABLE_VALUE 23INNODB_DEBUG_FORCE_SCRUBBING OFF 24# 25# show that it's writable 26# 27set global innodb_debug_force_scrubbing=ON; 28select @@global.innodb_debug_force_scrubbing; 29@@global.innodb_debug_force_scrubbing 301 31set global innodb_debug_force_scrubbing=OFF; 32select @@global.innodb_debug_force_scrubbing; 33@@global.innodb_debug_force_scrubbing 340 35set global innodb_debug_force_scrubbing=1; 36select @@global.innodb_debug_force_scrubbing; 37@@global.innodb_debug_force_scrubbing 381 39set session innodb_debug_force_scrubbing=1; 40ERROR HY000: Variable 'innodb_debug_force_scrubbing' is a GLOBAL variable and should be set with SET GLOBAL 41# 42# incorrect types 43# 44set global innodb_debug_force_scrubbing=1.1; 45ERROR 42000: Incorrect argument type to variable 'innodb_debug_force_scrubbing' 46set global innodb_debug_force_scrubbing=1e1; 47ERROR 42000: Incorrect argument type to variable 'innodb_debug_force_scrubbing' 48set global innodb_debug_force_scrubbing="foo"; 49ERROR 42000: Variable 'innodb_debug_force_scrubbing' can't be set to the value of 'foo' 50SET @@global.innodb_debug_force_scrubbing = @start_global_value; 51