[Err] 1118 - Row size too large (＞ 8126). Changing some columns to TEXT or BLOB or using ROW_FORMAT=

最新推荐文章于 2025-07-29 16:24:34 发布

原创最新推荐文章于 2025-07-29 16:24:34 发布 · 2.1k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#dba #sql #database #mysql #ROW_FORMAT

MySQL 同时被 2 个专栏收录

65 篇文章

订阅专栏

数据库

7 篇文章

订阅专栏

该发明涉及一种2-取代苯并咪唑-4-甲酰胺化合物及其制备方法和用途。这类化合物的结构如公式Ia所示，具有特定的R、R1、R2、Y1、Y2、R3和X定义。专利详细披露了化合物的合成工艺和潜在应用。

[Err] 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.
[Err] INSERT INTO `test_pct ` VALUES ('1010', '2-SUBSTITUTED BENZIMIDAZOLE-4-CARBOXAMIDE COMPOUND AND PREPARATION METHOD AND USE THEREOF', '2-取代苯并咪唑-4-甲酰胺类化合物及制备方法和应用', '2-取代苯并咪唑-4-甲酰胺类化合物及制备方法和应用; COMPOSÉ BENZIMIDAZOLE-4-CARBOXAMIDE SUBSTITUÉ EN POSITION 2, PROCÉDÉ DE PRÉPARATION ET UTILISATION DE CELUI-CI', 'The present invention relates to a 2-substituted benzimidazole-4-carboxamide compound and the preparation method and use thereof. The structure of the 2-substituted benzimidazole-4-carboxamide compound of the present invention is as shown in the general formula Ia, wherein the definitions of R, R1, R2, Y1, Y2, R3 and X are as shown in the claims and the description. Also disclosed is a

我用的是mysql5.6，表名为test_pct ，解决方法：

1、SET GLOBAL innodb_file_format='Barracuda'
show GLOBAL VARIABLES LIKE '%file_format%';

2、alter table test_pct ROW_FORMAT=COMPRESSED

3、SHOW table status like 'test_pct'，以下参数生效了即可。如下图所示：