Created
February 10, 2014 04:13
-
-
Save tonykwon/8910261 to your computer and use it in GitHub Desktop.
MySQL - Row size too large - BLOB prefix of 768 bytes is stored inline
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| -- Error Message: Row size too large (> 8126). Changing some columns to TEXT or BLOB or using ROW_FORMAT=DYNAMIC or ROW_FORMAT=COMPRESSED may help. In current row format, BLOB prefix of 768 bytes is stored inline. | |
| -- | |
| -- our table name that has this issue is XYZ | |
| -- | |
| SET GLOBAL innodb_file_format=Barracuda; | |
| SET GLOBAL innodb_file_per_table=ON; | |
| ALTER TABLE XYZ ROW_FORMAT=COMPRESSED; |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
I recently tried similar, 62 columns with Varchar 255 in InnoDB, I resolved it by using reasionable length for each column instead of the 255.
I used the largest value from all rows and 2x the size and compared if that exceeds the 255 so I would use TEXT, rether than varchar 255. the trick did it. :)
hope it will help someone, rather then altering default settings.