{"id":1825,"date":"2018-10-08T17:37:22","date_gmt":"2018-10-08T09:37:22","guid":{"rendered":"http:\/\/ufqi.com\/blog\/?p=1825"},"modified":"2018-10-08T17:37:22","modified_gmt":"2018-10-08T09:37:22","slug":"mysqld%e8%bf%90%e8%a1%8c%e6%97%b6%e5%8f%82%e6%95%b0%e9%85%8d%e7%bd%ae%e6%96%87%e4%bb%b6%e4%b8%8e%e5%91%bd%e4%bb%a4%e8%a1%8c%e6%9c%89%e4%bd%95%e5%bc%82%e5%90%8c%ef%bc%9f","status":"publish","type":"post","link":"https:\/\/ufqi.com\/blog\/mysqld%e8%bf%90%e8%a1%8c%e6%97%b6%e5%8f%82%e6%95%b0%e9%85%8d%e7%bd%ae%e6%96%87%e4%bb%b6%e4%b8%8e%e5%91%bd%e4%bb%a4%e8%a1%8c%e6%9c%89%e4%bd%95%e5%bc%82%e5%90%8c%ef%bc%9f\/","title":{"rendered":"mysqld\u8fd0\u884c\u65f6\u53c2\u6570\u914d\u7f6e\u6587\u4ef6\u4e0e\u547d\u4ee4\u884c\u6709\u4f55\u5f02\u540c\uff1f"},"content":{"rendered":"

1. \u5728 my.cnf \u4e2d\u914d\u7f6e\uff1a
interactive_timeout=300\u00a0
wait_timeout=300
\u91cd\u542f mysqld, \u901a\u8fc7 show vairables
mysql> show variables like ‘%timeout%’;
+—————————–+———-+ | Variable_name | Value | +—————————–+———-+
| connect_timeout | 10 |
| delayed_insert_timeout | 300 |
| have_statement_timeout | YES |
| innodb_flush_log_at_timeout | 1 |
| innodb_lock_wait_timeout | 50 |
| innodb_rollback_on_timeout | OFF |
| interactive_timeout | 300 |
| lock_wait_timeout | 31536000 |
| net_read_timeout | 30 |
| net_write_timeout | 60 |
| rpl_stop_slave_timeout | 31536000 |
| slave_net_timeout | 60 |
| wait_timeout | 300 |
+—————————–+———-+
13 rows in set (0.00 sec)
\u80fd\u770b\u5230\u5df2\u7ecf\u751f\u6548\uff0c\u4f46 mysqld \u5e76\u4e0d\u4f1a\u5728 300\u65f6\u6740\u6389 sleep \u8d85\u8fc7 300\u7684\u8fde\u63a5\u3002 <\/p>\n

2. \u5728 mysqld \u7684\u5176\u4e2d\u811a\u672c mysql.server \u4e2d\u589e\u52a0\uff1a
other_args=”$other_args –explicit_defaults_for_timestamp –wait_timeout=300 –interactive_timeout=300″;
\u91cd\u542f mysqld \u540e\uff0c \u901a\u8fc7 show variables \u770b\uff0c \u53c2\u6570\u65e0\u53d8\u5316\uff0c \u4f46\u5f53\u67d0\u4e2a\u67e5\u8be2\u8fde\u63a5\u8d85\u8fc7 300 \u65f6\u4f1a\u88ab\u5f3a\u884c\u5173\u95ed\u3002<\/p>\n

\u4e3a\u4f55\uff1f \u914d\u7f6e\u6587\u4ef6\u4e2d\u7684\u6307\u4ee4\u4e0d\u751f\u6548\u800c\u547d\u4ee4\u884c\u53c2\u6570\u7684\u6307\u4ee4\u5219\u751f\u6548\uff1f<\/p>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

1. \u5728 my.cnf \u4e2d\u914d\u7f6e\uff1ainteractive_timeout=300\u00a0 … \u7ee7\u7eed\u9605\u8bfb →<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[7],"tags":[],"_links":{"self":[{"href":"https:\/\/ufqi.com\/blog\/wp-json\/wp\/v2\/posts\/1825"}],"collection":[{"href":"https:\/\/ufqi.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ufqi.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ufqi.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/ufqi.com\/blog\/wp-json\/wp\/v2\/comments?post=1825"}],"version-history":[{"count":3,"href":"https:\/\/ufqi.com\/blog\/wp-json\/wp\/v2\/posts\/1825\/revisions"}],"predecessor-version":[{"id":1881,"href":"https:\/\/ufqi.com\/blog\/wp-json\/wp\/v2\/posts\/1825\/revisions\/1881"}],"wp:attachment":[{"href":"https:\/\/ufqi.com\/blog\/wp-json\/wp\/v2\/media?parent=1825"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ufqi.com\/blog\/wp-json\/wp\/v2\/categories?post=1825"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ufqi.com\/blog\/wp-json\/wp\/v2\/tags?post=1825"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}