mysql 连接数满了，无法连接

一、分析报错
本地和线上服务器崩溃，报错信息为：数据库连接失败，而此时数据库是无法连接

Error querying database. Cause:
org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to
obtain JDBC Connection; nested exception is
java.sql.SQLTransientConnectionException: HikariPool-1 - Connection is
not available, request timed out after 30001ms.

解决方法：

杀死连接时间较久，休眠时间大于50秒的数据库连接

SELECT CONCAT('KILL ', id, ';') AS kill_statement
FROM information_schema.processlist
WHERE command = 'Sleep' AND time > 50;

执行上面sql，把查询结果拿出来，然后执行就行，这样就不会连接不上mysql