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

We need your support!!
Other Amount:
techrunnr.com:
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!

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

 

We need your support!!
Other Amount:
techrunnr.com:
#1
#2
#3
Questions Answered
Articles Written
Overall Points

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!!

You may also like...

Leave a Reply

Please wait...

Subscribe to our newsletter

Want to be notified when our article is published? Enter your email address and name below to be the first to know.
Exit mobile version