mysql5.6.21 [Err] 2006和[Err] 1118错误处理

1、windows执行大数据量(10M)insert SQL时，提示错误

[Err] 2006 - MySQL server has gone away

  方案：修改My.ini文件，重启mysql服务

max_allowed_packet=4M
修改为
max_allowed_packet=20M

2、重新执行insert，继续报错

[Err] 1118 - 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.

  方案：修改My.ini文件，重启mysql服务

innodb_log_file_size=48M
修改为
innodb_log_file_size=512M