{"id":770,"date":"2018-11-05T20:39:08","date_gmt":"2018-11-05T12:39:08","guid":{"rendered":"http:\/\/nas1.xyz1943.net\/wordpress\/?p=770"},"modified":"2018-11-05T20:39:08","modified_gmt":"2018-11-05T12:39:08","slug":"%e8%ab%8b%e5%95%8f%e6%98%af%e5%90%a6%e5%8f%af%e4%bb%a5%e5%9c%a8-synology-nas-%e4%b8%8a%e8%87%aa%e8%a8%82-mariadb-%e7%9a%84%e8%a8%ad%e5%ae%9a%ef%bc%9f-%e7%be%a4%e6%9a%89%e7%a7%91%e6%8a%80-synology-in","status":"publish","type":"post","link":"https:\/\/nas1.xyz1943.net\/wordpress\/2018\/11\/05\/%e8%ab%8b%e5%95%8f%e6%98%af%e5%90%a6%e5%8f%af%e4%bb%a5%e5%9c%a8-synology-nas-%e4%b8%8a%e8%87%aa%e8%a8%82-mariadb-%e7%9a%84%e8%a8%ad%e5%ae%9a%ef%bc%9f-%e7%be%a4%e6%9a%89%e7%a7%91%e6%8a%80-synology-in\/","title":{"rendered":"\u8acb\u554f\u662f\u5426\u53ef\u4ee5\u5728 Synology NAS \u4e0a\u81ea\u8a02 MariaDB \u7684\u8a2d\u5b9a\uff1f | \u7fa4\u6689\u79d1\u6280 Synology Inc."},"content":{"rendered":"<blockquote><p>\u8acb\u554f\u662f\u5426\u53ef\u4ee5\u5728 Synology NAS \u4e0a\u81ea\u8a02 MariaDB \u7684\u8a2d\u5b9a\uff1f\u5728 DSM 5.0 \u6216\u4ee5\u4e0a\u7248\u672c\u7ba1\u7406\u8cc7\u6599\u5eab\u6642\uff0cMariaDB \u5957\u4ef6\u7684\u9810\u8a2d\u8a2d\u5b9a\u61c9\u5df2\u80fd\u6eff\u8db3\u5927\u591a\u6578\u4f7f\u7528\u8005\u7684\u9700\u6c42\u3002\u7136\u800c\uff0c\u5982\u6709\u9700\u8981\uff0c\u60a8\u4e5f\u53ef\u4ee5\u624b\u52d5\u8b8a\u66f4 MariaDB \u7684\u8a2d\u5b9a\u4f86\u7b26\u5408\u60a8\u7279\u5b9a\u7684\u9700\u6c42\u3002\u82e5\u8981\u9019\u6a23\u505a\uff0c\u8acb\u4f9d\u7167\u4e0b\u5217\u6b65\u9a5f\u64cd\u4f5c\uff1a \u5efa\u7acb\u4e00\u500b\u540d\u70ba my.cnf \u7684\u8a2d\u5b9a\u6a94\u3002\u6b64\u6a94\u6848\u61c9\u5305\u542b\u4f60\u60f3\u8981\u5728 MariaDB \u4e0a\u8b8a\u66f4\u7684\u8a2d\u5b9a (\u8acb\u898b\u4e0b\u5217\u7bc4\u4f8b)\u3002 \u5728\u60a8\u7684 Synology NAS \u4e0a\uff0c\u5c07 my.cnf \u6a94\u6848\u653e\u65bc\u4ee5\u4e0b\u8def\u5f91\u4e2d\uff1a\/var\/packages\/MariaDB\/etc \u5c07 Synology NAS \u91cd\u65b0\u958b\u6a5f\uff0c\u6216\u57f7\u884c \/usr\/syno\/bin\/synopkg restart MariaDB \u4f86\u5957\u7528\u65b0\u8a2d\u5b9a\u3002\u66f4\u65b0 MariaDB \u5957\u4ef6\u6216\u91cd\u65b0\u555f\u52d5 DSM \u6642\uff0c\u65b0\u8a2d\u5b9a\u4ecd\u6703\u88ab\u4fdd\u7559\u4e0b\u4f86\u3002\u4f8b\u5982\uff0c\u82e5\u8981\u589e\u52a0 MariaDB \u4e0a\u5916\u4f86\u6a94\u6848\u7684\u5927\u5c0f\u4e0a\u9650\uff0c\u60a8\u53ef\u4ee5\u5728 my.cnf \u8a2d\u5b9a\u6a94\u4e2d\u52a0\u5165\u4ee5\u4e0b\u9019\u884c\u6587\u5b57\uff1a[mysqld]max_allowed_packet = 1073741824<\/p><\/blockquote>\n<p>\u5167\u5bb9\u51fa\u8655: <em><a href=\"https:\/\/www.synology.com\/zh-tw\/knowledgebase\/DSM\/tutorial\/Application\/Can_MariaDB_settings_be_customized_on_Synology_NAS\">\u8acb\u554f\u662f\u5426\u53ef\u4ee5\u5728 Synology NAS \u4e0a\u81ea\u8a02 MariaDB \u7684\u8a2d\u5b9a\uff1f | \u7fa4\u6689\u79d1\u6280 Synology Inc.<\/a><\/em><\/p>\n<pre>NAS \u53ef\u80fd\u8981\u91cd\u555f\uff0c\u503c\u624d\u6703\u904b\u4f5c\n\n\nmysql&gt; show global variables like 'max_allowed_packet';\n+--------------------+-----------+\n| Variable_name      | Value     |\n+--------------------+-----------+\n| max_allowed_packet | 167772160 |\n+--------------------+-----------+\n1 row in set (0.00 sec)\n\nmysql&gt;\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>\u8acb\u554f\u662f\u5426\u53ef\u4ee5\u5728 Synology NAS \u4e0a\u81ea\u8a02 MariaDB \u7684\u8a2d\u5b9a\uff1f\u5728 D &hellip; <a href=\"https:\/\/nas1.xyz1943.net\/wordpress\/2018\/11\/05\/%e8%ab%8b%e5%95%8f%e6%98%af%e5%90%a6%e5%8f%af%e4%bb%a5%e5%9c%a8-synology-nas-%e4%b8%8a%e8%87%aa%e8%a8%82-mariadb-%e7%9a%84%e8%a8%ad%e5%ae%9a%ef%bc%9f-%e7%be%a4%e6%9a%89%e7%a7%91%e6%8a%80-synology-in\/\">\u95b1\u8b80\u5168\u6587 <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[5],"tags":[],"_links":{"self":[{"href":"https:\/\/nas1.xyz1943.net\/wordpress\/wp-json\/wp\/v2\/posts\/770"}],"collection":[{"href":"https:\/\/nas1.xyz1943.net\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/nas1.xyz1943.net\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/nas1.xyz1943.net\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/nas1.xyz1943.net\/wordpress\/wp-json\/wp\/v2\/comments?post=770"}],"version-history":[{"count":0,"href":"https:\/\/nas1.xyz1943.net\/wordpress\/wp-json\/wp\/v2\/posts\/770\/revisions"}],"wp:attachment":[{"href":"https:\/\/nas1.xyz1943.net\/wordpress\/wp-json\/wp\/v2\/media?parent=770"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/nas1.xyz1943.net\/wordpress\/wp-json\/wp\/v2\/categories?post=770"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/nas1.xyz1943.net\/wordpress\/wp-json\/wp\/v2\/tags?post=770"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}