mysql报错Packet for query is too large 解决

mysql | 2019-09-13 10:02:39

mysql再批量插入时报错如下：

Packet for query is too large (6071393 > 4194304). You can change this value on the server by setting the max_allowed_packet' variable.

批量插入数据量过大，解决办法：


方法1.修改 my.ini 加上 max_allowed_packet =67108864

67108864=64M

默认大小4194304  也就是4M

修改完成之后要重启mysql服务，如果通过命令行修改就不用重启mysql服务。


方法2.命令修改：（即时生效）

正确写法：

设置为500M

mysql> set global max_allowed_packet = 500*1024*1024; 

或者

mysql> set global max_allowed_packet = 524288000;


查看是否生效：查看mysql的max_allowed_packet大小,运行

show VARIABLES like '%max_allowed_packet%';


登录后即可回复 登录 | 注册
    
相关文章
mybatis mysql on duplicate key update批量新增重复时更新mysql报错packet for query is too large 解决mysql 账户管理语句在ansi模式下运行mysqlphp mysql mysqlnd query result cache pluginphp cubrid mysql 兼容性函数 send a cubrid queryphp cubrid mysql 兼容性函数 perform a query without fetching the results into memoryphp mysql 函数 转义一个字符串用于 mysql queryphp mysql xdevapi collectionfind bind value to query placeholderphp mysql xdevapi collectionmodify bind value to query placeholderphp mysql xdevapi session execute sql queryphp mysql xdevapi tabledelete bind delete query parametersphp mysql xdevapi tabledelete execute delete queryphp mysql xdevapi tableinsert execute insert queryphp mysql xdevapi tableselect bind select query parametersphp mysql xdevapi tableupdate bind update query parametersphp mysql xdevapi tableupdate execute update queryphp mysqlnduhconnection sends a query to mysqlphp oci lob saves data to the large objectphp swoole mysql run the sql query.
关注编程学问公众号