mysql连接SocketTimeoutException

最新推荐文章于 2024-10-09 10:32:38 发布
最新推荐文章于 2024-10-09 10:32:38 发布
阅读量306 收藏
点赞数 4
分类专栏： 数据库 文章标签： mysql spring boot
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/m0_37630138/article/details/142649591
版权

问题

  springboot项目连接mysql数据库，日志中频繁出现连接异常报错。项目中mysql的连接配置如下：

spring:
  datasource:
    driver-class-name: com.mysql.cj.jdbc.Driver
    type: com.alibaba.druid.pool.DruidDataSource
    url: jdbc:mysql://ip:3306/dbName:imi-sys-test?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=false&serverTimezone=GMT%2B8&allowMultiQueries=true&autoReconnect=true
    username: root
    password: 123456
    druid:
      initial-size: 5
      min-idle: 5
      maxActive: 200
      maxWait: 60000
      timeBetweenEvictionRunsMillis: 60000
      minEvictableIdleTimeMillis: 300000
      validationQuery: SELECT 1
      testWhileIdle: true
      testOnBorrow: true
      testOnReturn: false
      poolPreparedStatements: true
      maxPoolPreparedStatementPerConnectionSize: 20
      filters: stat,slf4j
      connectionProperties: druid.stat.mergeSql\=true;druid.stat.slowSqlMillis\=5000

报错日志如下所示：

2024-09-10 02:00:17.662 [http-nio-11004-exec-4] ERROR traceId:[06ce3d78cad447a6] druid.sql.Statement - {conn-10046, pstmt-1291623} execute error. UPDATE device_data_statistics  SET device_id=?, merchant_id=?, data_type=?, date_type=?, year=?, month=?,   value=?, create_time=?, update_time=?  WHERE id=?
com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure

