1、查看当前最大支持多少M
show VARIABLES like '%max_allowed_packet%'
![](https://img2018.cnblogs.com/blog/1722590/201906/1722590-20190622085543363-1236050982.png)
2、修改:set global max_allowed_packet = 20*1024*1024 这里改的是20M
3.百万数据只需设置set global max_allowed_packet = 100*1024*1024即可
2、修改:set global max_allowed_packet = 20*1024*1024 这里改的是20M
3.百万数据只需设置set global max_allowed_packet = 100*1024*1024即可