问题1: MySQL server has gone away With statement
原因:SQl insert 插入的语句天长导致
问题2:mysql a bulk size specified must be increased
原因:批量缓存设置太小导致
解决办法:window my.ini Linux my.cnf 编辑添加如下内容
max_allowed_packet=256M
bulk_insert_buffer_size = 256M
添加内容如下
[mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock user=mysql max_allowed_packet=256M bulk_insert_buffer_size = 256M
记得是在mysqld节点,保存,退出之后重新启动MySQL服务就OK了