Magento SQLSTATE[08S01]: Communication link failure: 1153 Got a packet bigger than 'max_allowed_pack
来源:互联网 发布:javaweb角色权限源码 编辑:程序博客网 时间:2024/06/04 19:42
今天在批量伪造测试数据时,MySQL收到下面异常:ERROR 1153 (08S01): Got a packet bigger than 'max_allowed_packet' bytes。
这是因为没有调整mysql的默认配置,默认最大只能处理16M的文件,而我要导入的伪造数据有50M的一个SQL。
于是调整配置文件: /etc/my.cnf
修改mysql的最大允许包大小
在[mysqld]部分(不在这部分没用)添加一句:
max_allowed_packet=50M
重启mysql服务就可以了。
重启命令如下:
一、启动方式
1、使用 service 启动:service mysqld start
2、使用 mysqld 脚本启动:/etc/inint.d/mysqld start
3、使用 safe_mysqld 启动:safe_mysqld&
二、停止
1、使用 service 启动:service mysqld stop
2、使用 mysqld 脚本启动:/etc/inint.d/mysqld stop
3、mysqladmin shutdown
三、重启
1、使用 service 启动:service mysqld restart
2、使用 mysqld 脚本启动:/etc/inint.d/mysqld restart
0 0
- Magento SQLSTATE[08S01]: Communication link failure: 1153 Got a packet bigger than 'max_allowed_pack
- ERROR 1153 (08S01): Got a packet bigger than 'max_allowed_packet' bytes
- ERROR 1153 (08S01): Got a packet bigger than 'max_allowed_packet' bytes
- ERROR 1153 (08S01): Got a packet bigger than 'max_allowed_packet' 解决办法
- 1153 - Got a packet bigger than 'max_allowed_packet' bytes With statement
- [SQL] 1153 – Got a packet bigger than ‘max_allowed_packet’ bytes
- mysql error code 1153:Got a packet bigger than ‘max_allowed_packet’
- Got a packet bigger than 'max_allowed_packet' bytes
- Got a packet bigger than 'max_allowed_packet' bytes
- Got a packet bigger than 'max_allowed_packet' bytes
- mysql-Got a packet bigger than ‘max_allowed_packet’ bytes
- error: Got a packet bigger than ‘max_allowed_packet’ bytes
- MySQL Got a packet bigger than 'max_allowed_packet' bytes错误
- MySQL Got a packet bigger than 'max_allowed_packet' bytes错误
- Got a packet bigger than ‘max_allowed_packet’ bytes的解决方法
- MYSQL error: Got a packet bigger than ‘max_allowed_packet’ bytes
- MYSQL error: Got a packet bigger than ‘max_allowed_packet’ bytes
- MySQl Got a packet bigger than ' max_allowed_packet' bytes
- c++ primer 学习笔记21类的定义和声明、隐含的this指针、类作用域
- 并查集例题【hdu1232畅通工程,九度1444,hdu5631枚举删除边】
- 修改MFC程序图标
- 设计模式读书笔记之代理模式(Proxy)
- 使用Symantec代码签名证书对代码进行签名的 5 个理由
- Magento SQLSTATE[08S01]: Communication link failure: 1153 Got a packet bigger than 'max_allowed_pack
- 设计模式读书笔记之原型模式(Prototype)
- 先验概率、后验概率、最大似然估计(MLE)
- xUtils简介及其使用方法
- java简单排序学习之插入排序
- html5中的列表标签
- 设计模式读书笔记之抽象工厂模式(Abstract Factory)
- 关于c#sql中返回的dt问题探究
- 贝叶斯估计和最大后验估计