MySQL row size too large (>8126)

This is something to do with bad table design, where you are using multiply columns with Text values, the best solution would be redesign tables, but from time to time you need to patch it at-hoc without redesigning application that use that database.

Solution that usually works:

# to my.conf mysql configuration file add/replace:
innodb_file_per_table
innodb_file_format = Barracuda

# and alter table that throw error with
ALTER TABLE your_table ENGINE=InnoDB ROW_FORMAT=DYNAMIC

 

Leave a Reply

Your email address will not be published. Required fields are marked *

*