1SET @start_global_value = @@global.innodb_limit_optimistic_insert_debug; 2SELECT @start_global_value; 3@start_global_value 40 5select @@global.innodb_limit_optimistic_insert_debug; 6@@global.innodb_limit_optimistic_insert_debug 70 8select @@session.innodb_limit_optimistic_insert_debug; 9ERROR HY000: Variable 'innodb_limit_optimistic_insert_debug' is a GLOBAL variable 10show global variables like 'innodb_limit_optimistic_insert_debug'; 11Variable_name Value 12innodb_limit_optimistic_insert_debug 0 13show session variables like 'innodb_limit_optimistic_insert_debug'; 14Variable_name Value 15innodb_limit_optimistic_insert_debug 0 16select * from information_schema.global_variables where variable_name='innodb_limit_optimistic_insert_debug'; 17VARIABLE_NAME VARIABLE_VALUE 18INNODB_LIMIT_OPTIMISTIC_INSERT_DEBUG 0 19select * from information_schema.session_variables where variable_name='innodb_limit_optimistic_insert_debug'; 20VARIABLE_NAME VARIABLE_VALUE 21INNODB_LIMIT_OPTIMISTIC_INSERT_DEBUG 0 22set global innodb_limit_optimistic_insert_debug=1; 23select @@global.innodb_limit_optimistic_insert_debug; 24@@global.innodb_limit_optimistic_insert_debug 251 26select * from information_schema.global_variables where variable_name='innodb_limit_optimistic_insert_debug'; 27VARIABLE_NAME VARIABLE_VALUE 28INNODB_LIMIT_OPTIMISTIC_INSERT_DEBUG 1 29select * from information_schema.session_variables where variable_name='innodb_limit_optimistic_insert_debug'; 30VARIABLE_NAME VARIABLE_VALUE 31INNODB_LIMIT_OPTIMISTIC_INSERT_DEBUG 1 32set @@global.innodb_limit_optimistic_insert_debug=0; 33select @@global.innodb_limit_optimistic_insert_debug; 34@@global.innodb_limit_optimistic_insert_debug 350 36select * from information_schema.global_variables where variable_name='innodb_limit_optimistic_insert_debug'; 37VARIABLE_NAME VARIABLE_VALUE 38INNODB_LIMIT_OPTIMISTIC_INSERT_DEBUG 0 39select * from information_schema.session_variables where variable_name='innodb_limit_optimistic_insert_debug'; 40VARIABLE_NAME VARIABLE_VALUE 41INNODB_LIMIT_OPTIMISTIC_INSERT_DEBUG 0 42set session innodb_limit_optimistic_insert_debug='some'; 43ERROR HY000: Variable 'innodb_limit_optimistic_insert_debug' is a GLOBAL variable and should be set with SET GLOBAL 44set @@session.innodb_limit_optimistic_insert_debug='some'; 45ERROR HY000: Variable 'innodb_limit_optimistic_insert_debug' is a GLOBAL variable and should be set with SET GLOBAL 46set global innodb_limit_optimistic_insert_debug=1.1; 47ERROR 42000: Incorrect argument type to variable 'innodb_limit_optimistic_insert_debug' 48set global innodb_limit_optimistic_insert_debug='foo'; 49ERROR 42000: Incorrect argument type to variable 'innodb_limit_optimistic_insert_debug' 50set global innodb_limit_optimistic_insert_debug=-2; 51Warnings: 52Warning 1292 Truncated incorrect innodb_limit_optimistic_insert_d value: '-2' 53set global innodb_limit_optimistic_insert_debug=1e1; 54ERROR 42000: Incorrect argument type to variable 'innodb_limit_optimistic_insert_debug' 55SET @@global.innodb_limit_optimistic_insert_debug = @start_global_value; 56SELECT @@global.innodb_limit_optimistic_insert_debug; 57@@global.innodb_limit_optimistic_insert_debug 580 59