pymysql 批量插入报错 MySQL server has gone away (BrokenPipeError(32, 'Broken pipe')

insert 语句批量插入的数据在3M 左右

通过pymyql 插入时报错：

MySQL server has gone away (BrokenPipeError(32, 'Broken pipe')

 

进入mysql  查询最大插入的packet:

show VARIABLES like '%max_allowed_packet%';

+--------------------------+------------+
| Variable_name            | Value      |
+--------------------------+------------+
| max_allowed_packet       | 1048576    |
| slave_max_allowed_packet | 1073741824 |
+--------------------------+------------+

 

可以看到  max_allowed_packet 最大是1M , 修改为10M即可：

set global max_allowed_packet = 1024*1024*10;