WEB系统操作一段时间就连接不上，数据库mysql

[bustersword]

六七个人操作系统，频繁的进行搜索插入操作，大约10分钟数据库就连接不上了，非常奇怪，希望大大么，给出可能的原因.
服务器IIS windows2003

[zuoxingyu]

把MYSQ的错误日志贴出来看看。

还有你说的连不上的错误提示也贴出来。

[bustersword]

mysql> show status like 'threads_connected%';
+-------------------+-------+
| Variable_name | Value |
+-------------------+-------+
| Threads_connected | 2 |
+-------------------+-------+
1 row in set (0.00 sec)

mysql> show variables like 'max_connections%';
+-----------------+-------+
| Variable_name | Value |
+-----------------+-------+
| max_connections | 16000 |
+-----------------+-------+
1 row in set (0.00 sec)

mysql> show status like 'threads_connected%';
+-------------------+-------+
| Variable_name | Value |
+-------------------+-------+
| Threads_connected | 89 |
+-------------------+-------+
1 row in set (0.00 sec)
连接有很多....

mysql> show full processlist\g;
+-----+------+---------------------+-------+---------+------+--------------+----
-------------------+
| Id | User | Host | db | Command | Time | State | Inf
o |
+-----+------+---------------------+-------+---------+------+--------------+----
-------------------+
| 1 | root | 192.169.30.95:5657 | imp | Query | 0 | NULL | sho
w full processlist |
| 4 | root | swlsgser002:58686 | mysql | Sleep | 3463 | | NUL
L |
| 10 | root | localhost:58689 | imp | Sleep | 2096 | | NUL
L |
| 11 | root | localhost:58690 | imp | Sleep | 1531 | | NUL
L |
| 17 | root | 192.169.30.140:2011 | test | Sleep | 279 | | NUL
L |
| 19 | root | localhost:58691 | imp | Sleep | 2099 | | NUL
L |
| 20 | root | localhost:58692 | imp | Sleep | 2097 | | NUL
L |
| 25 | root | localhost:58693 | imp | Sleep | 1550 | | NUL
L |
| 26 | root | localhost:58694 | imp | Sleep | 1523 | | NUL
L |
| 32 | root | localhost:58726 | imp | Sleep | 1533 | | NUL
L |
| 33 | root | localhost:58727 | imp | Sleep | 1528 | | NUL
L |
| 34 | root | localhost:58728 | imp | Sleep | 1527 | | NUL
L |
| 35 | root | localhost:58729 | imp | Sleep | 1513 | | NUL
L |
| 36 | root | localhost:58730 | imp | Sleep | 1524 | | NUL
L |
| 37 | root | localhost:58731 | imp | Sleep | 1520 | | NUL
L |
| 38 | root | localhost:58732 | imp | Sleep | 1517 | | NUL
L |
| 39 | root | localhost:58733 | imp | Sleep | 1515 | | NUL
L |
| 40 | root | localhost:58734 | imp | Sleep | 1510 | | NUL
L |
| 41 | root | localhost:58735 | imp | Sleep | 1506 | | NUL
L |
| 42 | root | localhost:58736 | imp | Sleep | 1502 | | NUL
L |
| 43 | root | localhost:58737 | imp | Sleep | 1504 | | NUL
L |
| 44 | root | localhost:58738 | imp | Sleep | 1491 | | NUL
L |
| 45 | root | localhost:58739 | imp | Sleep | 1500 | | NUL
L |
| 46 | root | localhost:58740 | imp | Sleep | 1497 | | NUL
L |
| 47 | root | localhost:58741 | imp | Sleep | 1495 | | NUL
L |
| 48 | root | localhost:58742 | imp | Sleep | 1494 | | NUL
L |
| 49 | root | localhost:58743 | imp | Sleep | 1488 | | NUL
L |
| 50 | root | localhost:58744 | imp | Sleep | 1489 | | NUL
L |
| 51 | root | localhost:58745 | imp | Sleep | 1483 | | NUL
L |
| 52 | root | localhost:58746 | imp | Sleep | 1485 | | NUL
L |
| 53 | root | localhost:58747 | imp | Sleep | 1478 | | NUL
L |
| 54 | root | localhost:58748 | imp | Sleep | 1476 | | NUL
L |
| 55 | root | localhost:58749 | imp | Sleep | 1480 | | NUL
L |
| 56 | root | localhost:58750 | imp | Sleep | 1461 | | NUL
L |
| 57 | root | localhost:58751 | imp | Sleep | 1457 | | NUL
L |
| 58 | root | localhost:58752 | imp | Sleep | 1473 | | NUL
L |
| 59 | root | localhost:58753 | imp | Sleep | 1450 | | NUL
L |
| 60 | root | localhost:58754 | imp | Sleep | 1446 | | NUL
L |
| 61 | root | localhost:58755 | imp | Sleep | 1443 | | NUL
L |
| 62 | root | localhost:58756 | imp | Sleep | 1439 | | NUL
L |
| 63 | root | localhost:58757 | imp | Sleep | 1436 | | NUL
L |
| 64 | root | localhost:58758 | imp | Sleep | 1416 | | NUL
L |
| 65 | root | localhost:58759 | imp | Sleep | 1419 | | NUL
L |
| 66 | root | localhost:58760 | imp | Sleep | 1428 | | NUL
L |
| 67 | root | localhost:58761 | imp | Sleep | 1433 | | NUL
L |
| 68 | root | localhost:58762 | imp | Sleep | 1424 | | NUL
L |
| 69 | root | localhost:58763 | imp | Sleep | 1421 | | NUL
L |
| 70 | root | localhost:58764 | imp | Sleep | 1414 | | NUL
L |
| 71 | root | localhost:58765 | imp | Sleep | 1400 | | NUL
L |
| 72 | root | localhost:58766 | imp | Sleep | 1403 | | NUL
L |
| 73 | root | localhost:58767 | imp | Sleep | 1413 | | NUL
L |
| 74 | root | localhost:58768 | imp | Sleep | 1409 | | NUL
L |
| 75 | root | localhost:58769 | imp | Sleep | 1406 | | NUL
L |
| 76 | root | localhost:58770 | imp | Sleep | 1367 | | NUL
L |

