Skip to content

Instantly share code, notes, and snippets.

@philotas

philotas/gist:6633035d0814512b5156633ca942b680

Forked from tonykwon/gist:8910261
Created January 4, 2023 23:52
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save philotas/6633035d0814512b5156633ca942b680 to your computer and use it in GitHub Desktop.
Save philotas/6633035d0814512b5156633ca942b680 to your computer and use it in GitHub Desktop.
Download ZIP
MySQL - Row size too large - BLOB prefix of 768 bytes is stored inline
Raw
gistfile1.sql
-- 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