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

叮咚侠

于 2022-02-17 09:56:41 发布

阅读量2k

点赞数

CC 4.0 BY-SA版权

分类专栏：数据库 MySQL 文章标签： dba sql database mysql ROW_FORMAT

本文链接：https://blog.csdn.net/home_zhang/article/details/122976861

MySQL 同时被 2 个专栏收录

65 篇文章

订阅专栏

数据库

6 篇文章

订阅专栏

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

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

[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'，以下参数生效了即可。如下图所示：