故障信息:
Cannot add field `I125` in table `cwbb`.`bs015` because after adding it, the row size is 8127 which is greater than maximum allowed size (8126) for a record on index leaf page.
1.查看max_allowed_packet
该值设置过小将导致单个记录超过限制后写入数据库失败,且后续记录写入也将失败。
show VARIABLES like '%max_allowed_packet%';
. 在MySQL的配置文件中添加:
max_allowed_packet=100M
或者更多
2.innodb_file_per_table 设置表空间(单独存放)
innodb_file_per_table=1
3. 修改MySQL全局变量:
SET GLOBAL innodb_file_format='Barracuda';//设置表的压缩
4. 删除原表,创建一个新表,并设置表的属性:
ROW_FORMAT=COMPRESSED
注意:3,4必须同时做
https://www.jb51.net/article/50364.htm
MySQL InnoDB 行记录格式(ROW_FORMAT)