The last packet successfully received from the server was 10,010 milliseconds ago. The last packet sent successfully to the server was 10,010 milliseconds ago.
	at com.mysql.cj.jdbc.exceptions.SQLError.createCommunicationsException(SQLError.java:175)
	at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:64)
	at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:916)
	at com.mysql.cj.jdbc.ClientPreparedStatement.execute(ClientPreparedStatement.java:354)
	at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:3446)
	at com.alibaba.druid.filter.FilterEventAdapter.preparedStatement_execute(FilterEventAdapter.java:434)
	at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:3444)
	at com.alibaba.druid.filter.FilterEventAdapter.preparedStatement_execute(FilterEventAdapter.java:434)
	at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:3444)
	at com.alibaba.druid.proxy.jdbc.PreparedStatementProxyImpl.execute(PreparedStatementProxyImpl.java:152)
	at com.alibaba.druid.pool.DruidPooledPreparedStatement.execute(DruidPooledPreparedStatement.java:483)
	at org.apache.ibatis.executor.statement.PreparedStatementHandler.update(PreparedStatementHandler.java:48)
	at org.apache.ibatis.executor.statement.RoutingStatementHandler.update(RoutingStatementHandler.java:75)
	at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:50)
	at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:117)
	at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:76)
	at sun.reflect.GeneratedMethodAccessor39.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:61)
	at com.sun.proxy.$Proxy231.update(Unknown Source)
	at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:197)
	at sun.reflect.GeneratedMethodAccessor44.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:425)
	at com.sun.proxy.$Proxy134.update(Unknown Source)
	at org.mybatis.spring.SqlSessionTemplate.update(SqlSessionTemplate.java:288)
	at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:64)
	at com.baomidou.mybatisplus.core.override.MybatisMapperProxy$PlainMethodInvoker.invoke(MybatisMapperProxy.java:148)
	at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:89)
	at com.sun.proxy.$Proxy135.updateById(Unknown Source)
	at net.imitech.iot.service.impl.DeviceDataStatisticsServiceImpl.saveOrUpdatePowerData(DeviceDataStatisticsServiceImpl.java:1034)
	at net.imitech.iot.service.impl.DeviceDataStatisticsServiceImpl.powerStatistics(DeviceDataStatisticsServiceImpl.java:156)
	at net.imitech.iot.service.impl.DeviceDataStatisticsServiceImpl.calculateAndSaveCurrentTimePower(DeviceDataStatisticsServiceImpl.java:211)
	at net.imitech.iot.service.impl.DeviceDataStatisticsServiceImpl$$FastClassBySpringCGLIB$$cdde6c81.invoke(<generated>)
	at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
	at org.springframework.aop.framework.CglibAopProxy.invokeMethod(CglibAopProxy.java:386)
	at org.springframework.aop.framework.CglibAopProxy.access$000(CglibAopProxy.java:85)
	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:704)
	at net.imitech.iot.service.impl.DeviceDataStatisticsServiceImpl$$EnhancerBySpringCGLIB$$b77c0656.calculateAndSaveCurrentTimePower(<generated>)
	at net.imitech.iot.service.impl.ThreePhaseMeterServiceImpl.saveThreePhaseMeterData(ThreePhaseMeterServiceImpl.java:80)
	at net.imitech.iot.service.impl.ThreePhaseMeterServiceImpl$$FastClassBySpringCGLIB$$4a6a1bfa.invoke(<generated>)
	at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:793)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)
	at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:123)
	at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:388)
	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:119)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)
	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:708)
	at net.imitech.iot.service.impl.ThreePhaseMeterServiceImpl$$EnhancerBySpringCGLIB$$72e80861.saveThreePhaseMeterData(<generated>)
	at net.imitech.iot.service.handler.acrel.AcrelHandler.saveToDB(AcrelHandler.java:92)
	at net.imitech.iot.service.handler.acrel.AcrelHandler.handle(AcrelHandler.java:67)
	at net.imitech.iot.service.impl.HfPw21ServiceImpl.handle(HfPw21ServiceImpl.java:52)
	at net.imitech.iot.service.impl.MqttMessageServiceImpl.mqttMessageDeal(MqttMessageServiceImpl.java:42)
	at net.imitech.iot.controller.MqttMessageController.mqttMessageDeal(MqttMessageController.java:31)
	at net.imitech.iot.controller.MqttMessageController$$FastClassBySpringCGLIB$$4bf84811.invoke(<generated>)
	at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:793)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)
	at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:89)
	at net.imitech.common.core.aspect.log.RequestLogAspect.fuckLogBeforeAndAfter(RequestLogAspect.java:144)
	at sun.reflect.GeneratedMethodAccessor205.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:634)
	at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:624)
	at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:72)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)
	at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:97)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)
	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:708)
	at net.imitech.iot.controller.MqttMessageController$$EnhancerBySpringCGLIB$$681398f4.mqttMessageDeal(<generated>)
	at sun.reflect.GeneratedMethodAccessor280.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)
	at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:150)
	at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:117)
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:895)
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:808)
	at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
	at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1072)
	at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:965)
	at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)
	at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:909)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:555)
	at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:623)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:209)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153)
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153)
	at net.imitech.lib.springboot.starter.log.filter.TraceFilter.doFilter(TraceFilter.java:60)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153)
	at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153)
	at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153)
	at org.springframework.boot.actuate.metrics.web.servlet.WebMvcMetricsFilter.doFilterInternal(WebMvcMetricsFilter.java:96)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153)
	at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:167)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:481)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:130)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
	at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:390)
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63)
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:926)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1791)
	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52)
	at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
	at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Thread.java:750)
Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure

The last packet successfully received from the server was 10,010 milliseconds ago. The last packet sent successfully to the server was 10,010 milliseconds ago.
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
	at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
	at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:62)
	at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105)
	at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:150)
	at com.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:166)
	at com.mysql.cj.protocol.a.NativeProtocol.readMessage(NativeProtocol.java:582)
	at com.mysql.cj.protocol.a.NativeProtocol.checkErrorMessage(NativeProtocol.java:762)
	at com.mysql.cj.protocol.a.NativeProtocol.sendCommand(NativeProtocol.java:701)
	at com.mysql.cj.protocol.a.NativeProtocol.sendQueryPacket(NativeProtocol.java:1052)
	at com.mysql.cj.NativeSession.execSQL(NativeSession.java:657)
	at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:893)
	... 132 common frames omitted
