1SET @start_global_value = @@global.innodb_large_prefix; 2SELECT @start_global_value; 3@start_global_value 41 5Valid values are 'ON' and 'OFF' 6select @@global.innodb_large_prefix in (0, 1); 7@@global.innodb_large_prefix in (0, 1) 81 9select @@global.innodb_large_prefix; 10@@global.innodb_large_prefix 111 12select @@session.innodb_large_prefix; 13ERROR HY000: Variable 'innodb_large_prefix' is a GLOBAL variable 14show global variables like 'innodb_large_prefix'; 15Variable_name Value 16innodb_large_prefix ON 17show session variables like 'innodb_large_prefix'; 18Variable_name Value 19innodb_large_prefix ON 20select * from information_schema.global_variables where variable_name='innodb_large_prefix'; 21VARIABLE_NAME VARIABLE_VALUE 22INNODB_LARGE_PREFIX ON 23select * from information_schema.session_variables where variable_name='innodb_large_prefix'; 24VARIABLE_NAME VARIABLE_VALUE 25INNODB_LARGE_PREFIX ON 26set global innodb_large_prefix='OFF'; 27Warnings: 28Warning 131 Using innodb_large_prefix is deprecated and the parameter may be removed in future releases. See http://dev.mysql.com/doc/refman/5.7/en/innodb-file-format.html 29select @@global.innodb_large_prefix; 30@@global.innodb_large_prefix 310 32select * from information_schema.global_variables where variable_name='innodb_large_prefix'; 33VARIABLE_NAME VARIABLE_VALUE 34INNODB_LARGE_PREFIX OFF 35select * from information_schema.session_variables where variable_name='innodb_large_prefix'; 36VARIABLE_NAME VARIABLE_VALUE 37INNODB_LARGE_PREFIX OFF 38set @@global.innodb_large_prefix=1; 39Warnings: 40Warning 131 Using innodb_large_prefix is deprecated and the parameter may be removed in future releases. See http://dev.mysql.com/doc/refman/5.7/en/innodb-file-format.html 41select @@global.innodb_large_prefix; 42@@global.innodb_large_prefix 431 44select * from information_schema.global_variables where variable_name='innodb_large_prefix'; 45VARIABLE_NAME VARIABLE_VALUE 46INNODB_LARGE_PREFIX ON 47select * from information_schema.session_variables where variable_name='innodb_large_prefix'; 48VARIABLE_NAME VARIABLE_VALUE 49INNODB_LARGE_PREFIX ON 50set global innodb_large_prefix=0; 51Warnings: 52Warning 131 Using innodb_large_prefix is deprecated and the parameter may be removed in future releases. See http://dev.mysql.com/doc/refman/5.7/en/innodb-file-format.html 53select @@global.innodb_large_prefix; 54@@global.innodb_large_prefix 550 56select * from information_schema.global_variables where variable_name='innodb_large_prefix'; 57VARIABLE_NAME VARIABLE_VALUE 58INNODB_LARGE_PREFIX OFF 59select * from information_schema.session_variables where variable_name='innodb_large_prefix'; 60VARIABLE_NAME VARIABLE_VALUE 61INNODB_LARGE_PREFIX OFF 62set @@global.innodb_large_prefix='ON'; 63Warnings: 64Warning 131 Using innodb_large_prefix is deprecated and the parameter may be removed in future releases. See http://dev.mysql.com/doc/refman/5.7/en/innodb-file-format.html 65select @@global.innodb_large_prefix; 66@@global.innodb_large_prefix 671 68select * from information_schema.global_variables where variable_name='innodb_large_prefix'; 69VARIABLE_NAME VARIABLE_VALUE 70INNODB_LARGE_PREFIX ON 71select * from information_schema.session_variables where variable_name='innodb_large_prefix'; 72VARIABLE_NAME VARIABLE_VALUE 73INNODB_LARGE_PREFIX ON 74set session innodb_large_prefix='OFF'; 75ERROR HY000: Variable 'innodb_large_prefix' is a GLOBAL variable and should be set with SET GLOBAL 76set @@session.innodb_large_prefix='ON'; 77ERROR HY000: Variable 'innodb_large_prefix' is a GLOBAL variable and should be set with SET GLOBAL 78set global innodb_large_prefix=1.1; 79ERROR 42000: Incorrect argument type to variable 'innodb_large_prefix' 80set global innodb_large_prefix=1e1; 81ERROR 42000: Incorrect argument type to variable 'innodb_large_prefix' 82set global innodb_large_prefix=2; 83ERROR 42000: Variable 'innodb_large_prefix' can't be set to the value of '2' 84set global innodb_large_prefix=-3; 85ERROR 42000: Variable 'innodb_large_prefix' can't be set to the value of '-3' 86select @@global.innodb_large_prefix; 87@@global.innodb_large_prefix 881 89select * from information_schema.global_variables where variable_name='innodb_large_prefix'; 90VARIABLE_NAME VARIABLE_VALUE 91INNODB_LARGE_PREFIX ON 92select * from information_schema.session_variables where variable_name='innodb_large_prefix'; 93VARIABLE_NAME VARIABLE_VALUE 94INNODB_LARGE_PREFIX ON 95set global innodb_large_prefix='AUTO'; 96ERROR 42000: Variable 'innodb_large_prefix' can't be set to the value of 'AUTO' 97SET @@global.innodb_large_prefix = @start_global_value; 98Warnings: 99Warning 131 Using innodb_large_prefix is deprecated and the parameter may be removed in future releases. See http://dev.mysql.com/doc/refman/5.7/en/innodb-file-format.html 100SELECT @@global.innodb_large_prefix; 101@@global.innodb_large_prefix 1021 103