Skip to content

Instantly share code, notes, and snippets.

@koyoyo

koyoyo/MYSQL Error text long size

Last active August 29, 2015 13:57
Show Gist options
  • Save koyoyo/9635369 to your computer and use it in GitHub Desktop.
Save koyoyo/9635369 to your computer and use it in GitHub Desktop.
Download ZIP
MYSQL Error text long size because of have many Text field on table.
Raw
MYSQL Error text long size
DatabaseError: (1118, '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.')
SET GLOBAL innodb_file_format=Barracuda;
SET GLOBAL innodb_file_per_table=ON;
ALTER TABLE nombre_tabla
ROW_FORMAT=COMPRESSED
KEY_BLOCK_SIZE=8;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment