Forums

mysql error: [1118: Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126

Permalink
Hi All,

I a getting mysql error: [1118: Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126

Can anyone please help me on this?

Thanks
Anil
 
Myq replied on at Permalink Reply 1 Attachment
Myq
One way to get around this is to change the "row_format" for the problematic table to "dynamic". Even if the database is set to use dynamic by default for tables, ensure that the table throwing the error is set to dynamic.