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
  • He is Technical professional. He is a person who loves to share tricks and tips on the Internet. He Posts what he does!
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!

web
https://www.techrunnr.com
email
prabhin@techrunnr.com
call
8129739773
follow me

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.

vi /etc/my.cnf

 

innodb_log_file_size=512M
innodb_strict_mode=0

Restart MySQL or MariaDB restart

service mysql restart

or

service mariadb restart

 

© 2020, Techrunnr. All rights reserved.

#1
#2
#3
Questions Answered
Articles Written
Overall Points

Related posts

Leave a Reply