設(shè)置MySQL wait_timeout
方法一:
mysql> set global wait_timeout=864000;
mysql> show global variables like 'wait_timeout';
mysql> show global variables like 'wait_timeout';
+---------------+--------+
| Variable_name | Value |
+---------------+--------+
| wait_timeout | 864000 |
+---------------+--------+
方法二:
vi /etc/my.cnf文件,在[mysqld]下方添加文字:
wait_timeout=864000
| Variable_name | Value |
+---------------+--------+
| wait_timeout | 864000 |
+---------------+--------+
方法二:
vi /etc/my.cnf文件,在[mysqld]下方添加文字:
wait_timeout=864000
posted on 2011-10-08 10:23 小一敗涂地 閱讀(2665) 評(píng)論(0) 編輯 收藏 所屬分類: 數(shù)據(jù)庫(kù)(oracle、mysql、sql server等)相關(guān)