[bustersword]

| 77 | root | localhost:58771 | imp | Sleep | 1398 | | NUL
L |
| 78 | root | localhost:58772 | imp | Sleep | 1330 | | NUL
L |
| 79 | root | localhost:58773 | imp | Sleep | 1310 | | NUL
L |
| 81 | root | localhost:58775 | imp | Sleep | 1363 | | NUL
L |
| 82 | root | localhost:58776 | imp | Sleep | 1362 | | NUL
L |
| 83 | root | localhost:58777 | imp | Sleep | 1318 | | NUL
L |
| 84 | root | localhost:58778 | imp | Sleep | 1327 | | NUL
L |
| 85 | root | localhost:58779 | imp | Sleep | 1323 | | NUL
L |
| 86 | root | localhost:58780 | imp | Sleep | 1299 | | NUL
L |
| 87 | root | localhost:58781 | imp | Sleep | 1316 | | NUL
L |
| 88 | root | localhost:58782 | imp | Sleep | 1314 | | NUL
L |
| 89 | root | localhost:58783 | imp | Sleep | 1304 | | NUL
L |
| 90 | root | localhost:58784 | imp | Sleep | 1286 | | NUL
L |
| 91 | root | localhost:58785 | imp | Sleep | 1306 | | NUL
L |
| 92 | root | localhost:58786 | imp | Sleep | 1297 | | NUL
L |
| 93 | root | localhost:58787 | imp | Sleep | 1291 | | NUL
L |
| 94 | root | localhost:58788 | imp | Sleep | 1294 | | NUL
L |
| 95 | root | localhost:58789 | imp | Sleep | 0 | | NUL
L |
| 96 | root | localhost:58790 | imp | Sleep | 1282 | | NUL
L |
| 97 | root | localhost:58791 | imp | Sleep | 1249 | | NUL
L |
| 98 | root | localhost:58792 | imp | Sleep | 1246 | | NUL
L |
| 99 | root | localhost:58793 | imp | Sleep | 595 | | NUL
L |
| 100 | root | localhost:58794 | imp | Sleep | 1242 | | NUL
L |
| 101 | root | localhost:58795 | imp | Sleep | 98 | | NUL
L |
| 102 | root | localhost:58796 | imp | Sleep | 1191 | | NUL
L |
| 103 | root | localhost:58797 | imp | Sleep | 662 | | NUL
L |
| 105 | root | localhost:58798 | imp | Sleep | 554 | | NUL
L |
| 107 | root | localhost:58799 | imp | Query | 2 | Sending data | cal
l DataCompare () |
| 110 | root | 192.169.30.140:2041 | test | Sleep | 259 | | NUL
L |
| 111 | root | 192.169.30.140:2042 | test | Sleep | 1 | | NUL
L |
| 112 | root | 192.169.30.140:2043 | test | Sleep | 259 | | NUL
L |
| 113 | root | localhost:58800 | imp | Sleep | 78 | | NUL
L |
| 114 | root | localhost:58801 | NULL | Sleep | 206 | | NUL
L |
| 116 | root | localhost:58802 | imp | Query | 0 | Sending data | cal
l DataCompare () |
+-----+------+---------------------+-------+---------+------+--------------+----
-------------------+
88 rows in set (0.00 sec)

