mysql - php insert Got a packet bigger than 'max_allowed_packet' bytes

Question

线上发现错误Got a packet bigger than 'max_allowed_packet' bytes
但是只是插入一条数据而已，怎么会报这个错呢
max_allowed_packet 我也设置成了10M

Answer 1

谢邀，能查到对应sql语句吗

Answer 2

谢邀，重启数据库了吗

Answer 3

谢邀，命令行执行

set global net_buffer_length=1000000; 
set global max_allowed_packet=1000000000;