1. Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 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.
linux ubuntu 16
修改方法
show variables like '%innodb_log_file%';
show variables like '%shutdown%'; #确认innodb_fast_shutdown为1，这样在重启MySQL时，不会使用ib_logfile文件
vi /etc/mysql/my.cnf
[mysqld]
group_concat_max_len = 1024000
innodb_log_file_size=640M
max_allowed_packet = 128M
collation-server = utf8mb4_unicode_ci
init-connect='SET NAMES utf8mb4'
character-set-server = utf8mb4
[client]
default-character-set=utf8mb4
[mysql]
default-character-set=utf8mb4
/etc/init.d/mysql restart
