本文主要向大家介绍了MySQL数据库之mysql 主从同步故障解决 Error 'Row size too large (> 8126). ,通过具体的内容向大家展现,希望对大家学习MySQL数据库有所帮助。
错误日志: Error ‘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.‘ on query. Default
database: ‘XXXXXX‘. Query: XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
\n
\n
\n
[mysqld]
max_allowed_packet = 1G
innodb_log_file_size = 30m ##这个配置由原来的1m 改为30M
innodb_log_buffer_size = 512M
本文由职坐标整理并发布,希望对同学们学习MySQL有所帮助,更多内容请关注职坐标数据库MySQL数据库频道!