1SET @start_global_value = @@global.innodb_disable_sort_file_cache; 2SELECT @start_global_value; 3@start_global_value 40 5Valid values are 'ON' and 'OFF' 6select @@global.innodb_disable_sort_file_cache in (0, 1); 7@@global.innodb_disable_sort_file_cache in (0, 1) 81 9select @@global.innodb_disable_sort_file_cache; 10@@global.innodb_disable_sort_file_cache 110 12select @@session.innodb_disable_sort_file_cache; 13ERROR HY000: Variable 'innodb_disable_sort_file_cache' is a GLOBAL variable 14show global variables like 'innodb_disable_sort_file_cache'; 15Variable_name Value 16innodb_disable_sort_file_cache OFF 17show session variables like 'innodb_disable_sort_file_cache'; 18Variable_name Value 19innodb_disable_sort_file_cache OFF 20select * from information_schema.global_variables where variable_name='innodb_disable_sort_file_cache'; 21VARIABLE_NAME VARIABLE_VALUE 22INNODB_DISABLE_SORT_FILE_CACHE OFF 23select * from information_schema.session_variables where variable_name='innodb_disable_sort_file_cache'; 24VARIABLE_NAME VARIABLE_VALUE 25INNODB_DISABLE_SORT_FILE_CACHE OFF 26set global innodb_disable_sort_file_cache='OFF'; 27select @@global.innodb_disable_sort_file_cache; 28@@global.innodb_disable_sort_file_cache 290 30select * from information_schema.global_variables where variable_name='innodb_disable_sort_file_cache'; 31VARIABLE_NAME VARIABLE_VALUE 32INNODB_DISABLE_SORT_FILE_CACHE OFF 33select * from information_schema.session_variables where variable_name='innodb_disable_sort_file_cache'; 34VARIABLE_NAME VARIABLE_VALUE 35INNODB_DISABLE_SORT_FILE_CACHE OFF 36set @@global.innodb_disable_sort_file_cache=1; 37select @@global.innodb_disable_sort_file_cache; 38@@global.innodb_disable_sort_file_cache 391 40select * from information_schema.global_variables where variable_name='innodb_disable_sort_file_cache'; 41VARIABLE_NAME VARIABLE_VALUE 42INNODB_DISABLE_SORT_FILE_CACHE ON 43select * from information_schema.session_variables where variable_name='innodb_disable_sort_file_cache'; 44VARIABLE_NAME VARIABLE_VALUE 45INNODB_DISABLE_SORT_FILE_CACHE ON 46set global innodb_disable_sort_file_cache=0; 47select @@global.innodb_disable_sort_file_cache; 48@@global.innodb_disable_sort_file_cache 490 50select * from information_schema.global_variables where variable_name='innodb_disable_sort_file_cache'; 51VARIABLE_NAME VARIABLE_VALUE 52INNODB_DISABLE_SORT_FILE_CACHE OFF 53select * from information_schema.session_variables where variable_name='innodb_disable_sort_file_cache'; 54VARIABLE_NAME VARIABLE_VALUE 55INNODB_DISABLE_SORT_FILE_CACHE OFF 56set @@global.innodb_disable_sort_file_cache='ON'; 57select @@global.innodb_disable_sort_file_cache; 58@@global.innodb_disable_sort_file_cache 591 60select * from information_schema.global_variables where variable_name='innodb_disable_sort_file_cache'; 61VARIABLE_NAME VARIABLE_VALUE 62INNODB_DISABLE_SORT_FILE_CACHE ON 63select * from information_schema.session_variables where variable_name='innodb_disable_sort_file_cache'; 64VARIABLE_NAME VARIABLE_VALUE 65INNODB_DISABLE_SORT_FILE_CACHE ON 66set session innodb_disable_sort_file_cache='OFF'; 67ERROR HY000: Variable 'innodb_disable_sort_file_cache' is a GLOBAL variable and should be set with SET GLOBAL 68set @@session.innodb_disable_sort_file_cache='ON'; 69ERROR HY000: Variable 'innodb_disable_sort_file_cache' is a GLOBAL variable and should be set with SET GLOBAL 70set global innodb_disable_sort_file_cache=1.1; 71ERROR 42000: Incorrect argument type to variable 'innodb_disable_sort_file_cache' 72set global innodb_disable_sort_file_cache=1e1; 73ERROR 42000: Incorrect argument type to variable 'innodb_disable_sort_file_cache' 74set global innodb_disable_sort_file_cache=2; 75ERROR 42000: Variable 'innodb_disable_sort_file_cache' can't be set to the value of '2' 76set global innodb_disable_sort_file_cache=-3; 77ERROR 42000: Variable 'innodb_disable_sort_file_cache' can't be set to the value of '-3' 78select @@global.innodb_disable_sort_file_cache; 79@@global.innodb_disable_sort_file_cache 801 81select * from information_schema.global_variables where variable_name='innodb_disable_sort_file_cache'; 82VARIABLE_NAME VARIABLE_VALUE 83INNODB_DISABLE_SORT_FILE_CACHE ON 84select * from information_schema.session_variables where variable_name='innodb_disable_sort_file_cache'; 85VARIABLE_NAME VARIABLE_VALUE 86INNODB_DISABLE_SORT_FILE_CACHE ON 87set global innodb_disable_sort_file_cache='AUTO'; 88ERROR 42000: Variable 'innodb_disable_sort_file_cache' can't be set to the value of 'AUTO' 89SET @@global.innodb_disable_sort_file_cache = @start_global_value; 90SELECT @@global.innodb_disable_sort_file_cache; 91@@global.innodb_disable_sort_file_cache 920 93