MySQL 5.6 Reference Manual Including MySQL NDB Cluster 7.3-7.4 Reference Guide
The innodb_file_format
configuration option enables an InnoDB
file
format for
file-per-table
tablespaces.
Antelope
is the default
innodb_file_format
.
To preclude the use of features supported by the Barracuda file
that make your database inaccessible to the built-in
InnoDB
in MySQL 5.1 and prior releases, set
innodb_file_format
to
Antelope
. Alternatively, you can disable
innodb_file_per_table
to have new
tables created in the
system tablespace.
The system tablespace is stored in the original Antelope file
format.
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;
Although Oracle recommends using the Barracuda format for new tables where practical, in MySQL 5.6 the default file format is Antelope, for maximum compatibility with replication configurations containing earlier MySQL releases.