MySQL Row size limit
First thanks for the answer.
I have a table with more than 60 text fields, some of which may be filled with hundreds of characters. Then after you fill in the part of the application process, the following error occurs when the field is filled in.
#1118-row size too large (> 8126). Changing some columns to TEXT or BLOB or using row_format=dynamic or row_format=compressed may help. In the current row format, the BLOB prefix of 768 bytes is stored inline.
I am relatively small white, there is a not quite understand, it said the row size is 8126 bytes, but we often say the maximum length of varchar is not 65535? Why is the maximum size of row smaller than this?
I am now the engine of InnoDB, do not know if change into MyISAM can solve this problem?
I hope you don't hesitate to enlighten me ~
------to solve the idea----------------------
table field type Longtext try it
------to solve the idea----------------------
The 3 floor is a good brother. I tested the 5.0 version, the import data will not be reported to row size too large, but 5.5.39 and 5.6.20 Community Edition All reported that the mistake, these two versions changed to MyISAM is good.
------to solve the idea----------------------
Reference:
Quote: Reference:
#1118-The row size is too large (>8126). It may be helpful to change the type of some columns to text or blob, or to use row_format= dynamic or row_format=compressed. In the current row format, the 768-byte blob prefix is stored inline.
These have been tried no use, later is to change the table type to MyISAM will not be wrong, but still do not understand the problem I said: "It said the row size is 8126 bytes, but we often say the maximum length of varchar is not 65535?" Why is the maximum size of row smaller than this? ”
Forget to enlighten
me
Since you didn't delve into Mysql,innodb row size limitation, this article will help you:
http://www.percona.com/blog/2011/04/07/innodb-row-size-limitation/
