本篇內容主要講解“MySQL連接超時相關的兩個參數interactive_timeout和wait_timeout的區別及解釋”,感興趣的朋友不妨來看看。本文介紹的方法操作簡單快捷,實用性強。下面就讓小編來帶大家學習“MySQL連接超時相關的兩個參數interactive_timeout和wait_timeout的區別及解釋”吧!
先看看官方文檔對于這兩個參數的定義
interactive_timeout
默認是28800,單位秒,即8個小時
The number of seconds the server waits for activity on an interactive connection before closing it. An interactive client is defined as a client that uses the CLIENT_INTERACTIVE option to mysql_real_connect(). See also wait_timeout.
wait_timeout
默認同樣是28800s
The number of seconds the server waits for activity on a noninteractive connection before closing it.
On thread startup, the session wait_timeout value is initialized from the global wait_timeout value or from the global interactive_timeout value, depending on the type of client (as defined by the CLIENT_INTERACTIVE connect option to mysql_real_connect()). See also interactive_timeout.
interactive_timeout針對交互式連接,wait_timeout針對非交互式連接。所謂的交互式連接,即在mysql_real_connect()函數中使用了CLIENT_INTERACTIVE選項。
說得直白一點,通過mysql客戶端連接數據庫是交互式連接,通過jdbc連接數據庫是非交互式連接。
interactive_timeout:交互式連接超時時間(mysql工具、mysqldump等)
wait_timeout:非交互式連接超時時間,默認的連接mysql api程序,jdbc連接數據庫等
在連接啟動的時候,根據連接的類型,來確認會話變量wait_timeout的值是繼承于全局變量wait_timeout,還是interactive_timeout。
如何設置和查看:
mysql> set global interactive_timeout=1800;
Query OK, 0 rows affected (0.00 sec)
mysql> set global wait_timeout=1800;
Query OK, 0 rows affected (0.00 sec)
mysql> show global variables like 'interactive_timeout';
+---------------------+-------+
| Variable_name | Value |
+---------------------+-------+
| interactive_timeout | 1800 |
+---------------------+-------+
1 row in set (0.00 sec)
mysql> show global variables like 'wait_timeout';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| wait_timeout | 1800 |
+---------------+-------+
1 row in set (0.00 sec)
到此,相信大家對“MySQL連接超時相關的兩個參數interactive_timeout和wait_timeout的區別及解釋”有了更深的了解,不妨來實際操作一番吧!這里是億速云網站,更多相關內容可以進入相關頻道進行查詢,關注我們,繼續學習!
免責聲明:本站發布的內容(圖片、視頻和文字)以原創、轉載和分享為主,文章觀點不代表本網站立場,如果涉及侵權請聯系站長郵箱:is@yisu.com進行舉報,并提供相關證據,一經查實,將立刻刪除涉嫌侵權內容。