MySQL中too many connections问题解决
mysql> showprocesslist;+---------+------+---------------------+---------+---------+------+-------+-------------------+-------------------------+
| Id | User | Host | db | Command | Time | State | Info |
+---------+------+---------------------+---------+---------+------+-------+-------------------+-------------------------+
| 1180421 | ur |202.103.96.68:49754 | test1 |Sleep | 1 | | NULL |
| 1180427 | ur |202.103.96.68:55079 | test2 |Sleep | 1 | | NULL |
| 1180429 | ur |202.103.96.68:55187 | testdba | Sleep| 0 | | NULL |
| 1180431 | ur |202.103.96.68:55704 | testdba | Sleep| 0 | | NULL |
| 1180437 | ur |202.103.96.68:32825 | test1 |Sleep | 1 | | NULL |
| 1180469 | ur |202.103.96.68:58073 | testdba | Sleep| 0 | | NULL |
| 1180472 | ur |83.136.93.131:47613 | test2 |Sleep | 8 | | NULL |
| 1180475 | root | localhost | NULL | Query | 0| NULL| showPROCESSLIST |
+---------+------+---------------------+---------+---------+------+-------+-------------------+---------------------------+
8 rows in set (0.00 sec)
mysql>
页:
[1]