保存base64数据-行大小太大的问题 [英] saving base64 data - row size too large issue

问题描述

我有22个类型为longtext的数据库字段.如果我尝试使用以下数据保存12个字段，则会出现以下错误:

I have 22 database fields of type longtext. If I try saving 12 of the fields with the following data I get the following error:

#1118 - Row size too large. The maximum row size for the used table type, not     
counting BLOBs, is 8126. You have to change some columns to TEXT or BLOBs 

如果我只保存11个字段，它可以很好地保存.这是数据:

It saves fine if I only save 11 fields. Here's the data:

BYOkQoFxB5+S8VH8svilSI/hQCUDlh1wGhyHacxjNpShUKlGJJ5HZ1DQTKGexBaP65zeJksfOnvBloCSbVmNgYxQhaQHn7sJlKjwtC00X/me2K8Vs4I9cL9SZx58Q2iXXQBbJYaAhn0LaEJMUN0P7VWd0/MiKgXsJt0UiXBf7Rlo6JIooBlaf59zA+II1o3MJKmzyH4q7C1qm2bC0LIT79ZCWDDSdqQaKZ1k1gPMu+yDYQPjrNiQUW29K/AdJ/XpPHT50jaJUjoMv9fL2TK0bUMO0VGe+0Cf4j0BE3QHlFnHqdgnLCTWk8NVo5U4Y5XTObsZtWwd1wHFZNIatuvg0cQk6WHojx3H9HavxKs9JJWYp8eCywyLhjmF39jMoZRT4n8fSTGDGif2q3VJE7DQrmQTjyQkSl9yUWvcTTUHAyNRYKnthVbgbzOOhEvhOZPuD4h+dcGyiW/xk+Lvu2XqkMDBIBuLcKymrdhefi4DElpuwyKFH7DNt6Y3fllPN/0XuSF0YXPqnBDLUcZsMqdzWPZX4RoVza/0Do+mHejYUSYnhsFWtPUHlTnU6fojBqw0icoKqhwjcIVpZmATwgYwXclsSwqEBWm9q9DMNzXG73bq6bs29BKq3E9S/fxo9Bz3mThNaj33fhyD4mj8indAIQeLVWvW3dq4T8+0lao6Ll0=

如何解决此问题?如何增加行大小的字节，使其大于8126?

How can I fix the issue? How can I increase the bytes of the row size so it is more than 8126?

推荐答案

问题是InnoDB表的行大小限制，在此链接中，您可以找到一些解决问题的方法:

The problem is the row size limit for InnoDB tables, in this links you can find some approaches to solve this:

• http://www.mysqlperformanceblog.com/2011/04/07/innodb-row-size-limitation/
• https://dba.stackexchange.com/questions /6598/innodb-create-table-error-row-size-too-large

• http://www.mysqlperformanceblog.com/2011/04/07/innodb-row-size-limitation/
• https://dba.stackexchange.com/questions/6598/innodb-create-table-error-row-size-too-large

这篇关于保存base64数据-行大小太大的问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！