14.10.1 Enabling File Formats
Barracuda is the default
innodb_file_format setting. In earlier releases, the default file format was
You can set the value of
innodb_file_format on the command line when you start mysqld, or in the option file (
my.cnf on Unix,
my.ini on Windows). You can also change it dynamically with a
SET GLOBAL statement.
SET GLOBAL innodb_file_format=Barracuda;
InnoDBfile format settings do not apply to tables stored in general tablespaces. General tablespaces provide support for all row formats and associated features. For more information, see Section 188.8.131.52, “General Tablespaces”.