mysql报错

mysql插入数据报错：
问题一：

Error: java.io.IOException: com.mysql.jdbc.PacketTooBigException: Packet for query is too large (6519579 > 4194304). You can change this value on the server by setting the max_allowed_packet' 

解决：
linux环境下修改my.cnf文件

[mysqld]
max_allowed_packet = 40M

重启mysql服务

问题二
Error: java.io.IOException: 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环境下修改my.cnf文件

innodb_log_file_size=**

重启mysql服务

InnoDB log file 设置多大合适？参考：http://blog.csdn.net/langkeziju/article/details/51094289