Skip navigation links

MySQL Forums :: InnoDB :: Row size limit for Barracuda file format


Advanced Search

Row size limit for Barracuda file format
Posted by: Roman Syroeshko ()
Date: July 05, 2013 03:34AM

Hi guys,
It seems that Barracuda file format has the same row size limit (65535) as Antelope has. MySQL (with UTF-8 database encoding) doesn't allow to create table with the followed statement:

CREATE TABLE a (a1 varchar(21845)) ROW_FORMAT=DYNAMIC;

and displays the followed message:

"Error Code: 1118. Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs"

There are various posts (e.g., http://www.mysqlperformanceblog.com/2011/04/07/innodb-row-size-limitation/) in the Internet claiming that Barracuda helps to get rid of this limit, but it doesn't work for me and I have no ideas why.

Is it a bug or am I missing something?

MySQL 5.6.10 CE.



Edited 1 time(s). Last edit at 07/05/2013 03:36AM by Roman Syroeshko.

Options: ReplyQuote


Subject Views Written By Posted
Row size limit for Barracuda file format 876 Roman Syroeshko 07/05/2013 03:34AM
Re: Row size limit for Barracuda file format 297 Rick James 07/06/2013 11:25AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.