MySQL server has gone away
来源:互联网 发布:元数据管理工具 编辑:程序博客网 时间:2024/05/17 15:57
用一条insert语句向mysql插入多条数据时数据长度超长,mysql报错MySQL server has gone away
解决办法:
修改mysql配置文件vi /etc/my.cnf
加入
max_allowed_packet = 1000M
重启mysql:service mysql restart
0 0
- MySQL server has gone away
- MySQL server has gone away
- MySQL server has gone away
- MySQL server has gone away
- MySQL server has gone away
- MySQL server has gone away
- MySQL server has gone away
- MySQL server has gone away
- Mysql server has gone away
- MySQL server has gone away
- MySQL server has gone away
- MySQL server has gone away
- MySQL server has gone away
- MySQL server has gone away
- MySQL server has gone away
- MySQL server has gone away
- mysql server has gone away
- MySQL server has gone away
- POJ 2560Freckles(并查集)
- AsyncTask 内部实现机制
- shell中的函数
- 面向对象练习题
- 自己实现将整型转化为字符型
- MySQL server has gone away
- AngularJS实现跨域请求
- Ubuntu16.04下安装ns2.35
- 如何合理地估算线程池大小
- HelloCharts图表库之折线图
- 文件上传该注意的问题
- Android Studio 插件开发简介
- Java实现算法导论中最长公共子序列(LCS)动态规划法
- 匹配格式化的邮政地址正则表达式