changing innodb file format to barracuda?


Staff member
Apr 11, 2011
Hello :)

Changing the default format in your /etc/my.cnf file should only apply to new tables, and does not erase databases or tables. The configuration option is documented at:

MySQL :: InnoDB 1.1 for MySQL 5.5 User's Guide :: 8.1 The Barracuda File Format

It's important to review the documentation because there are some instances (e.g. MySQL 5.1) where using this file format could make your databases inaccessible. Also, if you plan to switch over to MariaDB, you may want to continue using the Antelope file format for InnoDB if you use replication functionality:

XtraDB/InnoDB File Format

Thank you.