C# 連接mysql,即使關閉連接,Mysql狀態依然是sleep

深藏阁楼爱情的钟 2022-04-18 06:07 171阅读 0赞

Aborted connection 245 to db: '數據庫' user: '用戶' host: '--IP地址--' (Got timeout reading communication packets)For more information, see Help and Support Center

參考[https://stackoverflow.com/questions/5567097/using-mysqlconnection-in-c-sharp-does-not-close-properly][https_stackoverflow.com_questions_5567097_using-mysqlconnection-in-c-sharp-does-not-close-properly]

關閉方法

if (this.\_Connection != null)  
        \{  
            this.\_Connection.Close();  
        \}  
        this.\_Connection.Dispose();  
        if (this.\_Transaction != null)  
        \{  
            this.\_Transaction.Dispose();  
        \}

採用-- 顯示連接數--查看 狀態依然存在 為sleep,線程池並沒有真正關閉  
SHOW PROCESSLIST

而是等待wait\_timeout時間限制時,會自動關閉,然後有系統日誌記錄

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xvc2VkZ3Vlc3Q_size_16_color_FFFFFF_t_70][]

解決方案,但是有點耗時

conn.\_Connection.ClearPoolAsync(conn.\_Connection);//使用完後,關閉連接池 這樣關閉后,不會出現系統日誌

這樣會關閉所有的閒置連接池

MySqlConnection.ClearPool(MySqlConnection connection)清空关联的连接池
    MySqlConnection.ClearAllPools()清空所有连接池
    如果连接正在使用，连接池会做相应标记，等连接关闭时自动烧毁。

參考[https://www.cnblogs.com/supersnowyao/p/8652722.html][https_www.cnblogs.com_supersnowyao_p_8652722.html]

[https_stackoverflow.com_questions_5567097_using-mysqlconnection-in-c-sharp-does-not-close-properly]: https://stackoverflow.com/questions/5567097/using-mysqlconnection-in-c-sharp-does-not-close-properly
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xvc2VkZ3Vlc3Q_size_16_color_FFFFFF_t_70]: /images/20220418/e5ace84805d443ddb1a86c07041e7250.png
[https_www.cnblogs.com_supersnowyao_p_8652722.html]: https://www.cnblogs.com/supersnowyao/p/8652722.html