mysql too many connections

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();

            }