The last packet sent successfully to the server was 0 milliseconds ago.
来源:互联网 发布:python websocket 编辑:程序博客网 时间:2024/06/05 19:18
今天在使用JDBC操作mysql时遇到下面的异常信息:
着实让人崩溃的信息,花费了一天的时间来解决。
不罗嗦,直接描述解决办法。
交互:
300k records
300k * 10 = 3M次访问mysql
处理时间0.5h以内
解决方法:
(1)使用JDBC URL中使用autoReconnect属性,url添加
(2) 修改MySQL的参数. /etc/my.cnf 添加
(3)重启mysql
原因分析:
(1)大量数据访问情况下,mysql connection连接有可能失效
(2)长时间不妨问,connection会失效
更多参考:
http://dev.mysql.com/doc/refman/5.1/zh/database-administration.html#dynamic-system-variables
http://www.blogjava.net/heweiya/archive/2006/01/18/28483.html
引用
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
at com.tomymap.galaxy.virgo.util.DbService.getConnection(DbService.java:66)
at com.tomymap.galaxy.virgo.util.DbService.getConnection(DbService.java:46)
at com.tomymap.galaxy.virgo.dao.PNNDao.getConnection(PNNDao.java:51)
at com.tomymap.galaxy.virgo.dao.DaoBase.executeUpdate(DaoBase.java:69)
at com.tomymap.galaxy.virgo.dao.PNNDao.updatePNNRelation(PNNDao.java:161)
at com.tomymap.galaxy.virgo.pnn.PyramidNeuralNetwork.buildPNNRelations(PyramidNeuralNetwork.java:400)
at com.tomymap.galaxy.virgo.pnn.PyramidNeuralNetwork.incrementalGenPNN(PyramidNeuralNetwork.java:144)
at com.tomymap.galaxy.virgo.pnn.PyramidNeuralNetwork.main(PyramidNeuralNetwork.java:410)
at com.tomymap.galaxy.virgo.util.DbService.getConnection(DbService.java:66)
at com.tomymap.galaxy.virgo.util.DbService.getConnection(DbService.java:46)
at com.tomymap.galaxy.virgo.dao.PNNDao.getConnection(PNNDao.java:51)
at com.tomymap.galaxy.virgo.dao.DaoBase.executeUpdate(DaoBase.java:69)
at com.tomymap.galaxy.virgo.dao.PNNDao.updatePNNRelation(PNNDao.java:161)
at com.tomymap.galaxy.virgo.pnn.PyramidNeuralNetwork.buildPNNRelations(PyramidNeuralNetwork.java:400)
at com.tomymap.galaxy.virgo.pnn.PyramidNeuralNetwork.incrementalGenPNN(PyramidNeuralNetwork.java:144)
at com.tomymap.galaxy.virgo.pnn.PyramidNeuralNetwork.main(PyramidNeuralNetwork.java:410)
着实让人崩溃的信息,花费了一天的时间来解决。
不罗嗦,直接描述解决办法。
- 配置:
- ubuntu10.10
- 5.1.49-1ubuntu8.1
- mysql-connector-java-5.1.18.jar
交互:
300k records
300k * 10 = 3M次访问mysql
处理时间0.5h以内
解决方法:
(1)使用JDBC URL中使用autoReconnect属性,url添加
- &autoReconnect=true&failOverReadOnly=false&maxReconnects=10
(2) 修改MySQL的参数. /etc/my.cnf 添加
- [mysqld]
- wait_timeout=31536000
- interactive_timeout=31536000
(3)重启mysql
- service mysql restart
原因分析:
(1)大量数据访问情况下,mysql connection连接有可能失效
(2)长时间不妨问,connection会失效
更多参考:
http://dev.mysql.com/doc/refman/5.1/zh/database-administration.html#dynamic-system-variables
http://www.blogjava.net/heweiya/archive/2006/01/18/28483.html
0 0
- The last packet sent successfully to the server was 0 milliseconds ago. The
- [Java] 解决异常:“The last packet sent successfully to the server was 0 milliseconds ago.
- The last packet sent successfully to the server was 0 milliseconds ago.
- The last packet sent successfully to the server was 0 milliseconds ago. 的解决办法
- The last packet sent successfully to the server was 0 milliseconds ago.
- The last packet sent successfully to the server was 0 milliseconds ago.
- java mysql The last packet sent successfully to the server was 0 milliseconds ago.
- The last packet sent successfully to the server was 0 milliseconds ago.
- The last packet sent successfully to the server was 0 milliseconds ago.
- 异常The last packet sent successfully to the server was 0 milliseconds ago...
- The last packet sent successfully to the server was 0 milliseconds ago
- The last packet sent successfully to the server was 0 milliseconds ago问题的解决
- Communications link failure:The last packet sent successfully to the server was 0 milliseconds ago.
- mysql 连接出现The last packet sent successfully to the server was 0 milliseconds ago.问题解决
- The last packet sent successfully to the server was 0 milliseconds ago.
- 【MySql】数据库连接异常:The last packet sent successfully to the server was 0 milliseconds ago
- Communications link failure The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received
- The last packet sent successfully to the server was 0 milliseconds ago, The driver has not received
- 终于找到了不用自定义一个activity栈,来关闭所有activity的方法了!!!
- PHP 创建、增加、删除、修改 xml
- Caffe学习笔记6-Caffe结构简析(知乎同步)
- JVM栈
- 常用meta整理
- The last packet sent successfully to the server was 0 milliseconds ago.
- Elasticsearch安装中文分词插件ik
- 重新设置CentOS 7的Root密码的方法
- 30-CSS-04-CSS(关联选择器&组合选择器)
- 配置LINUX下VIM配色环境
- java基本类型(数值范围):浮点的底层表示定义,float计算快一些
- Java 学习笔记(1) -- 名词解释
- DL DD DT 下拉列表(jquery)-代码很简洁
- mysql时间类型区别及使用