{"id":2375,"date":"2018-03-13T12:37:02","date_gmt":"2018-03-13T04:37:02","guid":{"rendered":"https:\/\/www.webteach.tw\/?p=2375"},"modified":"2018-03-13T12:37:02","modified_gmt":"2018-03-13T04:37:02","slug":"wait_timeout","status":"publish","type":"post","link":"https:\/\/www.webteach.tw\/?p=2375","title":{"rendered":"[ MySQL ] – \u8a2d\u5b9a wait_timeout"},"content":{"rendered":"

\t\t\t\t\u8a2d\u5b9a wait_timeout
\n\u7531\u65bc wait_timeout \u9700\u8a2d\u7684\u6642\u9593\u592a\u9577\u4e86 8 \u5c0f\u6642\uff0c\u5982\u679c\u4f60\u958b\u555f\u8cc7\u6599\u9023\u7dda\u6c92\u6709\u624b\u52d5\u7684\u95dc\u6389\uff0c\u7cfb\u7d71\u6703\u904e\u4e868\u5c0f\u6642\u624d\u6703\u81ea\u52d5\u95dc\u6389\uff0c\u4eba\u5c11\u9084\u597d\u4eba\u4e00\u591a\u4f60\u7684\u8cc7\u6599\u5eab\u9023\u7dda\u6578\u99ac\u4e0a\u88ab\u5403\u5149\u5149\uff0c\u7db2\u7ad9\u7acb\u99ac\u639b\u6389\u3002
\n\u5148\u767b\u5165mysql \u770b\u4e00\u4e0btimeout\u6642\u9593
\nmysql> show variables like ‘%timeout%’;
\n+—————————–+———-+
\n| Variable_name\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | Value\u00a0\u00a0\u00a0 |
\n+—————————–+———-+
\n| connect_timeout\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | 10\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |
\n| delayed_insert_timeout\u00a0\u00a0\u00a0\u00a0\u00a0 | 300\u00a0\u00a0\u00a0\u00a0\u00a0 |
\n| innodb_flush_log_at_timeout | 1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |
\n| innodb_lock_wait_timeout\u00a0\u00a0\u00a0 | 50\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |
\n| innodb_rollback_on_timeout\u00a0 | OFF\u00a0\u00a0\u00a0\u00a0\u00a0 |
\n| interactive_timeout\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | 28800\u00a0\u00a0\u00a0 |
\n| lock_wait_timeout\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | 31536000 |
\n| net_read_timeout\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | 30\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |
\n| net_write_timeout\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | 60\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |
\n| rpl_stop_slave_timeout\u00a0\u00a0\u00a0\u00a0\u00a0 | 31536000 |
\n| slave_net_timeout\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | 3600\u00a0\u00a0\u00a0\u00a0 |
\n| wait_timeout\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | 28800\u00a0\u00a0\u00a0 |
\n+—————————–+———-+
\n wait_timeout\u00a028800\uff088\u5c0f\u6642\uff09
\n\u592a\u9577\u4e86\u6703\u5403\u6389mysql\u7684\u9023\u7dda\u6578
\n\u7de8\u8f2f\u8a2d\u5b9a\u6a94
\n\u6307\u4ee4\uff1asudo vi \/etc\/mysql\/my.cnf
\n\u5728\u6a94\u6848\u4e2d [mysqld] \u5167\u52a0\u4e0a
\nwait_timeout = 180
\ninteractive_timeout = 180
\n\u8a18\u4f4f\u9019\u5169\u500b\u53c3\u6578\u90fd\u8981\u8a2d\u5b9a\u624d\u53ef\u4ee5
\n\u6539\u5b8c\u5f8c\u518d\u4e0b\u4e00\u6b21
\nmysql> show variables like ‘%timeout%’;
\n+—————————–+———-+
\n| Variable_name\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | Value\u00a0\u00a0\u00a0 |
\n+—————————–+———-+
\n| connect_timeout\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | 10\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |
\n| delayed_insert_timeout\u00a0\u00a0\u00a0\u00a0\u00a0 | 300\u00a0\u00a0\u00a0\u00a0\u00a0 |
\n| innodb_flush_log_at_timeout | 1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |
\n| innodb_lock_wait_timeout\u00a0\u00a0\u00a0 | 50\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |
\n| innodb_rollback_on_timeout\u00a0 | OFF\u00a0\u00a0\u00a0\u00a0\u00a0 |
\n| interactive_timeout\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | 180 \u00a0\u00a0\u00a0 |
\n| lock_wait_timeout\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | 31536000 |
\n| net_read_timeout\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | 30\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |
\n| net_write_timeout\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | 60\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |
\n| rpl_stop_slave_timeout\u00a0\u00a0\u00a0\u00a0\u00a0 | 31536000 |
\n| slave_net_timeout\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | 3600\u00a0\u00a0\u00a0\u00a0 |
\n| wait_timeout\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | 180 \u00a0\u00a0\u00a0 |
\n+—————————–+———-+
\n\u6253\u5b8c\u6536\u5de5\uff5e\t\t<\/p>\n","protected":false},"excerpt":{"rendered":"

\u8a2d\u5b9a wait_timeout \u7531\u65bc wait_t…<\/p>\n","protected":false},"author":1,"featured_media":1866,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[32,34],"tags":[370,402,606],"class_list":["post-2375","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-linux","category-mysql","tag-linux","tag-mysql","tag-wait_timeout","hvn-theme-has-thumbnail"],"_links":{"self":[{"href":"https:\/\/www.webteach.tw\/index.php?rest_route=\/wp\/v2\/posts\/2375","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.webteach.tw\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.webteach.tw\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.webteach.tw\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.webteach.tw\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2375"}],"version-history":[{"count":1,"href":"https:\/\/www.webteach.tw\/index.php?rest_route=\/wp\/v2\/posts\/2375\/revisions"}],"predecessor-version":[{"id":5218,"href":"https:\/\/www.webteach.tw\/index.php?rest_route=\/wp\/v2\/posts\/2375\/revisions\/5218"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.webteach.tw\/index.php?rest_route=\/wp\/v2\/media\/1866"}],"wp:attachment":[{"href":"https:\/\/www.webteach.tw\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2375"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.webteach.tw\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2375"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.webteach.tw\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2375"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}