mysql关闭死连接

SET GLOBAL wait_timeout = 28800; -- 设置全局等待超时时间为8小时
SET GLOBAL interactive_timeout = 28800; -- 设置全局交互超时时间为8小时

try (Connection conn = DriverManager.getConnection(url, username, password)) {
    conn.setNetworkTimeout(Executors.newSingleThreadExecutor(), 30000); // 设置网络超时时间为30秒
} catch (SQLException e) {
    e.printStackTrace();
}

mysqladmin -u username -p password ping

#!/bin/bash
mysql -u username -p password -e "SHOW PROCESSLIST" | grep -i "Sleep" | awk '{print $1}' | xargs -n 1 mysql -u username -p password -e "KILL"

HikariConfig config = new HikariConfig();
config.setJdbcUrl("jdbc:mysql://localhost:3306/mydb");
config.setUsername("username");
config.setPassword("password");
config.setConnectionTimeout(30000);
config.setIdleTimeout(600000);
config.setMaxLifetime(1800000);
HikariDataSource ds = new HikariDataSource(config);