1SET @start_global_value = @@global.deadlock_timeout_long; 2select @@global.deadlock_timeout_long; 3@@global.deadlock_timeout_long 450000000 5select @@session.deadlock_timeout_long; 6@@session.deadlock_timeout_long 750000000 8show global variables like 'deadlock_timeout_long'; 9Variable_name Value 10deadlock_timeout_long 50000000 11show session variables like 'deadlock_timeout_long'; 12Variable_name Value 13deadlock_timeout_long 50000000 14select * from information_schema.global_variables where variable_name='deadlock_timeout_long'; 15VARIABLE_NAME VARIABLE_VALUE 16DEADLOCK_TIMEOUT_LONG 50000000 17select * from information_schema.session_variables where variable_name='deadlock_timeout_long'; 18VARIABLE_NAME VARIABLE_VALUE 19DEADLOCK_TIMEOUT_LONG 50000000 20set global deadlock_timeout_long=10; 21select @@global.deadlock_timeout_long; 22@@global.deadlock_timeout_long 2310 24set session deadlock_timeout_long=10; 25select @@session.deadlock_timeout_long; 26@@session.deadlock_timeout_long 2710 28set global deadlock_timeout_long=1.1; 29ERROR 42000: Incorrect argument type to variable 'deadlock_timeout_long' 30set session deadlock_timeout_long=1e1; 31ERROR 42000: Incorrect argument type to variable 'deadlock_timeout_long' 32set global deadlock_timeout_long="foo"; 33ERROR 42000: Incorrect argument type to variable 'deadlock_timeout_long' 34set global deadlock_timeout_long=0; 35select @@global.deadlock_timeout_long; 36@@global.deadlock_timeout_long 370 38set session deadlock_timeout_long=cast(-1 as unsigned int); 39Warnings: 40Note 1105 Cast to unsigned converted negative integer to it's positive complement 41Warning 1292 Truncated incorrect deadlock_timeout_long value: '18446744073709551615' 42select @@session.deadlock_timeout_long; 43@@session.deadlock_timeout_long 444294967295 45SET @@global.deadlock_timeout_long = @start_global_value; 46