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., 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 1505 Roman Syroeshko 07/05/2013 03:34AM
Re: Row size limit for Barracuda file format 466 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.