MySQL case system ~ MySQL Common log error

Summary: This article is intended to summarize common error summaries for MySQL logs

Case series:

Case 1

Error message: Com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:The size of blob/text data inserted in one transaction I s greater than 10% of redo log size. Increase the redo log size using innodb_log_file_size.
Analysis: The value of Blob/text is greater than the growth of the redo log
Status: This parameter cannot be changed online
Workaround: mysql5.6 default innodb_log_file_size=50m Add innodb_log_file_size=256m to the configuration file and restart
mysql5.5 need to remove the existing redo log before restarting MySQL
Case 2
Error message Max_allowed_packet setting too small causes Java program write failure
Status: This parameter can be changed online
WORKAROUND: MySQL 5.6 1 max_allowed_packet=32m write config file and restart
2 Set Global max_allowed_packet=33554432

MySQL case system ~ MySQL Common log error