Magento 2

When attempting to reindex - the usual error. The limitation is 65535. By others calculations it is number of varchar attributes * 255.

However, in my case, the sql create statement for the flat table has only 198 attributes, and many of them are integers, yet we receive this error.

I do not understand, as if the calculation is 255 * number of varchar attributes, we would not be at this limit.

Could an sql engineer or someone who understands fully this issue comment on why we could see this error with our number of attributes.

1 Answer 1


You're running into a MySQL/InnoDB server limitation that commonly occurs with a significant number of columns in a single table.

Fortunately there are several documented workarounds for it:




  • 1
    I don't think you understood my question. I understand exactly the error - however I am suggesting that the math behind the number of fields I have do not equal the row limit. 65535 divided by 255 is 257. I only have 198 attributes with many of them being integer.
    – Kyle Waid
    Jan 30, 2020 at 6:06

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.