{"id":1309,"date":"2023-12-26T18:54:49","date_gmt":"2023-12-26T10:54:49","guid":{"rendered":"https:\/\/nas1.xyz1943.net\/wordpress\/?p=1309"},"modified":"2023-12-26T18:54:49","modified_gmt":"2023-12-26T10:54:49","slug":"synology-nas-%e4%b8%8a%e8%aa%bf%e6%95%b4-mariadb","status":"publish","type":"post","link":"https:\/\/nas1.xyz1943.net\/wordpress\/2023\/12\/26\/synology-nas-%e4%b8%8a%e8%aa%bf%e6%95%b4-mariadb\/","title":{"rendered":"Synology NAS \u4e0a\u8abf\u6574 MariaDB"},"content":{"rendered":"<p>\u5229\u7528 phpMyAdmin<\/p>\n<p>\u67e5\u8a62<br \/>\nshow variables like \u2018max_allowed_packet\u2019;<\/p>\n<p>\u6539256M<br \/>\nset global max_allowed_packet=268435456;<\/p>\n<p>\u9047\u5230\u7121\u6cd5\u4fee\u6539 open_files_limit or max_allowed_packet \u6642<br \/>\n\u5fc5\u9808\u9032\u5165NAS\u7684SSH\u91dd\u5c0dMariaDB\u7684\u8cc7\u6599\u6a94\u6848\u65b0\u589e\u4e00\u4e9b\u503c<br \/>\n\u91dd\u5c0dMariaDB\u7684\u8cc7\u6599\uff0c\u8a2d\u5b9a\u6a94\u6848\u65b0\u589e\u6d41\u7a0b\u5982\u4e0b\uff1a<br \/>\n1. sudo -i \u9032\u5165Root\u6b0a\u9650<br \/>\n2. cd \/var\/packages\/MariaDB10\/etc \u9032\u5165\u6b64\u76ee\u9304\u4e0b<br \/>\n3. ls \u78ba\u8a8d\u662f\u5426\u6709my.cnf\u6a94\u6848<br \/>\n4. \u82e5\u6c92\u6709\u6b64\u6a94\u6848\u8acb\u65b0\u589e\u4e00\u7b46 touch my.cnf<br \/>\n5. \u65b0\u589e\u6b64\u6a94\u6848\u5f8c\u7de8\u8f2f\u8a72\u6a94\u6848 vi my.cnf<br \/>\n6. \u7de8\u8f2f\u5167\u5bb9\u5982\u4e0b:(\u8a2d\u5b9a\u503c\u4f9d\u7167MA\u4e0a\u8981\u6c42)<\/p>\n<p>[mysqld]<br \/>\nopen_files_limit = 10000<br \/>\nmax_allowed_packet = 655360000<\/p>\n<p>\u8a2d\u5b9a\u597d\u53c3\u6578\u5f8c\u8acb\u4e0b\u6307\u4ee4\u91cd\u555fMy SQL\u670d\u52d9<br \/>\n\/usr\/syno\/bin\/synopkg restart MariaDB10<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u5229\u7528 phpMyAdmin \u67e5\u8a62 show variables like \u2018ma &hellip; <a href=\"https:\/\/nas1.xyz1943.net\/wordpress\/2023\/12\/26\/synology-nas-%e4%b8%8a%e8%aa%bf%e6%95%b4-mariadb\/\">\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\/1309"}],"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=1309"}],"version-history":[{"count":1,"href":"https:\/\/nas1.xyz1943.net\/wordpress\/wp-json\/wp\/v2\/posts\/1309\/revisions"}],"predecessor-version":[{"id":1310,"href":"https:\/\/nas1.xyz1943.net\/wordpress\/wp-json\/wp\/v2\/posts\/1309\/revisions\/1310"}],"wp:attachment":[{"href":"https:\/\/nas1.xyz1943.net\/wordpress\/wp-json\/wp\/v2\/media?parent=1309"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/nas1.xyz1943.net\/wordpress\/wp-json\/wp\/v2\/categories?post=1309"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/nas1.xyz1943.net\/wordpress\/wp-json\/wp\/v2\/tags?post=1309"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}