1SET @start_global_value = @@global.innodb_print_all_deadlocks; 2SELECT @start_global_value; 3@start_global_value 40 5Valid values are 'ON' and 'OFF' 6SELECT @@global.innodb_print_all_deadlocks in (0, 1); 7@@global.innodb_print_all_deadlocks in (0, 1) 81 9SELECT @@global.innodb_print_all_deadlocks; 10@@global.innodb_print_all_deadlocks 110 12SELECT @@session.innodb_print_all_deadlocks; 13ERROR HY000: Variable 'innodb_print_all_deadlocks' is a GLOBAL variable 14SHOW global variables LIKE 'innodb_print_all_deadlocks'; 15Variable_name Value 16innodb_print_all_deadlocks OFF 17SHOW session variables LIKE 'innodb_print_all_deadlocks'; 18Variable_name Value 19innodb_print_all_deadlocks OFF 20SELECT * FROM information_schema.global_variables 21WHERE variable_name='innodb_print_all_deadlocks'; 22VARIABLE_NAME VARIABLE_VALUE 23INNODB_PRINT_ALL_DEADLOCKS OFF 24SELECT * FROM information_schema.session_variables 25WHERE variable_name='innodb_print_all_deadlocks'; 26VARIABLE_NAME VARIABLE_VALUE 27INNODB_PRINT_ALL_DEADLOCKS OFF 28SET global innodb_print_all_deadlocks='OFF'; 29SELECT @@global.innodb_print_all_deadlocks; 30@@global.innodb_print_all_deadlocks 310 32SELECT * FROM information_schema.global_variables 33WHERE variable_name='innodb_print_all_deadlocks'; 34VARIABLE_NAME VARIABLE_VALUE 35INNODB_PRINT_ALL_DEADLOCKS OFF 36SELECT * FROM information_schema.session_variables 37WHERE variable_name='innodb_print_all_deadlocks'; 38VARIABLE_NAME VARIABLE_VALUE 39INNODB_PRINT_ALL_DEADLOCKS OFF 40SET @@global.innodb_print_all_deadlocks=1; 41SELECT @@global.innodb_print_all_deadlocks; 42@@global.innodb_print_all_deadlocks 431 44SELECT * FROM information_schema.global_variables 45WHERE variable_name='innodb_print_all_deadlocks'; 46VARIABLE_NAME VARIABLE_VALUE 47INNODB_PRINT_ALL_DEADLOCKS ON 48SELECT * FROM information_schema.session_variables 49WHERE variable_name='innodb_print_all_deadlocks'; 50VARIABLE_NAME VARIABLE_VALUE 51INNODB_PRINT_ALL_DEADLOCKS ON 52SET global innodb_print_all_deadlocks=0; 53SELECT @@global.innodb_print_all_deadlocks; 54@@global.innodb_print_all_deadlocks 550 56SELECT * FROM information_schema.global_variables 57WHERE variable_name='innodb_print_all_deadlocks'; 58VARIABLE_NAME VARIABLE_VALUE 59INNODB_PRINT_ALL_DEADLOCKS OFF 60SELECT * FROM information_schema.session_variables 61WHERE variable_name='innodb_print_all_deadlocks'; 62VARIABLE_NAME VARIABLE_VALUE 63INNODB_PRINT_ALL_DEADLOCKS OFF 64SET @@global.innodb_print_all_deadlocks='ON'; 65SELECT @@global.innodb_print_all_deadlocks; 66@@global.innodb_print_all_deadlocks 671 68SELECT * FROM information_schema.global_variables 69WHERE variable_name='innodb_print_all_deadlocks'; 70VARIABLE_NAME VARIABLE_VALUE 71INNODB_PRINT_ALL_DEADLOCKS ON 72SELECT * FROM information_schema.session_variables 73WHERE variable_name='innodb_print_all_deadlocks'; 74VARIABLE_NAME VARIABLE_VALUE 75INNODB_PRINT_ALL_DEADLOCKS ON 76SET session innodb_print_all_deadlocks='OFF'; 77ERROR HY000: Variable 'innodb_print_all_deadlocks' is a GLOBAL variable and should be set with SET GLOBAL 78SET @@session.innodb_print_all_deadlocks='ON'; 79ERROR HY000: Variable 'innodb_print_all_deadlocks' is a GLOBAL variable and should be set with SET GLOBAL 80SET global innodb_print_all_deadlocks=1.1; 81ERROR 42000: Incorrect argument type to variable 'innodb_print_all_deadlocks' 82SET global innodb_print_all_deadlocks=1e1; 83ERROR 42000: Incorrect argument type to variable 'innodb_print_all_deadlocks' 84SET global innodb_print_all_deadlocks=2; 85ERROR 42000: Variable 'innodb_print_all_deadlocks' can't be set to the value of '2' 86SET global innodb_print_all_deadlocks=-3; 87ERROR 42000: Variable 'innodb_print_all_deadlocks' can't be set to the value of '-3' 88SELECT @@global.innodb_print_all_deadlocks; 89@@global.innodb_print_all_deadlocks 901 91SELECT * FROM information_schema.global_variables 92WHERE variable_name='innodb_print_all_deadlocks'; 93VARIABLE_NAME VARIABLE_VALUE 94INNODB_PRINT_ALL_DEADLOCKS ON 95SELECT * FROM information_schema.session_variables 96WHERE variable_name='innodb_print_all_deadlocks'; 97VARIABLE_NAME VARIABLE_VALUE 98INNODB_PRINT_ALL_DEADLOCKS ON 99SET global innodb_print_all_deadlocks='AUTO'; 100ERROR 42000: Variable 'innodb_print_all_deadlocks' can't be set to the value of 'AUTO' 101SET @@global.innodb_print_all_deadlocks = @start_global_value; 102SELECT @@global.innodb_print_all_deadlocks; 103@@global.innodb_print_all_deadlocks 1040 105