MySQL server has gone away解决办法

最新推荐文章于 2023-05-13 11:43:57 发布

weixin_33832340

最新推荐文章于 2023-05-13 11:43:57 发布

阅读量67

点赞数

文章标签：数据库 python

原文链接：https://my.oschina.net/bufenye/blog/71333

版权

2019独角兽企业重金招聘Python工程师标准>>>

解决办法:将max_allowed_packet值调大

mysql> SHOW GLOBAL VARIABLES LIKE '%packet';
+--------------------+---------+
| Variable_name      | Value   |
+--------------------+---------+
| max_allowed_packet | 1048576 |
+--------------------+---------+
1 row in set (0.00 sec)

mysql> SET GLOBAL max_allowed_packet=10485760;
Query OK, 0 rows affected (0.00 sec)

mysql> SHOW GLOBAL VARIABLES LIKE '%packet';
+--------------------+----------+
| Variable_name      | Value    |
+--------------------+----------+
| max_allowed_packet | 10485760 |
+--------------------+----------+
1 row in set (0.00 sec)
mysql>

转载于:https://my.oschina.net/bufenye/blog/71333