Changes between Version 2 and Version 3 of jazz/MySQL

Timestamp:

Sep 12, 2017, 4:57:03 PM (7 years ago)

Author:

jazz

Comment:

--

jazz/MySQL

@@ -49 +49 @@
 17 rows in set (0.00 sec)
 }}}
-* 查詢目前的連線等待時間 - [參考] https://stackoverflow.com/questions/23399111/safely-keeping-mysql-connections-alive
+* 查詢目前的連線等待時間 
+** [參考] https://stackoverflow.com/questions/23399111/safely-keeping-mysql-connections-alive
+** 預設值是 28800 seconds
 {{{
 mysql> SHOW VARIABLES where Variable_name like 'wait%';
@@ -59 +61 @@
 1 row in set (0.00 sec)
 }}}
+** 可以 runtime 修改
+{{{
+mysql> set global wait_timeout=60;
+mysql> set session wait_timeout=60;
+mysql> SHOW VARIABLES where Variable_name like 'wait%';
++---------------+-------+
+| Variable_name | Value |
++---------------+-------+
+| wait_timeout  | 60    |
++---------------+-------+
+1 row in set (0.00 sec)
+}}}