09.04.2017, 09:57
https://dev.mysql.com/doc/refman/5.7...ow-size-limits
Increasing innodb_page_size should work, but that will just mask the symptoms. The cause will probably need to be sought with the data model, or rather the lack thereof. If you need to add a number to a column name then you're doing databases wrong. I've seen things like "Vehicle5Mod13" far too many times and it makes my hair stand up. Hundreds of columns because people don't use or don't want to use relations.
Increasing innodb_page_size should work, but that will just mask the symptoms. The cause will probably need to be sought with the data model, or rather the lack thereof. If you need to add a number to a column name then you're doing databases wrong. I've seen things like "Vehicle5Mod13" far too many times and it makes my hair stand up. Hundreds of columns because people don't use or don't want to use relations.