<\/span><\/h3>\n\n\n\n\u5efa\u8bae\u7528wait_timeout\u5373\u53ef<\/p>\n\n\n\n
\u5982\u4e0b\u4fee\u6539\u53c2\u6570\u4e3a3\u79d2\uff0c\u7a0d\u7b49\u518d\u6267\u884cSQL,\u53ef\u4ee5\u53d1\u73b0\u5176ID\u5df2\u7ecf\u53d8\u5316\uff0c\u4ece6\u53d8\u6210\u4e869\uff0c\u671f\u95f4\u6709\u91cd\u65b0\u8fde\u63a5\u7684\u4fe1\u606f\u3002<\/p>\n\n\n\n
gbase> show processlist;\n+----+-----------------+-----------+--------+---------+------+-----------------------------+------------------+\n| Id | User | Host | db | Command | Time | State | Info |\n+----+-----------------+-----------+--------+---------+------+-----------------------------+------------------+\n| 1 | event_scheduler | localhost | NULL | Daemon | 863 | Waiting for next activation | NULL |\n| 6 | root | localhost | testdb | Query | 0 | NULL | show processlist |\n+----+-----------------+-----------+--------+---------+------+-----------------------------+------------------+\n2 rows in set (Elapsed: 00:00:00.00)\n\ngbase> show variables like 'wait_timeout';\n+---------------+---------+\n| Variable_name | Value |\n+---------------+---------+\n| wait_timeout | 1000000 |\n+---------------+---------+\n1 row in set (Elapsed: 00:00:00.00)\n\n\ngbase> set wait_timeout=3;\nQuery OK, 0 rows affected (Elapsed: 00:00:00.00)\n\ngbase> show variables like 'wait_timeout';\n+---------------+-------+\n| Variable_name | Value |\n+---------------+-------+\n| wait_timeout | 3 |\n+---------------+-------+\n1 row in set (Elapsed: 00:00:00.00)\n\ngbase> show processlist;\nERROR 2006 (HY000): GBase server has gone away\nNo connection. Trying to reconnect...\nConnection id: 9\nCurrent database: testdb\n\n+----+-----------------+-----------+--------+---------+------+-----------------------------+------------------+\n| Id | User | Host | db | Command | Time | State | Info |\n+----+-----------------+-----------+--------+---------+------+-----------------------------+------------------+\n| 1 | event_scheduler | localhost | NULL | Daemon | 896 | Waiting for next activation | NULL |\n| 9 | root | localhost | testdb | Query | 0 | NULL | show processlist |\n+----+-----------------+-----------+--------+---------+------+-----------------------------+------------------+\n2 rows in set (Elapsed: 00:00:00.01)\n\ngbase>\n<\/code><\/pre>\n\n\n\n<\/span>\u5168\u5c40\u53c2\u6570global<\/span><\/h3>\n\n\n\n\u9700\u8981\u8bbe\u7f6e\u53e6\u4e00\u4e2ainteractive_timeout\uff0c\u5426\u5219\u4e0b\u6b21\u767b\u5f55\u65f6\uff0c\u53c2\u6570\u4e0d\u751f\u6548\u3002<\/p>\n\n\n\n
gbase> set global wait_timeout=60;\r\nQuery OK, 0 rows affected (Elapsed: 00:00:00.02)\r\n\r\ngbase> show variables like '%timeout%';\r\n+------------------------------------+---------+\r\n| Variable_name | Value |\r\n+------------------------------------+---------+\r\n| _gbase_crash_dump_timeout | 60 |\r\n| _gbase_net_alive_timeout | 92 |\r\n| connect_timeout | 1000000 |\r\n| delayed_insert_timeout | 300 |\r\n| gbase_export_write_timeout | 300 |\r\n| gbase_hdfs_client_timeout | 600 |\r\n| gbase_loader_read_timeout | 300 |\r\n| gcluster_async_connect_timeout | 120 |\r\n| gcluster_connect_net_read_timeout | 1000000 |\r\n| gcluster_connect_net_write_timeout | 1000000 |\r\n| gcluster_lock_timeout | 0 |\r\n| gcluster_send_client_data_timeout | 30 |\r\n| gcluster_task_status_poll_timeout | 6000 |\r\n| gcluster_wait_query_cancel_timeout | 200 |\r\n| interactive_timeout | 1000000 |\r\n| net_read_timeout | 1000000 |\r\n| net_write_timeout | 1000000 |\r\n| node_peer_connect_timeout | 5 |\r\n| node_peer_read_timeout | 0 |\r\n| node_peer_write_timeout | 0 |\r\n| slave_net_timeout | 3600 |\r\n| table_lock_wait_timeout | 50 |\r\n| wait_timeout | 1000000 |\r\n+------------------------------------+---------+\r\n23 rows in set (Elapsed: 00:00:00.00)\r\n\r\ngbase> ^CAborted\r\n[gbase@rh6-1 ~]$ gccli\r\n\r\nGBase client 8.6.2.43-R28 .125499. Copyright (c) 2004-2021, GBase. All Rights Reserved.\r\n\r\ngbase> show variables like '%timeout%';\r\n+------------------------------------+---------+\r\n| Variable_name | Value |\r\n+------------------------------------+---------+\r\n| _gbase_crash_dump_timeout | 60 |\r\n| _gbase_net_alive_timeout | 92 |\r\n| connect_timeout | 1000000 |\r\n| delayed_insert_timeout | 300 |\r\n| gbase_export_write_timeout | 300 |\r\n| gbase_hdfs_client_timeout | 600 |\r\n| gbase_loader_read_timeout | 300 |\r\n| gcluster_async_connect_timeout | 120 |\r\n| gcluster_connect_net_read_timeout | 1000000 |\r\n| gcluster_connect_net_write_timeout | 1000000 |\r\n| gcluster_lock_timeout | 0 |\r\n| gcluster_send_client_data_timeout | 30 |\r\n| gcluster_task_status_poll_timeout | 6000 |\r\n| gcluster_wait_query_cancel_timeout | 200 |\r\n| interactive_timeout | 1000000 |\r\n| net_read_timeout | 1000000 |\r\n| net_write_timeout | 1000000 |\r\n| node_peer_connect_timeout | 5 |\r\n| node_peer_read_timeout | 0 |\r\n| node_peer_write_timeout | 0 |\r\n| slave_net_timeout | 3600 |\r\n| table_lock_wait_timeout | 50 |\r\n| wait_timeout | 1000000 |\r\n+------------------------------------+---------+\r\n23 rows in set (Elapsed: 00:00:00.00)\r\n\r\ngbase> set global interactive_timeout=60;\r\nQuery OK, 0 rows affected (Elapsed: 00:00:00.01)\r\n\r\ngbase> ^CAborted\r\n[gbase@rh6-1 ~]$ gccli\r\n\r\nGBase client 8.6.2.43-R28 .125499. Copyright (c) 2004-2021, GBase. All Rights Reserved.\r\n\r\ngbase> show variables like '%timeout%';\r\n+------------------------------------+---------+\r\n| Variable_name | Value |\r\n+------------------------------------+---------+\r\n| _gbase_crash_dump_timeout | 60 |\r\n| _gbase_net_alive_timeout | 92 |\r\n| connect_timeout | 1000000 |\r\n| delayed_insert_timeout | 300 |\r\n| gbase_export_write_timeout | 300 |\r\n| gbase_hdfs_client_timeout | 600 |\r\n| gbase_loader_read_timeout | 300 |\r\n| gcluster_async_connect_timeout | 120 |\r\n| gcluster_connect_net_read_timeout | 1000000 |\r\n| gcluster_connect_net_write_timeout | 1000000 |\r\n| gcluster_lock_timeout | 0 |\r\n| gcluster_send_client_data_timeout | 30 |\r\n| gcluster_task_status_poll_timeout | 6000 |\r\n| gcluster_wait_query_cancel_timeout | 200 |\r\n| interactive_timeout | 60 |\r\n| net_read_timeout | 1000000 |\r\n| net_write_timeout | 1000000 |\r\n| node_peer_connect_timeout | 5 |\r\n| node_peer_read_timeout | 0 |\r\n| node_peer_write_timeout | 0 |\r\n| slave_net_timeout | 3600 |\r\n| table_lock_wait_timeout | 50 |\r\n| wait_timeout | 60 |\r\n+------------------------------------+---------+\r\n23 rows in set (Elapsed: 00:00:00.00)\r\n<\/code><\/pre>\n\n\n\n