[bustersword]

当连接100条时，就连不上了..........

[zuoxingyu]

看出来的问题有
1：程序在链接MYSQL进行操作后，没有正常关闭链接。
2：错误日志没有贴出来啊。

[bustersword]

110425 12:25:52 [Note] Plugin 'FEDERATED' is disabled.
110425 12:25:53 InnoDB: Started; log sequence number 0 80651048
110425 12:25:53 [Note] Event Scheduler: Loaded 1 event
110425 12:25:53 [Note] C:\Program Files (x86)\MySQL\MySQL Server 5.1\bin\mysqld: ready for connections.
Version: '5.1.46-community-log' socket: '' port: 3306 MySQL Community Server (GPL)
110425 13:58:23 [Note] C:\Program Files (x86)\MySQL\MySQL Server 5.1\bin\mysqld: Normal shutdown

110425 13:58:23 [Note] Event Scheduler: Purging the queue. 1 events
110425 13:58:25 [Warning] C:\Program Files (x86)\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 128 user: 'root'

110425 13:58:25 [Warning] C:\Program Files (x86)\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 127 user: 'root'

110425 13:58:25 [Warning] C:\Program Files (x86)\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 126 user: 'root'

110425 13:58:25 [Warning] C:\Program Files (x86)\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 125 user: 'root'

110425 13:58:25 [Warning] C:\Program Files (x86)\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 124 user: 'root'

110425 13:58:25 [Warning] C:\Program Files (x86)\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 123 user: 'root'

110425 13:58:25 [Warning] C:\Program Files (x86)\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 122 user: 'root'

110425 13:58:25 [Warning] C:\Program Files (x86)\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 121 user: 'root'

110425 13:58:25 [Warning] C:\Program Files (x86)\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 120 user: 'root'

110425 13:58:25 [Warning] C:\Program Files (x86)\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 119 user: 'root'

110425 13:58:25 [Warning] C:\Program Files (x86)\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 118 user: 'root'

110425 13:58:25 [Warning] C:\Program Files (x86)\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 117 user: 'root'

110425 13:58:25 [Warning] C:\Program Files (x86)\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 116 user: 'root'

110425 13:58:25 [Warning] C:\Program Files (x86)\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 114 user: 'root'

110425 13:58:25 [Warning] C:\Program Files (x86)\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 113 user: 'root'

110425 13:58:25 [Warning] C:\Program Files (x86)\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 112 user: 'root'

110425 13:58:25 [Warning] C:\Program Files (x86)\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 111 user: 'root'

110425 13:58:25 [Warning] C:\Program Files (x86)\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 110 user: 'root'

110425 13:58:25 [Warning] C:\Program Files (x86)\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 107 user: 'root'

110425 13:58:25 [Warning] C:\Program Files (x86)\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 105 user: 'root'

110425 13:58:25 [Warning] C:\Program Files (x86)\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 103 user: 'root'

110425 13:58:25 [Warning] C:\Program Files (x86)\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 102 user: 'root'

110425 13:58:25 [Warning] C:\Program Files (x86)\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 101 user: 'root'

110425 13:58:25 [Warning] C:\Program Files (x86)\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 100 user: 'root'

110425 13:58:25 [Warning] C:\Program Files (x86)\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 99 user: 'root'

110425 13:58:25 [Warning] C:\Program Files (x86)\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 98 user: 'root'

110425 13:58:25 [Warning] C:\Program Files (x86)\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 97 user: 'root'

