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