问题出现情景
多个微服务模块公用同一个数据库服务器导致大量的sleep线程。而mysql的默认sleep时间是28800秒。。。。默认最大连接数为151,这就导致经常会出现mysql too many connection 的异常
解决方法
mysql> show variables like "max_connections";
+-----------------+-------+
| Variable_name | Value |
+-----------------+-------+
| max_connections | 151 |
+-----------------+-------+
1 row in set (0.00 sec)
mysql> set GLOBAL max_connections=1000;
Query OK, 0 rows affected (0.00 sec)
mysql> set global wait_timeout=300;
Query OK, 0 rows affected (0.00 sec)
mysql>
完美解决!!!