Search code examples
mysqlsqldatabase-performance

Difference between Barracuda and Antelope INNODB format

What are differences between INNODB file formats Barracuda and Antelope, except that Barracuda supports table compression? Barracuda format is newer, but in MySQL >= 5.5.7 the default file format is Antelope (according to MySQL website innodb_file_format option)

Is there any speed difference or recommendation which format is better and why is now default format Antelope which is older?

Solution

  • Antelope is older.

    Barracuda allows you to go beyond 767 bytes for an index column.

    I have not heard of any reason to switch wholesale.