{"id":608,"date":"2019-11-05T09:58:48","date_gmt":"2019-11-05T00:58:48","guid":{"rendered":"https:\/\/www.itchefblog.com\/?p=608"},"modified":"2019-11-11T23:21:32","modified_gmt":"2019-11-11T14:21:32","slug":"mysql-or-mariadb-%eb%8b%a8%ec%9d%bc-%ec%bf%bc%eb%a6%ac-%ed%8c%a8%ed%82%b7-%ec%9a%a9%eb%9f%89-%ec%84%a4%ec%a0%95-max_allowed_packet","status":"publish","type":"post","link":"https:\/\/www.itchefblog.com\/?p=608","title":{"rendered":"MySQL (or MariaDB) \ub2e8\uc77c \ucffc\ub9ac \ud328\ud0b7 \uc6a9\ub7c9 \uc124\uc815 max_allowed_packet"},"content":{"rendered":"<p>DB\uc5d0 \ub370\uc774\ud130\ub97c \uc785\ub825 \ud639\uc740 \uc5c5\ub370\uc774\ud2b8 \uc2dc \ub370\uc774\ud130\uac00 \uc544~~~\uc8fc~~~ \ud070 \uacbd\uc6b0 \uc815\uc0c1\uc801\uc73c\ub85c \ucffc\ub9ac\uac00 \uc5c5\ub370\uc774\ud2b8 \ub418\uc9c0 \uc54a\ub294\ub2e4.<br \/>\n\uc774\uc720\ub294 DB \uc124\uc815\uc5d0\uc11c \ucffc\ub9ac \uc2dc \uc804\uc1a1 \uac00\ub2a5\ud55c \ucd5c\ub300 \ud328\ud0b7\uc758 \ud06c\uae30\ub97c \ub118\uc5b4\uc130\uae30 \ub54c\ubb38.<br \/>\n\uc774\ub7f4 \ub54c \ub2e4\uc74c\uacfc \uac19\uc740 \ucffc\ub9ac\ub97c \ub0a0\ub824\uc8fc\uba74 \uc6d0\ud65c\ud558\uac8c \ub370\uc774\ud130 \uc785\ub825 \ubc0f \uc5c5\ub370\uc774\ud2b8\ub97c \ud560 \uc218 \uc788\ub2e4.<\/p>\n<pre class=\"brush: sql; title: ; notranslate\" title=\"\">\r\nset GLOBAL max_allowed_packet = 1024 * 1024 * \uc6d0\ud558\ub294\uc6a9\ub7c9(MB)\r\n<\/pre>\n<p>\uc608\ub97c\ub4e4\uc5b4 200MB\ub97c \uc804\uc1a1 \uac00\ub2a5\ud558\uac8c \ud558\uace0\uc790 \ub2e8\ub2e4\uba74 1024 * 1024 * 200 \uacfc \uac19\uc774 \ucffc\ub9ac\ud558\uba74 \ub41c\ub2e4.<\/p>\n<p>\uc704 \ucffc\ub9ac\ub294 DB\ub97c \uc7ac\uc2dc\uc791\ud558\uba74 \ucd08\uae30\ud654\ub418\ubbc0\ub85c \uc601\uad6c\uc801\uc73c\ub85c \ubc18\uc601\ud558\uace0\uc790 \ud55c\ub2e4\uba74 my.conf\uc5d0 \ucd94\uac00\ud574\uc8fc\uba74 \ub41c\ub2e4.<br \/>\nmy.conf\uc5d0 \ucd94\uac00\uc2dc\uc5d0\ub294 1024 * 1024\ub97c \ube7c\uace0 200\ub9cc \uc785\ub825\ud574\uc8fc\uba74 \ub41c\ub2e4.<\/p>\n<p>\ub108\ubb34 \ub192\uc740 \uac12\uc740 \uc138\uc158\ub2f9 \uba54\ubaa8\ub9ac \uc0ac\uc6a9\ub7c9\uc744 \ub9ce\uc774 \uc18c\ubaa8\ud558\ubbc0\ub85c \uc6b4\uc601\uc5d0 \uc801\uc808\ud55c \uac12\uc744 \ucc3e\ub294 \uac83\uc774 \uad00\uac74.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>DB\uc5d0 \ub370\uc774\ud130\ub97c \uc785\ub825 \ud639\uc740 \uc5c5\ub370\uc774\ud2b8 \uc2dc \ub370\uc774\ud130\uac00 \uc544~~~\uc8fc~~~ \ud070 \uacbd\uc6b0 \uc815\uc0c1\uc801\uc73c\ub85c \ucffc\ub9ac\uac00 \uc5c5\ub370\uc774\ud2b8 \ub418\uc9c0 \uc54a\ub294\ub2e4. \uc774\uc720\ub294 DB \uc124\uc815\uc5d0\uc11c \ucffc\ub9ac \uc2dc \uc804\uc1a1 \uac00\ub2a5\ud55c \ucd5c\ub300 \ud328\ud0b7\uc758 \ud06c\uae30\ub97c \ub118\uc5b4\uc130\uae30 \ub54c\ubb38. \uc774\ub7f4 \ub54c \ub2e4\uc74c\uacfc \uac19\uc740 \ucffc\ub9ac\ub97c \ub0a0\ub824\uc8fc\uba74 \uc6d0\ud65c\ud558\uac8c \ub370\uc774\ud130 \uc785\ub825 \ubc0f \uc5c5\ub370\uc774\ud2b8\ub97c \ud560 \uc218 \uc788\ub2e4. \uc608\ub97c\ub4e4\uc5b4 200MB\ub97c \uc804\uc1a1 \uac00\ub2a5\ud558\uac8c \ud558\uace0\uc790 \ub2e8\ub2e4\uba74 1024 * 1024 * 200 \uacfc \uac19\uc774 \ucffc\ub9ac\ud558\uba74 &hellip; <\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[20,19],"tags":[362,363,364],"_links":{"self":[{"href":"https:\/\/www.itchefblog.com\/index.php?rest_route=\/wp\/v2\/posts\/608"}],"collection":[{"href":"https:\/\/www.itchefblog.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.itchefblog.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.itchefblog.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.itchefblog.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=608"}],"version-history":[{"count":4,"href":"https:\/\/www.itchefblog.com\/index.php?rest_route=\/wp\/v2\/posts\/608\/revisions"}],"predecessor-version":[{"id":667,"href":"https:\/\/www.itchefblog.com\/index.php?rest_route=\/wp\/v2\/posts\/608\/revisions\/667"}],"wp:attachment":[{"href":"https:\/\/www.itchefblog.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=608"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.itchefblog.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=608"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.itchefblog.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=608"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}