mysql教程 too many connections
解決辦法:
1.在使用MYSQL數據源的地方加入try/catch/finally
2.檢查MySqlConnection使用後是否有做close()
3.不要把MysqlConnection連接弄成 static 的,每次連接都創建一個新的連接
eg:
復制內容到剪貼板 程序代碼
MySql.Data.MySqlClient.MySqlConnection mysqlConnection = new MySqlConnection(SDS.SMS.DAL.SqlHelper.strSMS);
mysqlConnection.Open();
string selectCommand = "select id,model,number,brand,sendtime,pubdate,autoinsert_flag,mobilephone from tbl_saledata where autoinsert_flag=0 and sendtime='" + date + "'";
try
{
IList Ilst = new List();
using (MySqlDataReader dr = MySql.Data.MySqlClient.MySqlHelper.ExecuteReader(SDS.SMS.DAL.SqlHelper.strSMS, selectCommand))
{while (dr.Read())
{
Ilst.Add(Populater(dr));
}
return Ilst;//關閉
dr.Close();mysqlConnection.Close();
}
}
catch (Exception e)
{
throw e;
}
finally
{
mysqlConnection.Close();}