我有一个rails 4应用程序的问题,它留下了空闲的mysql连接 . 在我们查看代码以确定原因时,我至少希望能够自动消除违规流程 . mysql文档说设置wait_timeout和interactive_timeout将关闭非活动连接,所以我将它们都设置为300.但是,如下所示,有各种进程超过300限制 . 我已经确认设置确实是300.为什么mysql不能消除这些进程?

mysql> show processlist;
+-----+--------------+-----------+--------------+---------+------+-------+------------------+
| Id  | User         | Host      | db           | Command | Time | State | Info             |
+-----+--------------+-----------+--------------+---------+------+-------+------------------+
| 143 | application | localhost | application | Sleep   | 1500 |       | NULL             |
| 144 | application | localhost | application | Sleep   | 1499 |       | NULL             |
| 145 | application | localhost | application | Sleep   |    0 |       | NULL             |
| 146 | application | localhost | application | Sleep   |  780 |       | NULL             |
| 147 | application | localhost | application | Sleep   |  783 |       | NULL             |
| 148 | application | localhost | application | Sleep   |    0 |       | NULL             |
| 149 | application | localhost | application | Sleep   |    7 |       | NULL             |
| 150 | application | localhost | application | Sleep   |    3 |       | NULL             |
| 151 | application | localhost | application | Sleep   |    8 |       | NULL             |
| 152 | application | localhost | application | Sleep   |    3 |       | NULL             |
| 155 | root         | localhost | NULL         | Query   |    0 | NULL  | show processlist |
+-----+--------------+-----------+--------------+---------+------+-------+------------------+
11 rows in set (0.00 sec)