110425 13:58:25 [Warning] C:\Program Files (x86)\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 96 user: 'root'

110425 13:58:25 [Warning] C:\Program Files (x86)\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 95 user: 'root'

110425 13:58:25 [Warning] C:\Program Files (x86)\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 94 user: 'root'

110425 13:58:25 [Warning] C:\Program Files (x86)\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 93 user: 'root'

110425 13:58:25 [Warning] C:\Program Files (x86)\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 92 user: 'root'

110425 13:58:25 [Warning] C:\Program Files (x86)\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 91 user: 'root'

110425 13:58:25 [Warning] C:\Program Files (x86)\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 90 user: 'root'

110425 13:58:25 [Warning] C:\Program Files (x86)\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 89 user: 'root'

110425 13:58:25 [Warning] C:\Program Files (x86)\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 88 user: 'root'

110425 13:58:25 [Warning] C:\Program Files (x86)\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 87 user: 'root'

110425 13:58:25 [Warning] C:\Program Files (x86)\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 86 user: 'root'

110425 13:58:25 [Warning] C:\Program Files (x86)\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 85 user: 'root'

110425 13:58:25 [Warning] C:\Program Files (x86)\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 84 user: 'root'

110425 13:58:25 [Warning] C:\Program Files (x86)\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 83 user: 'root'

110425 13:58:25 [Warning] C:\Program Files (x86)\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 82 user: 'root'

110425 13:58:25 [Warning] C:\Program Files (x86)\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 81 user: 'root'

110425 13:58:25 [Warning] C:\Program Files (x86)\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 79 user: 'root'

110425 13:58:25 [Warning] C:\Program Files (x86)\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 78 user: 'root'

110425 13:58:25 [Warning] C:\Program Files (x86)\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 77 user: 'root'

110425 13:58:25 [Warning] C:\Program Files (x86)\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 76 user: 'root'

110425 13:58:25 [Warning] C:\Program Files (x86)\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 75 user: 'root'

110425 13:58:25 [Warning] C:\Program Files (x86)\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 74 user: 'root'

110425 13:58:25 [Warning] C:\Program Files (x86)\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 73 user: 'root'

110425 13:58:25 [Warning] C:\Program Files (x86)\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 72 user: 'root'

110425 13:58:25 [Warning] C:\Program Files (x86)\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 71 user: 'root'

110425 13:58:25 [Warning] C:\Program Files (x86)\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 70 user: 'root'

110425 13:58:25 [Warning] C:\Program Files (x86)\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 69 user: 'root'

110425 13:58:25 [Warning] C:\Program Files (x86)\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 68 user: 'root'

110425 13:58:25 [Warning] C:\Program Files (x86)\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 67 user: 'root'

110425 13:58:25 [Warning] C:\Program Files (x86)\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 66 user: 'root'

[bustersword]

110425 13:58:25 [Warning] C:\Program Files (x86)\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 65 user: 'root'

110425 13:58:25 [Warning] C:\Program Files (x86)\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 64 user: 'root'

110425 13:58:25 [Warning] C:\Program Files (x86)\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 63 user: 'root'

110425 13:58:25 [Warning] C:\Program Files (x86)\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 62 user: 'root'

110425 13:58:25 [Warning] C:\Program Files (x86)\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 61 user: 'root'

110425 13:58:25 [Warning] C:\Program Files (x86)\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 60 user: 'root'

110425 13:58:25 [Warning] C:\Program Files (x86)\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 59 user: 'root'

110425 13:58:25 [Warning] C:\Program Files (x86)\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 58 user: 'root'

110425 13:58:25 [Warning] C:\Program Files (x86)\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 57 user: 'root'

110425 13:58:25 [Warning] C:\Program Files (x86)\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 56 user: 'root'

110425 13:58:25 [Warning] C:\Program Files (x86)\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 55 user: 'root'

110425 13:58:25 [Warning] C:\Program Files (x86)\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 54 user: 'root'

110425 13:58:25 [Warning] C:\Program Files (x86)\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 53 user: 'root'

110425 13:58:25 [Warning] C:\Program Files (x86)\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 52 user: 'root'

110425 13:58:25 [Warning] C:\Program Files (x86)\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 51 user: 'root'

110425 13:58:25 [Warning] C:\Program Files (x86)\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 50 user: 'root'

