MySQL Forums
Forum List  »  InnoDB

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
3539
July 05, 2013 03:34AM


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.