1SET @start_global_value = @@global.innodb_file_format_max; 2SELECT @start_global_value; 3@start_global_value 4Antelope 5Valid values are 'Antelope' and 'Barracuda' 6SELECT @@global.innodb_file_format_max in ('Antelope', 'Barracuda'); 7@@global.innodb_file_format_max in ('Antelope', 'Barracuda') 81 9SELECT @@global.innodb_file_format_max; 10@@global.innodb_file_format_max 11Antelope 12SELECT @@session.innodb_file_format_max; 13ERROR HY000: Variable 'innodb_file_format_max' is a GLOBAL variable 14SHOW global variables LIKE 'innodb_file_format_max'; 15Variable_name Value 16innodb_file_format_max Antelope 17SHOW session variables LIKE 'innodb_file_format_max'; 18Variable_name Value 19innodb_file_format_max Antelope 20SELECT * FROM information_schema.global_variables 21WHERE variable_name='innodb_file_format_max'; 22VARIABLE_NAME VARIABLE_VALUE 23INNODB_FILE_FORMAT_MAX Antelope 24SELECT * FROM information_schema.session_variables 25WHERE variable_name='innodb_file_format_max'; 26VARIABLE_NAME VARIABLE_VALUE 27INNODB_FILE_FORMAT_MAX Antelope 28SET global innodb_file_format_max='Antelope'; 29SELECT @@global.innodb_file_format_max; 30@@global.innodb_file_format_max 31Antelope 32SELECT * FROM information_schema.global_variables 33WHERE variable_name='innodb_file_format_max'; 34VARIABLE_NAME VARIABLE_VALUE 35INNODB_FILE_FORMAT_MAX Antelope 36SELECT * FROM information_schema.session_variables 37WHERE variable_name='innodb_file_format_max'; 38VARIABLE_NAME VARIABLE_VALUE 39INNODB_FILE_FORMAT_MAX Antelope 40SET @@global.innodb_file_format_max='Barracuda'; 41SELECT @@global.innodb_file_format_max; 42@@global.innodb_file_format_max 43Barracuda 44SELECT * FROM information_schema.global_variables 45WHERE variable_name='innodb_file_format_max'; 46VARIABLE_NAME VARIABLE_VALUE 47INNODB_FILE_FORMAT_MAX Barracuda 48SELECT * FROM information_schema.session_variables 49WHERE variable_name='innodb_file_format_max'; 50VARIABLE_NAME VARIABLE_VALUE 51INNODB_FILE_FORMAT_MAX Barracuda 52SET session innodb_file_format_max='Salmon'; 53ERROR HY000: Variable 'innodb_file_format_max' is a GLOBAL variable and should be set with SET GLOBAL 54SET @@session.innodb_file_format_max='Salmon'; 55ERROR HY000: Variable 'innodb_file_format_max' is a GLOBAL variable and should be set with SET GLOBAL 56SET global innodb_file_format_max=1.1; 57ERROR 42000: Incorrect argument type to variable 'innodb_file_format_max' 58SET global innodb_file_format_max=1e1; 59ERROR 42000: Incorrect argument type to variable 'innodb_file_format_max' 60SET global innodb_file_format_max='Salmon'; 61ERROR 42000: Variable 'innodb_file_format_max' can't be set to the value of 'Salmon' 62SET @@global.innodb_file_format_max = @start_global_value; 63SELECT @@global.innodb_file_format_max; 64@@global.innodb_file_format_max 65Antelope 66