主从:Error:The size of BLOB/TEXT data inserted in one transaction is greater than 10% of redo log size

秒速五厘米 2022-11-15 11:14 54阅读 0赞

问题描述：mysql主从复制报错：Last\_SQL\_Error: Error 'The size of BLOB/TEXT data inserted in one transaction is greater than 10% of redo log size. Increase the redo log size using innodb\_log\_file\_size.  
意思就是：在一个事务中插入的BLOB/TEXT数据的大小大于重做日志大小的10%。使用innodb\_log\_file\_size增加重做日志大小。  
报错如下：  
![MySQL主从复制报错][MySQL]  
解决步骤：  
`1、查看innodb_log_file_size值的大小`

mysql> SHOW VARIABLES LIKE '%innodb_log_file_size%';
    +----------------------+---------+
    | Variable_name        | Value   |
    +----------------------+---------+
    | innodb_log_file_size | 5242880 |
    +----------------------+---------+

值为：5242880/1024/1024=5M  
`2、停止主从`

mysql> stop slave;
    Query OK, 0 rows affected (0.01 sec)

`3、修改innodb_log_file_size值的大小`

vim my.cnf
    #添加参数
    innodb_log_file_size=256M

说明：修改完重启从数据库，企图临时修改set innodb_log_file_size = 256 * 1024 * 1024;，会报错：ERROR 1238 (HY000): Variable 'innodb_log_file_size' is a read only variable，只读变量，所有只能修改配置文件重启数据库。

`4、重起完数据库，开启主从`

SHOW VARIABLES LIKE '%innodb_log_file_size%';
    +----------------------+-----------+
    | Variable_name        | Value     |
    +----------------------+-----------+
    | innodb_log_file_size | 268435456 |
    +----------------------+-----------+
    1 row in set (0.00 sec)
    mysql> start slave;
    Query OK, 0 rows affected, 1 warning (0.00 sec)

![主从状态恢复][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDMyMDc2MQ_size_16_color_FFFFFF_t_70]  
完美解决，MySQL主从恢复正常！

[MySQL]: /images/20221022/7af1b38c55ae41689dbde85f4a4f7d4a.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDMyMDc2MQ_size_16_color_FFFFFF_t_70]: https://img-blog.csdnimg.cn/20210331142525964.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDMyMDc2MQ==,size_16,color_FFFFFF,t_70

主从:Error:The size of BLOB/TEXT data inserted in one transaction is greater than 10% of redo log size

发表评论取消回复

还没有评论，来说两句吧...

相关阅读

相关 ORA-00823: Specified value of sga_target greater than sga_max_size

相关 row size is 8157 which is greater than maximum allowed size (8126) for a record on index leaf page

相关 MySQL修改redo_log_size

相关 Spark报Total size of serialized results of 12189 tasks is bigger than spark.driver.maxResultSize

相关 Creating index ‘PRIMARY‘ required more than ‘innodb_online_alter_log_max_size‘ bytes of

相关主从:Error:The size of BLOB/TEXT data inserted in one transaction is greater than 10% of redo log size

相关 Size (154.47 GB) is greater than max_[table/partition]_size_to_drop (50.00 GB) 2. File ‘/data/servic

相关 Multi-statement transaction required more than 'max_binlog_cache_size' bytes of storage

相关 ORA-00823 Specified value of sga_target greater than sga_max_size———sga_target大于指定值的sga_max_size

相关【StreamSets】 JDBC_502 - Batch size greater than maximal batch size allowed in sdc.properties