建表不成功，ROW_FORMAT=COMPACT存储分析

可以看下8.0.29之后的一个新变化

1. InnoDB: When using COMPACT or REDUNDANT row format, it was possible to create a table that exceeded the maximum row size, which could eventually result in 'Row size too large' errors when inserting data. BLOB prefixes were not included in the record size check performed during the CREATE TABLE operation. (Bug #33399379)

复制代码

详情见 https://dev.mysql.com/doc/relnotes/mysql/8.0/en/news-8-0-29.html

或者把row format改成dynamic就行了

yejr 发表于 2022-9-23 14:54
或者把row format改成dynamic就行了

是的，主要是这样所有应用都需要核查修改，活大。还有一个可以设置innodb_strict_mode=OFF，这个最简单，就是还没有理清楚影响范围有多大，不敢动。

nyp30 发表于 2022-9-23 15:03
是的，主要是这样所有应用都需要核查修改，活大。还有一个可以设置innodb_strict_mode=OFF，这个最简单， ...

都上8.0版本了，row_format也跟着升级下吧 ：）