mysql的连接一直很2B，以前是过段时间会中断连接。
现在是一启动就报错。
主要的解决办法就是在连接池（我用的是Druid）上下功夫。
在连接时，它会有一个检测的配置：
大致如下：
testValiation=select 1
testOnBorrow=true
refurl:http://nkcoder.github.io/blog/20140712/mysql-reconnect-packet-lost/
wandejun1012
- 浏览: 2719222 次
- 性别:
- 来自: 上海
-
文章分类
- 全部博客 (1313)
- JS (65)
- CSS (6)
- html (30)
- dweamweaver工具相关 (2)
- Spry (1)
- DB (103)
- p2p (1)
- java (405)
- .net (3)
- oracle (24)
- struts (18)
- myeclipse (15)
- linux (49)
- SQL SERVER2008 (101)
- jsp (21)
- resume (1)
- other (1)
- ajax (3)
- 云计算 (2)
- excel (32)
- vss (1)
- 警戒 (1)
- eclipse (21)
- c (1)
- dialog designer (7)
- axis1.4 (4)
- webservice (11)
- CTI (1)
- svn (8)
- spring (27)
- tomcat (13)
- log4j (14)
- 网络应用 (7)
- mysql (59)
- bat (4)
- jdbc (1)
- 正式表达式 (1)
- hibernate (27)
- iphone (2)
- 系统应用 (107)
- servlet (3)
- vmware (2)
- php (12)
- JQuery (30)
- avaya (5)
- postgresql (19)
- java面试 (1)
- rose (1)
- Socket (1)
- xml (2)
- PowerDesign (3)
- visio (1)
- jstl (4)
- informix (2)
- assemble (2)
- English Study (2)
- IOS (9)
- CMMI (1)
- outlook (4)
- poi (1)
- hadoop (5)
- SAE (3)
- jor (1)
- jquery mobile (1)
- git (11)
- mina (1)
- ibatis (2)
- wordpress (2)
- 支付宝 (1)
- struts2 (14)
- apns (1)
- html5 (1)
- xampp (2)
- uml (2)
- 项目管理 (1)
- 敏捷开发 (1)
- 设计模式 (2)
- spark (1)
- maven (9)
- 微信公众平台 (1)
- json (2)
- junit (1)
- quartz (2)
- redis (2)
- memcache (1)
- android (3)
- 红杏 (1)
- postman (1)
- mybatis (5)
- iplat4j (1)
- windows (1)
- logback (1)
- Netty (1)
- wiki (1)
- dubbo (1)
- sonar (2)
- jenkins (2)
- mac (10)
- office (4)
- groovy (1)
- intellij (6)
- zookeeper (2)
- 诛仙 (1)
- MQ (2)
- docker (1)
- 2222 (0)
最新评论
-
代码改变生活：
虽然代码敲的头疼的要命,但是依然要感谢你,感谢您共享!!!!开 ...
jxl读取excel日期相差8小时 -
www3837：
org.slf4j.Logger 下载 -
hyztty：
wait_timeout = 86400 interacti ...
druid连接池 -
niaodanwangzi：
连接池可不是给你检测连接状态用的。是为了连接复用，减少连接数。 ...
druid连接池 -
supermine0903：
学习了 啦啦啦
多个路由器同时上网
分享到：
发表评论
-
MySQL中有唯一性约束的列能否为null
2017-01-16 14:55 1390唯一索引中允许有null. 参考链接 ... -
Error : Invalid ON UPDATE clause for 'update_time' column
2017-01-16 14:53 8036这是因为mysql版本低导致的，只有5.5的会有这个问 ... -
mysql read innitial packet
2016-12-10 12:05 1037这是mysql PXC集群垮了的原因 我 ... -
druid连接池
2016-09-14 16:00 5160环境：Ubuntu+Mysql5.5 近期一直报 ... -
mysql 用户设置/取消权限
2016-08-30 10:10 1220#设置权限 grant select,ins ... -
ubuntu MySQL搭建全过程
2016-03-09 21:33 783环境：ubuntu 步骤： 1、利用sudo - ... -
mysql date_sub函数
2016-01-10 16:08 1542DATE_SUB(date,INTERVAL expr ... -
mysql 截串 判断字段包含
2015-10-29 10:05 10441、mysql截串用substring就行。 ... -
Data truncation: Incorrect dateti me value: '' for column
2015-08-02 01:08 2045原因是mysql从5.0版本升级到5.6造成的。 ... -
mysql 高可用架构 MHA
2015-07-26 23:33 1099http://51power.blog.51ct ... -
数据库隔离级别
2015-02-08 21:49 0事务（transaction）是数据库管理系统的执行单 ... -
ibatis # $ 区别
2015-02-08 21:07 0#是用来变量替换的，相当于sql中的?. $ ... -
分布式事务
2015-02-08 20:40 993当我们在生产线上用一台服务器来提供数据服务的时候，我会 ... -
mysql 存储过程
2015-01-28 12:02 8751、要想查看存储过程，用如下命令： show cr ... -
xampp Access denied for user 'root'@'localhost'
2015-01-27 14:25 1221这个原因就是mysql的密码被更改的原因所致。 ... -
You can't specify target table 'tb_car_profile' for update in FROM clause
2014-12-15 11:09 1243mysql中You can't specify ta ... -
mysql修改字段名
2014-10-08 01:55 797修改字段名 alter table testtab ... -
mysql快速删除数据
2014-09-05 22:55 884truncate table 表名，同sqlserve ... -
column count doesn't match value count at row 1
2014-09-03 10:10 762开发中运行mysql脚本，发现提示mysql提示Col ... -
mysql varchar 中文
2014-08-28 00:11 1025在mysql中，如果是UTF8编码，那么varchar ...
相关推荐
@[Android studio通过jdbc连接mysql基本步骤 以及 遇到的坑“The last packet sent successfully to the server was 0 milliseconds ago”哈哈] 小白第一次发博客哈哈，记录一下这三个晚上来我的悲惨经历以及我成功...
删除记录则有带条件和不带条件的`DELETE FROM`，需要注意的是，`DELETE`操作不会重置主键自增ID，而`TRUNCATE TABLE`会删除所有记录并重置ID。 查询操作是数据库操作的核心部分，`SELECT`语句用于获取数据。可以...
Cause com.mysql.jdbc.exceptions.jdbc4.CommunicationsException The last packet successfully received from the server was 47,795,922 milliseconds ago. The last packet sent successfully to the server was...
融合多个面上光强信息的混合迭代相位恢复算法
The last packet successfully received from the server was 56,201,339 milliseconds ago. The last packet sent successfully to the server was 56,201,339 milliseconds ago. is longer than the server ...
An ISP earns its money by charging each of the the ISPs that connect to the IXP a relatively small fee, which may depend on the amount of traffic sent to or received from the IXP. 15. Google's ...
### BSD Packet Filter (BPF): 新架构下的用户级数据包捕获 #### 概述 本文档探讨了**BSD Packet Filter (BPF)**——一种新型的用户级数据包捕获架构，该架构由Steven McCanne和Van Jacobson在1992年提出，并计划...
标题：Linux 2.4网络堆栈中数据包的旅程 描述：本文档详细阐述了在Linux内核2.4.x版本中数据包在网络层的处理流程，与2.2版本相比，由于弃用了全局序列化的下半部，转而采用新的软中断（softirq）系统，整个网络...
compose up 请注意，第一次运行时，您可能会看到： mvw_flyway | The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server. (Caused by...
• Does the interface prevent a rogue application from "hijacking" the tablet, or causing dead¬locks? • Does the sharing architecture promote efficiency? 2.4 Tablet Feature Support The interface ...
This is the release notice for the PCnet Magic Packet(TM) Utility Revision 1.00 software. All files are in DOS FAT format. AMD抯 Magic Packet utility is a convenient tool for system administrators ...
The Practical Packet Analysis course is perfect for beginners to intermediate analysts, but seasoned pros will probably learn a few useful techniques too. Whether you’ve never capture packets before ...
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successfully received from the server was 84,371,623 milliseconds ago. The last packet sent successfully to the server was 78,...
该方法不仅适用于802.11a/g的单输入单输出（SISO）速率，还扩展到了802.11n的多输入多输出（MIMO）速率。此外，该模型还可以用于优化发射功率选择和天线配置等参数，从而提高网络的整体性能。 #### 方法概述 1. **...
if the test was run a couple of times (without closing BurnInTest). Release 5.3 build 1021 WIN32 release 5 June 2008 - 32-bit BurnInTest PRO 5.3.1020 would not start on Windows 2000. This has been ...
The "ptsaplayer.dll" in the .zip package is the patch to fix the issue that Packet Tracer 7.2.2's PTSAPlayer plugin does not work on Windows 7. Apply the patch will fix the issue. Only users using...
Cisco Packet Tracer 7.2.2 removes the Java dependence and makes it easier to use Packet Tracer Skills Assessment (PTSA) and Packet Tracer Media Objects (PTMO) : After installing Packet Tracer 7.2.2...
The "ptsaplayer.dll" in the .zip package is the patch to fix the issue that Packet Tracer 7.2.2's PTSAPlayer plugin does not work on Windows 7. Apply the patch will fix the issue. Only users using...