Caused by: java.net.SocketTimeoutException: Read timed out
	at java.net.SocketInputStream.socketRead0(Native Method)
	at java.net.SocketInputStream.socketRead(SocketInputStream.java:116)
	at java.net.SocketInputStream.read(SocketInputStream.java:171)
	at java.net.SocketInputStream.read(SocketInputStream.java:141)
	at com.mysql.cj.protocol.ReadAheadInputStream.fill(ReadAheadInputStream.java:107)
	at com.mysql.cj.protocol.ReadAheadInputStream.readFromUnderlyingStreamIfNecessary(ReadAheadInputStream.java:150)
	at com.mysql.cj.protocol.ReadAheadInputStream.read(ReadAheadInputStream.java:180)
	at java.io.FilterInputStream.read(FilterInputStream.java:133)
	at com.mysql.cj.protocol.FullReadInputStream.readFully(FullReadInputStream.java:64)
	at com.mysql.cj.protocol.a.SimplePacketReader.readHeaderLocal(SimplePacketReader.java:81)
	at com.mysql.cj.protocol.a.SimplePacketReader.readHeader(SimplePacketReader.java:63)
	at com.mysql.cj.protocol.a.SimplePacketReader.readHeader(SimplePacketReader.java:45)
	at com.mysql.cj.protocol.a.TimeTrackingPacketReader.readHeader(TimeTrackingPacketReader.java:52)
	at com.mysql.cj.protocol.a.TimeTrackingPacketReader.readHeader(TimeTrackingPacketReader.java:41)
	at com.mysql.cj.protocol.a.MultiPacketReader.readHeader(MultiPacketReader.java:54)
	at com.mysql.cj.protocol.a.MultiPacketReader.readHeader(MultiPacketReader.java:44)
	at com.mysql.cj.protocol.a.NativeProtocol.readMessage(NativeProtocol.java:576)
	... 137 common frames omitted

解决方法

  通过看日志，报错SocketTimeoutException，超时时间是10010ms，而springboot的SocketTimeout默认配置是10000ms。
  在MySQL的连接后面添加&connectTimeout=3000&socketTimeout=60000后再也没发生这个错误。

