MySQL server has gone away解决办法
解决办法:
将max_allowed_packet值调大
01
mysql> SHOW GLOBAL VARIABLES LIKE '%packet';
02
+--------------------+---------+
03
| Variable_name | Value |
04
+--------------------+---------+
05
| max_allowed_packet | 1048576 |
06
+--------------------+---------+
07
1 row in set (0.00 sec)
08
www.2cto.com
09
mysql> SET GLOBAL max_allowed_packet=10485760;
10
Query OK, 0 rows affected (0.00 sec)
11
12
mysql> SHOW GLOBAL VARIABLES LIKE '%packet';
13
+--------------------+----------+
14
| Variable_name | Value |
15
+--------------------+----------+
16
| max_allowed_packet | 10485760 |
17
+--------------------+----------+
18
1 row in set (0.00 sec)
19
mysql>
作者 林夕9527