MySQL Forums
Forum List  »  InnoDB

Maximum row size
Posted by: Andy Thomas
Date: August 31, 2018 05:08AM

I have always understood that the maximum length of a row (record) in a MySQL 5.6 database using the InnoDB engine is 8126 bytes. But while troubleshooting an existing database which has recently started coming up with the error:

Exception caught: (1118, 'Row size too large (> 8126).

I noted some rows are as much as 3.4 Mbytes in length when dumped to a file! Most of the columns are of type longtext so if there is a 8126 byte row limit, how did the user manage to get so much data into the table?

Incidentally, 'setting innodb_log_file_size = 512M' and 'innodb_strict_mode = 0' has not resolved this issue.

Andy

Options: ReplyQuote


Subject
Views
Written By
Posted
Maximum row size
1775
August 31, 2018 05:08AM
613
August 31, 2018 11:32AM
823
September 01, 2018 08:43AM
640
September 01, 2018 10:51AM
710
September 01, 2018 11:10AM
764
September 01, 2018 11:34AM
585
September 01, 2018 11:54AM
713
September 02, 2018 12:36AM
749
September 02, 2018 01:39PM


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.