new666999
关注
专栏目录
深入理解mysql中的各种超时属性
小伍的程序之路
06-03 2020
连接超时: 登录超时: Socket网络超时，即读超时: sql执行超时:spring事务超时:innodb锁等待超时:mysql server网络回包写超时(针对大量数据查询的sql)
Nacos1.3连接MySQL5.7，抛出SocketTimeoutException异常
dwb0328的专栏
12-19 698
Nacos与MySQL连接，通信发生握手问题
mysql连接 udp_UDP连接对象原理解析及使用实例
weixin_35949431的博客
01-28 490
之前写了一个简单的UDP服务端和客户端示例，用于入门UDP，当我实际使用时发生了一点问题！上次使用中我也把连接对象 DatagramSocket 写成了静态的，在类的初始化时使用，可是系统中有很多地方使用，难道我要不断的创建这个类的对象吗？可以这么做，当时有后果，后果就是内存溢出。UDP是没有状态的，DatagramSocket 创建一次即可，就是开始指向某个地址的端口，而不用每次创建。由于UDP...
linux java 连接 mysql_linux下java连接mysq异常
weixin_39530833的博客
01-19 83
我用linux下java连接mysql的jar包。但连接老是出现这个异常。请高手帮忙解决。不知道原因是什么。com.mysql.jdbc.exceptions.jdbc4.CommunicationsException:Communicationslinkfailu...我用linux下java连接mysql的jar包。但连接老是出现这个异常。请高手帮忙解决。不知道原因是什么。com.mysql....
5. 在使用JDBC连接MySQL时，如何处理连接超时问题？
zhzjn的博客
09-19 623
在使用JDBC连接MySQL时，处理连接超时问题可以通过配置连接超时、Socket读超时、管理闲置连接以及异常处理机制来实现。使用连接池时，通过适当的参数配置，可以进一步优化连接管理，确保在各种网络和负载条件下的稳定性。你可以通过JDBC连接URL参数来设置连接超时时间，确保在指定时间内无法建立连接时抛出异常。在发生连接超时或其他数据库连接问题时，应用程序应该捕获并处理这些异常，以便采取相应的恢复措施或提供友好的错误信息。：设置连接在池中保持空闲状态的最长时间（以秒为单位），超过这个时间的连接将被释放。
hivecontex释放mysql连接_通过beeline连接到hive时，自动关闭连接了
weixin_36165398的博客
01-21 620
这个server2的log... 41 more2016-05-05 08:36:02,911 WARN [main]: hive.metastore (HiveMetaStoreClient.java:open(439)) - set_ugi() not successful, Likely cause: new client talking to old server. Continuing...
informix连接mysql_一个JDBC连接informix数据库很头疼的问题
weixin_39986435的博客
01-27 471
用JDBC连接informix数据库，出数据并将数据保存到本地时出现以下异常：java.sql.SQLException: System or internal error java.net.SocketException: Socket closedat com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:421)at com.i...
Mysql 客户端常见异常分析
若明天不见
01-28 1473
Mysql 客户端常见异常分析`jdbc timeout`包括Transaction Timeout/Statement Timeout/connectTimeout/socketTimeout四种类型，详细解释可见[Jdbc & Mysql timeout分析](https://tillend.blog.csdn.net/article/details/122567848)
mysql连接的配置---mybatis-plus设置---okhttp的使用
qq_45734535的博客
09-21 250
一、mysql连接的配置—mybatis-plus设置 application.yml配置 spring: datasource: driver-class-name: com.mysql.cj.jdbc.Driver url: jdbc:mysql://127.0.0.1:3306/db?serverTimezone=GMT%2B8&useUnicode=true&characterEncoding=utf8&autoReconnect=true&all
mysql java.net.SocketTimeoutException: connect timed out
09-13
对于出现 "java.net.SocketTimeoutException: connect timed out" 的错误，它通常表示在连接到MySQL数据库时发生了超时。这可能是由于以下一些常见原因导致的： 1. 网络问题：请确保您的网络连接正常并且没有阻止与...
pod访问外部mysql_pod连接外部数据库超时分析和处理方法
weixin_36087877的博客
01-21 1266
1、错误日志关键日志：Caused by: java.net.SocketTimeoutException: connect timed outThe last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server....
Springboot＋Mysql出现java.net.SocketTimeoutException: Read timed out
11-25
出现java.net.SocketTimeoutException: Read timed out的原因可能是网络连接超时或者MySQL服务器响应时间过长。可以尝试以下几种方法解决该问题： 1. 增加连接超时时间 可以在Spring Boot的配置文件中增加连接超时...
mysql8 Caused by: java.net.SocketTimeoutException: connect timed out
09-20
Caused by: java.net.SocketTimeoutException: connect timed out 是一个错误信息，它表示在连接MySQL 8数据库时发生了连接超时的情况。这个错误通常是由于网络连接问题、数据库服务器负载过高或者防火墙设置等原因...
MySQL【知识改变命运】03
2402_84062064的博客
10-07 1564
表的创建
Mysql（索引与事务）
qq_63074244的博客
10-02 815
在早些年代会出现，A给B转了钱而B却并未收到，因此引入了事务中的回滚（指的是通过检查若没有执行成功就回退回去，比如A给B转了钱而B却并未收到时，那么就会触发回滚把A转出金额再返回给A）来解决这一问题。事务是把多个SQL打包成为一个整体，要么都执行，要么做到看起来都不执行的样子。原子性：保证一系列操作都能正确执行或者恢复如初一致性：事务执行之前之后，数据都不能太离谱持久性：事务做出的修改，都是在硬盘上持久保存的。服务器重启数据依然存在隔离性：解决数据库处理并非事务中出现的问题。
基于微信小程序的生鲜订购小程序系统(SpringBoot+Vue+Uniapp+MySQL)
源码好优多
10-06 1835
开发者不再需要手动配置大量的 XML 文件或繁琐的注解，框架提供了默认的配置，根据项目的依赖关系和约定，自动完成配置。系统测试主要是为了避免用户在使用时发生问题，增强用户体验感，为了不影响用户的使用，我们需要从多角度、多思路去考虑系统可能遇到的问题，通过不同的模拟场景来发现缺陷并解决问题。添加用户时，必填项不填，检验系统是否有非空检验；登录功能测试方案：当需要登入该系统时，通过账户密码等功能点进行验证，用户在输入时需要输入与数据库内存储的数据匹配的内容，当其中某项输入错误时系统将提示输入错误。
MySQL 联合索引底层存储结构及索引查找过程解读
最新发布
lizi88888的博客
10-09 475
大家好，我是 Lorin ，联合索引（Composite Index）又称复合索引，它包括两个或更多列。与单列索引不同，联合索引可以覆盖多个列，这有助于加速复杂查询和过滤条件的检索。联合索引的列顺序非常重要，因为查询优化器会按照索引列的顺序执行搜索。本文将从联合索引基本概念、底层存储结构、索引查找过程、实践建议几个方面图文并茂进行详细介绍。
MySQL存储和处理XML数据
howard2005的专栏
10-02 462
MySQL不直接支持XML数据类型，但可以通过TEXT或BLOB类型字段存储XML数据，利用`ExtractValue`和`UpdateXML`函数进行查询和更新。首先，创建表并插入XML数据，然后通过XPath表达式提取信息。对于大型XML文件，推荐在应用层处理后存储结果。在操作XML数据时，确保使用正确的XPath表达式，并考虑性能影响。
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值