Magento – “Row Size Exceeding 65535” while this seems impossible

admince-1.9.0.1databaseflat-catalogmagento-1.9

I'm getting this error:

Row Size Exceeding 65535

There are a lot of posts out there discussing the maximum row size in catalog_product_flat_x exceeding 65535 bytes. I have only about 150 attributes including the double entry _values for the select attributes. If all attributes were 255 bytes (which they aren't), the maximum number of bytes that I could have is 38,250 bytes far less than the 65,535 byte limit. The actual data in each row is significantly lower than that.

I deleted all of the catalog_product_flat_x tables, reindexed and am still getting this crazy error. I am on my way to having 4000 products and need this capability.

Any insight would be helpful

Best Answer

It is not depending on what your rows really hold for data but what is possible. According to official MySQL documentation https://dev.mysql.com/doc/refman/5.0/en/column-count-limit.html

The maximum row size constrains the number (and possibly size) of columns because the total length of all columns cannot exceed this size. For example, utf8 characters require up to three bytes per character, so for a CHAR(255) CHARACTER SET utf8 column, the server must allocate 255 × 3 = 765 bytes per value. Consequently, a table cannot contain more than 65,535 / 765 = 85 such columns

So you hit the wall way faster than in your example

Related Topic