mysql 重置max_allowed_packet解决办法

mysql> show variables like '%max_a%';
+--------------------------+------------+
| Variable_name            | Value      |
+--------------------------+------------+
| max_allowed_packet       | 1073741824 |
| slave_max_allowed_packet | 1073741824 |
+--------------------------+------------+
2 rows in set (0.00 sec)

改成1024M就好了，如果在报错，改成10240m

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
max_allowed_packet=1024M
# Disabling symbolic-links is recommended to prevent assorted security risks
lower_case_table_names=1
symbolic-links=0
default-character-set=utf8

[client]
default-character-set=utf8

[mysqld_safe]
max_allowed_packet=1024M
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
lower_case_table_names=1