主题: centos 5.6下面,mysql连接数过高
在centos5.6下面安装iredmail0.7.1,其他都比较正常,就是mysql的连接数过高,昨天更新了老大的iredapd1.3.6,在mysql里面show processlist,进程数是减少了,得到了及时的释放。但连接数还是不断增加。
mysql> show status like '%Threads%';
+------------------------+-------+
| Variable_name | Value |
+------------------------+-------+
| Delayed_insert_threads | 0 |
| Slow_launch_threads | 0 |
| Threads_cached | 0 |
| Threads_connected | 23 |
| Threads_created | 8728 |
| Threads_running | 1 |
+------------------------+-------+
6 rows in set (0.00 sec)
mysql> show status like '%connect%';
+--------------------------+-------+
| Variable_name | Value |
+--------------------------+-------+
| Aborted_connects | 1 |
| Connections | 8839 |
| Max_used_connections | 49 |
| Ssl_client_connects | 0 |
| Ssl_connect_renegotiates | 0 |
| Ssl_finished_connects | 0 |
| Threads_connected | 23 |
+--------------------------+-------+
7 rows in set (0.00 sec)
从mysql状态可以看出,实际连接的线程数只有20多个,但增加的连接数多达8000多个,一直不减,估计到最后,mysql又会超出连接数(我已经设置mysql连接数位10000)。
请老大帮忙分析分析,到底是什么原因引起的?