2014.09.16 mysql server has gone away的解决方式
来源:互联网 发布:php网站制作教程视频 编辑:程序博客网 时间:2024/06/03 12:30
我在还原Mysql数据库备份时遇到:mysql server has gone away的错误.
原因是我备份的数据中有部分数据内容太大,最终采用的解决办法是通过增加max_allowed_packet对应的值来解决(默认值为1M,当执行的sql中对应字段长度大于1M时,会报错) 。
如何增加max_allowed_packet的值?
1.通过命令show global variables like 'max_allowed_packet';查看文件大小是否超过 max_allowed_packet :
mysql> show global variables like 'max_allowed_packet';+--------------------+---------+| Variable_name | Value |+--------------------+---------+| max_allowed_packet | 1048576 |+--------------------+---------+1 row in set (0.00 sec)
2.通过命令set global max_allowed_packet=1024*1024*16 修改参数,增加max_allowed_packet至16M:
mysql> set global max_allowed_packet=1024*1024*16;mysql> show global variables like 'max_allowed_packet';+--------------------+----------+| Variable_name | Value |+--------------------+----------+| max_allowed_packet | 16777216 |+--------------------+----------+1 row in set (0.00 sec)
0 0
- 2014.09.16 mysql server has gone away的解决方式
- Mysql server出现“Mysql server has gone away”的错误的解决方式
- MySQL: 诡异的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
- APP设计师必读!快速适配iPhone6及plus的诀窍
- 常见面试之机器学习算法思想简单梳理
- openIOC
- 4,org.apache.hadoop.security.AccessControlException: Permission denied: user=root, access=WRITE, in
- Using a Postman http client for efficient HTTP testing
- 2014.09.16 mysql server has gone away的解决方式
- Script Execution and Privilege Escalation on Jenkins Server
- 不需server,将浏览器缓存中的数据下载到本地硬盘
- was日志报检测到cpu饥饿
- Python源码学习笔记(1 基本数据类型)
- iOS 使用 Auto Layout 入门
- cocos2d-x中讲解TileMap地图编辑器的高级用法(一)
- Crome和firefox的Console使用方法
- java 多线程