Will MyISAM type tables work better than InnoDB for large numbers of columns?
- by Ethan
I have a MySQL InnoDB table with 238 columns. 56 of them are TEXT type, 27 are VARCHAR(255).
I am getting MySQL error 139 when users insert data sometimes. After research I found that I'm probably running into InnoDB row size/column size/column count limitations. (I'm putting it that way because the specific limits among those three things are interdependent.)
Docs on InnoDB give an idea of the limits. If I switch this table to MyISAM is it likely to solve the problem?
I understand the maximum row size of 65,535 bytes. I think I'm hitting InnoDB's additional 8000 byte limit somehow.
Switching to PostgreSQL is also a remote option, but would take much longer.