Mysql 错误解决:ERROR 2013 (HY000): Lost connection to MySQL server at 'reading authorization packet'
来源:互联网 发布:菲凡软件 编辑:程序博客网 时间:2024/05/29 13:16
mysql 在执行一条 insert 时出现如下错误:
事后再次执行相同的SQL,成功ERROR 2013 (HY000): Lost connection to MySQL server at 'reading authorization packet', system error: 0
经分析,相同的方向正在 rsync 同步一个 2G 文件,导致网络IO、CPU都非常高,可能导致 mysql 服务器超时
检查 mysql 超时时间设置为 10 秒:
mysql> show variables like 'connect_timeout';
+-----------------+-------+
| Variable_name | Value |
+-----------------+-------+
| connect_timeout | 60 |
+-----------------+-------+
1 row in set (0.00 sec)
还好 rsync 时间不长,所以暂时调大超时时间解决:
mysql> set global connect_timeout = 60;
同时更新 /etc/my.cnf,在 [mysqld] 项下添加:
connect_timeout = 60
0 0
- Mysql 错误解决:ERROR 2013 (HY000): Lost connection to MySQL server at 'reading authorization packet'
- ERROR 2013 (HY000): Lost connection to MySQL server at ‘reading authorization packet’, system error:
- ERROR 2013 (HY000): Lost connection to MySQL server at 'reading authorization packet', system error:
- 手把手解决Mysql错误:Lost connection to MySQL server at 'reading authorization packet', system error: 0
- mysql连接远程数据库出现 ERROR 2013 (HY000) Lost connection to MySQL server at 'reading authorization packet',
- Lost connection to MySQL server at 'reading initial communication packet' 错误解决
- MySQL error: 2013, “Lost connection to MySQL server at 'reading initial communication packet', syste
- Lost connection to MySQL server at 'reading authorization packet' 处理解决办法
- 2013 - Lost connection to MySQL server at ‘reading initial communication packet’, system error: 0
- Lost connection to MySQL server at ‘reading initial communication packet
- Lost connection to MySQL server at ‘reading initial communication packet
- Lost connection to MySQL server at ‘reading initial communication packet', system error: 0 mysql远程连接
- 连接mysql出现Lost connection to MySQL server at 'reading initial communication packet', system error: 0
- MySql Lost connection to MySQL server at 'reading initial communication packet', system error: 0
- 解决MySQL Error (2013): Lost connection to MySQL server at waiting for initial communication packet
- Lost connection to MySQL server at ‘reading initial communication packet’, system error: 111
- lost connection to mysql server at 'reading initial communication packet',system error:2
- Lost connection to MySQL server at ‘reading initial communication packet', system error: 0
- [转] android自定义布局中的平滑移动
- app被拒原因
- Android最佳性能实践(四)——布局优化技巧
- 已生成用于更新的 ResultSet
- 三种方法实现Android定制RadioButton样式
- Mysql 错误解决:ERROR 2013 (HY000): Lost connection to MySQL server at 'reading authorization packet'
- String.split和StringUtils.split的区别
- Windows系统内存使用查看
- java.util.Date和java.sql.Date的区别及应用
- QNX6.6下开启SSH服务步骤
- 求M的N次方的最后三位
- 【黑马程序员】-c函数
- UVa 10305 Ordering Tasks
- iOS将长方形的图片截成正方形显示