问题现象

服务端打印频繁告警

2022-02-10 01:15:00,281 111- WARN  [XNIO-1 task-48] [com.alibaba.druid.pool.DruidAbstractDataSource] - discard long time none received connection. , jdbcUrl : jdbc:mysql://XXXX:3306/XXXX?useOldAliasMetadataBehavior=true&useUnicode=true&characterEncoding=UTF-8&autoReconnect=true&autoReconnectForPools=true&failOverReadOnly=false&connectTimeout=0&socketTimeout=0&allowMultiQueries=true&useSSL=false&serverTimezone=Asia/Shanghai&rewriteBatchedStatements=true, version : 1.2.4, lastPacketReceivedIdleMillis : 1553038 pos=DruidAbstractDataSource.java:1489 

解决办法

-Ddruid.mysql.usePingMethod=false

参考阅读

Druid连接报错的原因分析笔记
解决druid新版本报错 discard long time none received connection.
https://github.com/alibaba/druid