调整mysql 最大传输数据 max_allowed_packet=500M

查看

-- show VARIABLES like '%max_allowed_packet%';
-- set global max_allowed_packet = 1024*1024*64;

-- show variables like '%timeout%';
-- show global status like 'com_kill';
show global variables like 'max_allowed_packet';
-- set global max_allowed_packet=1024*1024*64;

# For advice on how to change settings please see
# http://dev.mysql.com/doc/refman/5.7/en/server-configuration-defaults.html

[mysqld]
#
# Remove leading # and set to the amount of RAM for the most important data
# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
# innodb_buffer_pool_size = 128M
#
# Remove leading # to turn on a very important data integrity option: logging
# changes to the binary log between backups.
# log_bin
#
# Remove leading # to set options mainly useful for reporting servers.
# The server defaults are faster for transactions and fast SELECTs.
# Adjust sizes as needed, experiment to find the optimal values.
# join_buffer_size = 128M
# sort_buffer_size = 2M
# read_rnd_buffer_size = 2M
max_allowed_packet=500M

在 docker 中调整

sudo docker cp mysql_v1:/etc/mysql/my.cnf /home/apadmin/mysql/my.cnf

sudo docker cp mysql_v1:/etc/my.cnf /home/apadmin/mysql/my.cnf

sudo docker cp /home/apadmin/mysql/my.cnf mysql_v1:/etc/my.cnf

参考
https://stackoverflow.com/questions/8062496/how-to-change-max-allowed-packet-size