mysql too many connections

mysql too many connections

解决办法:

1.在使用MYSQL数据源的地方加入try/catch/finally

2.检查MySqlConnection使用后是否有做close()

3.不要把MysqlConnection连接弄成 static 的,每次连接都创建一个新的连接.

程序代码如下:

1. MySql.Data.MySqlClient.MySqlConnectionmysqlConnection=newMySqlConnection(SDS.SMS.DAL.SqlHelper.strSMS);
3. mysqlConnection.Open();
5. stringselectCommand="selectid,model,number,brand,sendtime,pubdate,autoinsert_flag,mobilephonefromtbl_saledatawhereautoinsert_flag=0andsendtime='"+date+"'";
7. try
8. {
9. IListIlst=newList();
10. using(MySqlDataReaderdr=MySql.Data.MySqlClient.MySqlHelper.ExecuteReader(SDS.SMS.DAL.SqlHelper.strSMS,selectCommand))
11. {
13. while(dr.Read())
14. {
15. Ilst.Add(Populater(dr));
16. }
19. returnIlst;
21. //关闭
22. dr.Close();
24. mysqlConnection.Close();
26. }
27. }
28. catch(Exceptione)
29. {
30. throwe;
31. }
32. finally
33. {
34. mysqlConnection.Close();
36. }//phpfensi.com