110425 13:58:25 [Warning] C:\Program Files (x86)\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 49 user: 'root'

110425 13:58:25 [Warning] C:\Program Files (x86)\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 48 user: 'root'

110425 13:58:25 [Warning] C:\Program Files (x86)\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 47 user: 'root'

110425 13:58:25 [Warning] C:\Program Files (x86)\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 46 user: 'root'

110425 13:58:25 [Warning] C:\Program Files (x86)\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 45 user: 'root'

110425 13:58:25 [Warning] C:\Program Files (x86)\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 44 user: 'root'

110425 13:58:25 [Warning] C:\Program Files (x86)\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 43 user: 'root'

110425 13:58:25 [Warning] C:\Program Files (x86)\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 42 user: 'root'

110425 13:58:25 [Warning] C:\Program Files (x86)\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 41 user: 'root'

110425 13:58:25 [Warning] C:\Program Files (x86)\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 40 user: 'root'

110425 13:58:25 [Warning] C:\Program Files (x86)\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 39 user: 'root'

110425 13:58:25 [Warning] C:\Program Files (x86)\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 38 user: 'root'

110425 13:58:25 [Warning] C:\Program Files (x86)\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 37 user: 'root'

110425 13:58:25 [Warning] C:\Program Files (x86)\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 36 user: 'root'

110425 13:58:25 [Warning] C:\Program Files (x86)\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 35 user: 'root'

110425 13:58:25 [Warning] C:\Program Files (x86)\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 34 user: 'root'

110425 13:58:25 [Warning] C:\Program Files (x86)\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 33 user: 'root'

110425 13:58:25 [Warning] C:\Program Files (x86)\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 32 user: 'root'

110425 13:58:25 [Warning] C:\Program Files (x86)\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 26 user: 'root'

110425 13:58:25 [Warning] C:\Program Files (x86)\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 25 user: 'root'

110425 13:58:25 [Warning] C:\Program Files (x86)\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 20 user: 'root'

110425 13:58:25 [Warning] C:\Program Files (x86)\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 19 user: 'root'

110425 13:58:25 [Warning] C:\Program Files (x86)\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 17 user: 'root'

110425 13:58:25 [Warning] C:\Program Files (x86)\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 11 user: 'root'

110425 13:58:25 [Warning] C:\Program Files (x86)\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 10 user: 'root'

110425 13:58:25 [Warning] C:\Program Files (x86)\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 4 user: 'root'

110425 13:58:25 [Warning] C:\Program Files (x86)\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 1 user: 'root'

110425 13:58:25 InnoDB: Starting shutdown...
110425 13:58:28 InnoDB: Shutdown completed; log sequence number 0 83643622
110425 13:58:28 [Note] C:\Program Files (x86)\MySQL\MySQL Server 5.1\bin\mysqld: Shutdown complete

110425 13:58:37 [Note] Plugin 'FEDERATED' is disabled.
110425 13:58:37 InnoDB: Started; log sequence number 0 83643622
110425 13:58:38 [Note] Event Scheduler: Loaded 1 event
110425 13:58:38 [Note] C:\Program Files (x86)\MySQL\MySQL Server 5.1\bin\mysqld: ready for connections.
Version: '5.1.46-community-log' socket: '' port: 3306 MySQL Community Server (GPL)

[ACMAIN_CHM]

你的连接数估计过多，导致内存或其它资源耗尽。

看看为什么会有这么多并发连接。

[mhss9301]

增大web和数据库的允许最大连接数

[bustersword]

IIS连接会有限制吗，数据库的连接我试过kill掉sleep进程，结果没到100也死掉了......

[iihero_]

[Quote=引用 9 楼 bustersword 的回复:]

IIS连接会有限制吗，数据库的连接我试过kill掉sleep进程，结果没到100也死掉了......
[/Quote]
不是指IIS的连接，应该是mysql的连接。

[M1234]

在[mysqld]中增加wait-timeout=10强制10秒自动断开

[bustersword]

我在网上搜了下，有说是基于WEB的mysql的一个bug，先前的连接不会断开，保持sleep状态，后面又新连接，前面的连接的指针就会丢失，于是就会形成大量的sleep连接........
然后我用using强制释放。。。。情况就好了......

[rucypli]

知道解决方法就好