1SET @saved_val = @@global.innodb_corrupt_table_action; 2SELECT @@global.innodb_corrupt_table_action IN ('assert', 'warn', 'salvage'); 3@@global.innodb_corrupt_table_action IN ('assert', 'warn', 'salvage') 41 5SELECT @@session.innodb_corrupt_table_action; 6ERROR HY000: Variable 'innodb_corrupt_table_action' is a GLOBAL variable 7SET GLOBAL innodb_corrupt_table_action='assert'; 8SELECT @@GLOBAL.innodb_corrupt_table_action; 9@@GLOBAL.innodb_corrupt_table_action 10assert 11SELECT * FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME='innodb_corrupt_table_action'; 12VARIABLE_NAME VARIABLE_VALUE 13INNODB_CORRUPT_TABLE_ACTION assert 14Warnings: 15Warning 1287 'INFORMATION_SCHEMA.GLOBAL_VARIABLES' is deprecated and will be removed in a future release. Please use performance_schema.global_variables instead 16SELECT * FROM INFORMATION_SCHEMA.SESSION_VARIABLES WHERE VARIABLE_NAME='innodb_corrupt_table_action'; 17VARIABLE_NAME VARIABLE_VALUE 18INNODB_CORRUPT_TABLE_ACTION assert 19Warnings: 20Warning 1287 'INFORMATION_SCHEMA.SESSION_VARIABLES' is deprecated and will be removed in a future release. Please use performance_schema.session_variables instead 21SET GLOBAL innodb_corrupt_table_action='warn'; 22SELECT @@GLOBAL.innodb_corrupt_table_action; 23@@GLOBAL.innodb_corrupt_table_action 24warn 25SELECT * FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME='innodb_corrupt_table_action'; 26VARIABLE_NAME VARIABLE_VALUE 27INNODB_CORRUPT_TABLE_ACTION warn 28Warnings: 29Warning 1287 'INFORMATION_SCHEMA.GLOBAL_VARIABLES' is deprecated and will be removed in a future release. Please use performance_schema.global_variables instead 30SELECT * FROM INFORMATION_SCHEMA.SESSION_VARIABLES WHERE VARIABLE_NAME='innodb_corrupt_table_action'; 31VARIABLE_NAME VARIABLE_VALUE 32INNODB_CORRUPT_TABLE_ACTION warn 33Warnings: 34Warning 1287 'INFORMATION_SCHEMA.SESSION_VARIABLES' is deprecated and will be removed in a future release. Please use performance_schema.session_variables instead 35SET GLOBAL innodb_corrupt_table_action='salvage'; 36SELECT @@GLOBAL.innodb_corrupt_table_action; 37@@GLOBAL.innodb_corrupt_table_action 38salvage 39SELECT * FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME='innodb_corrupt_table_action'; 40VARIABLE_NAME VARIABLE_VALUE 41INNODB_CORRUPT_TABLE_ACTION salvage 42Warnings: 43Warning 1287 'INFORMATION_SCHEMA.GLOBAL_VARIABLES' is deprecated and will be removed in a future release. Please use performance_schema.global_variables instead 44SELECT * FROM INFORMATION_SCHEMA.SESSION_VARIABLES WHERE VARIABLE_NAME='innodb_corrupt_table_action'; 45VARIABLE_NAME VARIABLE_VALUE 46INNODB_CORRUPT_TABLE_ACTION salvage 47Warnings: 48Warning 1287 'INFORMATION_SCHEMA.SESSION_VARIABLES' is deprecated and will be removed in a future release. Please use performance_schema.session_variables instead 49SET SESSION innodb_corrupt_table_action='warn'; 50ERROR HY000: Variable 'innodb_corrupt_table_action' is a GLOBAL variable and should be set with SET GLOBAL 51SET @@session.innodb_corrupt_table_action='salvage'; 52ERROR HY000: Variable 'innodb_corrupt_table_action' is a GLOBAL variable and should be set with SET GLOBAL 53SET global innodb_corrupt_table_action=1.1; 54ERROR 42000: Incorrect argument type to variable 'innodb_corrupt_table_action' 55SET global innodb_corrupt_table_action=1e1; 56ERROR 42000: Incorrect argument type to variable 'innodb_corrupt_table_action' 57SET global innodb_corrupt_table_action='foo'; 58ERROR 42000: Variable 'innodb_corrupt_table_action' can't be set to the value of 'foo' 59SET global innodb_corrupt_table_action=-2; 60ERROR 42000: Variable 'innodb_corrupt_table_action' can't be set to the value of '-2' 61SET @@global.innodb_corrupt_table_action = @saved_val; 62