mysql 问题记录
问题:mysql:1153 Got a packet bigger than ‘max_allowed_packet’ bytes
因为需要迁移的数据表太大了导致的,需要修改缓存区,或者一次迁移少量的数据表,方法:临时修改缓存
1 | mysql>set global max_allowed_packet=524288000; # 修改缓存为512M |
All articles in this blog are licensed under CC BY-NC-SA 4.0 unless stating additionally.