Timeline for how many 'text' column a table could have in mysql? I have this error “Row size too large (> 8126).”
Current License: CC BY-SA 3.0
5 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Mar 7, 2014 at 12:51 | answer | added | Up_One | timeline score: 1 | |
| Mar 7, 2014 at 9:34 | comment | added | Jens D. | Have you dropped and recreated the table after switching the innodb file format? Have you also used innodb_file_per_table too? | |
| Mar 7, 2014 at 8:54 | comment | added | David Spillett | Are you getting the error when creating the table, when altering the table structure, or when inserting/manipulating rows? If the table created OK provide the results of running SHOW CREATE STATUS YourTableName to show what you currently have including what storage engine the table is using. Things like this will vary by storage type. | |
| Mar 7, 2014 at 7:26 | review | First posts | |||
| Mar 7, 2014 at 11:04 | |||||
| Mar 7, 2014 at 7:08 | history | asked | Satheesh T | CC BY-SA 3.0 |