Home > database >  Mysql5.7 offline after reconnection
Mysql5.7 offline after reconnection

Time:10-06

Configuration information

& lt; The property name="initialSize" value="https://bbs.csdn.net/topics/${initialSize}" & gt; & lt;/property>
& lt; The property name="maxIdle" value="https://bbs.csdn.net/topics/${maxIdle}" & gt; & lt;/property>
& lt; The property name="minIdle" value="https://bbs.csdn.net/topics/${minIdle}" & gt; & lt;/property>
& lt; The property name="maxWait" value="https://bbs.csdn.net/topics/${maxWait}" & gt; & lt;/property>
& lt; The property name="validationQuery" & gt; & lt; Value> SELECT 1 & lt;/value> & lt;/property>
& lt; The property name="testOnBorrow" value="https://bbs.csdn.net/topics/true"/& gt;
& lt; The property name="testOnReturn" value="https://bbs.csdn.net/topics/true"/& gt;
& lt; The property name="testWhileIdle" value="https://bbs.csdn.net/topics/true"/& gt;
& lt; The property name="timeBetweenEvictionRunsMillis" value="https://bbs.csdn.net/topics/1000"/& gt;
& lt; The property name="minEvictableIdleTimeMillis" value="https://bbs.csdn.net/topics/1000"/& gt;
& lt; The property name="removeAbandoned" value="https://bbs.csdn.net/topics/true"/& gt;
& lt; The property name="removeAbandonedTimeout" value="https://bbs.csdn.net/topics/10"/& gt;
& lt; The property name="logAbandoned" value="https://bbs.csdn.net/topics/true"/& gt;

InitialSize=0
MaxActive=20
MaxIdle=20
MinIdle=0
MaxWait=10


After I unplug cable call getList obtain a list of all the data, and then after about 20 s network cable is connected, found dead in the calling thread card database, anyway reconnection

CodePudding user response:

http://blog.csdn.net/fantasydreams/article/details/45459653

CodePudding user response:

reference 1st floor sinat_28984567 response:
http://blog.csdn.net/fantasydreams/article/details/45459653


Can say more detailed? I am using for springmvc + mybatis + mysql5.7
How to change the configuration?
  • Related