Row size too large (> 8126). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 bytes is stored inline1 min read
Prabhin Prabharkaran
Administrator
DevOps Engineer
He is a Technical professional. He is a person who loves to share tricks and tips on the Internet. He Posts what he does!
Hi All, this document deals with how to fix ERROR 1118 (42000): Row size too large (> 8126). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 bytes is stored inline.
These messages indicate that the table’s definition allows rows that the table’s InnoDB row format can’t actually store.
The Below configuration fixed my issue.
Restart MySQL or MariaDB restart
or
#1
#2
#3
Questions Answered
Articles Written
Overall Points
