问题描述
mysql写入时报错: [Error 1118: Row size too large (> 8126). Changing some columns to TEXT or BLOB or using ROW_FORMAT=DYNAMIC or ROW_FORMAT=COMPRESSED may help. In current row format, BLOB prefix of 768 bytes is stored inline.]
问题分析
看起来是单行超长。
解决方案
innodb压缩:
SET GLOBAL innodb_file_format=‘Barracuda’;
alter table gtc_distributions ROW_FORMAT=COMPRESSED;