{"id":1353,"date":"2021-04-01T17:28:39","date_gmt":"2021-04-01T09:28:39","guid":{"rendered":"https:\/\/www.shsh.ylc.edu.tw\/~taichis\/wp\/?p=1353"},"modified":"2021-04-01T17:28:39","modified_gmt":"2021-04-01T09:28:39","slug":"mysql%e9%82%84%e5%8e%9f%e8%b3%87%e6%96%99%e5%ba%ab%e5%a4%b1%e6%95%97","status":"publish","type":"post","link":"https:\/\/www.shsh.ylc.edu.tw\/~taichis\/wp\/?p=1353","title":{"rendered":"MySQL\u9084\u539f\u8cc7\u6599\u5eab\u5931\u6557"},"content":{"rendered":"<p>\u96a8\u8457\u7db2\u7ad9\u8cc7\u6599\u8d8a\u4f86\u8d8a\u591a\uff0c\u8cc7\u6599\u5eab\u4e5f\u6703\u8d8a\u4f86\u8d8a\u80a5\uff0c\u76f4\u5230\u6709\u4e00\u5929\uff0c\u4f60\u5728\u9084\u539f\u820a\u8cc7\u6599\u7684\u6642\u5019\u51fa\u73fe\u4ee5\u4e0b\u7684\u932f\u8aa4\uff1a<\/p>\n<p>ERROR 2013 (HY000) at line 209: Lost connection to MySQL server during query<\/p>\n<p>\u89e3\u6c7a\u7684\u65b9\u6cd5\u5982\u4e0b\uff1a<\/p>\n<p>\u66ab\u6642\u6027\u7684\u89e3\u6cd5 <\/p>\n<p><code>mysql ><br \/>\nset global max_allowed_packet=33554432;<\/code><\/p>\n<p>\u6c38\u4e45\u6027\u7684\u89e3\u6cd5\uff0c\u4fee\u6539 my.cnf \u7684 [mysqld] \u5340\u6bb5<br \/>\n<code>[mysqld]<br \/>\nmax_allowed_packet=32M<\/code><\/p>\n<p>\u4e26\u4e14\u91cd\u555fmysql<br \/>\n<code>service mysql restart<\/code><\/p>\n<div class=\"fcbkbttn_buttons_block\" id=\"fcbkbttn_left\"><div class=\"fcbkbttn_like \"><fb:like href=\"https:\/\/www.shsh.ylc.edu.tw\/~taichis\/wp\/?p=1353\" action=\"like\" colorscheme=\"light\" layout=\"standard\" show-faces='false' width=\"450px\" size=\"small\"><\/fb:like><\/div><\/div>","protected":false},"excerpt":{"rendered":"<p>\u96a8\u8457\u7db2\u7ad9\u8cc7\u6599\u8d8a\u4f86\u8d8a\u591a\uff0c\u8cc7\u6599\u5eab\u4e5f\u6703\u8d8a\u4f86\u8d8a\u80a5\uff0c\u76f4\u5230\u6709\u4e00\u5929\uff0c\u4f60\u5728\u9084\u539f\u820a\u8cc7\u6599\u7684\u6642\u5019\u51fa\u73fe\u4ee5 &hellip;<\/p>\n<p class=\"read-more\"> <a class=\"more-link\" href=\"https:\/\/www.shsh.ylc.edu.tw\/~taichis\/wp\/?p=1353\"> <span class=\"screen-reader-text\">MySQL\u9084\u539f\u8cc7\u6599\u5eab\u5931\u6557<\/span> \u95b1\u8b80\u66f4\u591a &raquo;<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[18,3],"tags":[],"_links":{"self":[{"href":"https:\/\/www.shsh.ylc.edu.tw\/~taichis\/wp\/index.php?rest_route=\/wp\/v2\/posts\/1353"}],"collection":[{"href":"https:\/\/www.shsh.ylc.edu.tw\/~taichis\/wp\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.shsh.ylc.edu.tw\/~taichis\/wp\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.shsh.ylc.edu.tw\/~taichis\/wp\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.shsh.ylc.edu.tw\/~taichis\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1353"}],"version-history":[{"count":1,"href":"https:\/\/www.shsh.ylc.edu.tw\/~taichis\/wp\/index.php?rest_route=\/wp\/v2\/posts\/1353\/revisions"}],"predecessor-version":[{"id":1354,"href":"https:\/\/www.shsh.ylc.edu.tw\/~taichis\/wp\/index.php?rest_route=\/wp\/v2\/posts\/1353\/revisions\/1354"}],"wp:attachment":[{"href":"https:\/\/www.shsh.ylc.edu.tw\/~taichis\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1353"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.shsh.ylc.edu.tw\/~taichis\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1353"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.shsh.ylc.edu.tw\/~taichis\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1353"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}