https://www.cnblogs.com/DataArt/p/10173957.html
1 查询表大小
SELECT table_name AS "表名",
round(((data_length + index_length) / 1024 / 1024), 2) AS "大小(MB)"
FROM information_schema.tables
WHERE table_schema = 'your_database_name' AND table_name = 'order';
2 设置
2.1 最大1G
SET GLOBAL max_allowed_packet=1024*1024*1024;;
2.2 或者,在 my.cnf
(或 my.ini
)配置文件中设置:
[mysqld]
max_allowed_packet=512M