{"id":6588,"date":"2021-01-27T13:41:23","date_gmt":"2021-01-27T05:41:23","guid":{"rendered":"https:\/\/ailog.tw\/lifelog\/?p=6588"},"modified":"2021-01-27T13:41:23","modified_gmt":"2021-01-27T05:41:23","slug":"mysql-off-log","status":"publish","type":"post","link":"https:\/\/ailog.tw\/lifelog\/2021\/01\/27\/mysql-off-log\/","title":{"rendered":"MariaDB and MySQL\u95dc\u9589\u4e8c\u9032\u4f4d\u8a18\u9304\u6a94\u65b9\u6cd5"},"content":{"rendered":"<p>\u7576\u7cfb\u7d71\u6709\u5b89\u88ddMySQL\u6216MariaDB\u8cc7\u6599\u5eab\u7cfb\u7d71\u6642\uff0c\u65e5\u5b50\u4e00\u4e45\u4e86\u5c31\u6703\u767c\u73fe\u8cc7\u6599\u5eab\u7684log\u6a94\u6848\u9084\u4f54\u64da\u4e0d\u5c11\u7a7a\u9593<!--more-->\uff0c\u5982\u679c\u7cfb\u7d71\u4e26\u975e\u662f\u91cd\u8981\u7cfb\u7d71\uff0c\u4e14\u6c92\u63a1\u7528\u8cc7\u6599\u5eab\u540c\u6b65\u7684\u6a5f\u5236\uff0c\u5176\u5be6\u662f\u53ef\u4ee5\u5c07\u8cc7\u6599\u5eab\u7684\u4e8c\u9032\u4f4d\u8a18\u9304\u6a94\u95dc\u9589\uff0c\u4f86\u9054\u5230\u7bc0\u7701\u786c\u789f\u7a7a\u9593\u7684\u76ee\u7684\u3002<\/p>\n<p><span style=\"font-size: 14pt;\"><strong>MySQL\u8cc7\u6599\u5eab<br \/>\n<\/strong><\/span>(1)\u3001\u7de8\u8f2f\u8a2d\u5b9a\u6a94\u6848<br \/>\n\u6307\u4ee4\uff1a<br \/>\nvi \/etc\/my.cnf.d\/mysql-server.cnf<br \/>\n\u6216<br \/>\nvi \/etc\/my.cnf.d\/server.cnf<br \/>\n\u5728\u300c <span style=\"color: #ff0000;\">[mysqld]<\/span> \u300d\u4e0b\u65b9\u65b0\u589e\u300c<span style=\"color: #ff0000;\">skip-log-bin<\/span>\u300d<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-6591 size-full\" src=\"https:\/\/ailog.tw\/lifelog\/wp-content\/uploads\/2021\/01\/mysql-01.jpg\" alt=\"\" width=\"482\" height=\"76\" srcset=\"https:\/\/ailog.tw\/lifelog\/wp-content\/uploads\/2021\/01\/mysql-01.jpg 482w, https:\/\/ailog.tw\/lifelog\/wp-content\/uploads\/2021\/01\/mysql-01-300x47.jpg 300w\" sizes=\"auto, (max-width: 482px) 100vw, 482px\" \/><\/p>\n<p>(2)\u3001\u91cd\u65b0\u555f\u52d5\u670d\u52d9<br \/>\n\u6307\u4ee4\uff1a<br \/>\nservice mysqld restart<\/p>\n<p>(3)\u3001\u522a\u9664\u820a\u6709log\u6a94\u6848<br \/>\n\u6307\u4ee4\uff1a<br \/>\nrm -rf \/var\/log\/mysql\/*.*<\/p>\n<p><span style=\"font-size: 14pt;\"><strong>MariaDB\u8cc7\u6599\u5eab<br \/>\n<\/strong><span style=\"font-size: 12pt;\">(1)\u3001\u7de8\u8f2f\u8a2d\u5b9a\u6a94\u6848<\/span><\/span><br \/>\n\u6307\u4ee4\uff1a<br \/>\nvi \/etc\/mysql\/conf.d\/mariadb.cnf<br \/>\n\u5728\u300c <span style=\"color: #ff0000;\">[mysqld]<\/span> \u300d\u4e0b\u65b9\u65b0\u589e\u300c<span style=\"color: #ff0000;\">skip-log-bin<\/span>\u300d<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-6592 size-full\" src=\"https:\/\/ailog.tw\/lifelog\/wp-content\/uploads\/2021\/01\/mysql-02.jpg\" alt=\"\" width=\"365\" height=\"209\" srcset=\"https:\/\/ailog.tw\/lifelog\/wp-content\/uploads\/2021\/01\/mysql-02.jpg 365w, https:\/\/ailog.tw\/lifelog\/wp-content\/uploads\/2021\/01\/mysql-02-300x172.jpg 300w\" sizes=\"auto, (max-width: 365px) 100vw, 365px\" \/><\/p>\n<p>(2)\u3001\u91cd\u65b0\u555f\u52d5\u670d\u52d9<br \/>\n\u6307\u4ee4\uff1a<br \/>\nsystemctl restart mariadb<\/p>\n<p>(3)\u3001\u522a\u9664\u820a\u6709log\u6a94\u6848<br \/>\n\u6307\u4ee4\uff1a<br \/>\nrm -rf var\/log\/mariadb\/*.*<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u7576\u7cfb\u7d71\u6709\u5b89\u88ddMySQL\u6216MariaDB\u8cc7\u6599\u5eab\u7cfb\u7d71\u6642\uff0c\u65e5\u5b50\u4e00\u4e45\u4e86\u5c31\u6703\u767c\u73fe\u8cc7\u6599\u5eab\u7684log\u6a94\u6848\u9084\u4f54\u64da\u4e0d\u5c11\u7a7a\u9593<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4,387],"tags":[2937,2936,2932,2940,2933,2934,2938,2939,2935],"class_list":["post-6588","post","type-post","status-publish","format-standard","hentry","category-itinfo","category-database","tag-binary-log","tag-disable","tag-mariadb","tag-mariadb-and-mysql","tag-mysql","tag-off","tag-2938","tag-2939","tag-2935"],"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/ailog.tw\/lifelog\/wp-json\/wp\/v2\/posts\/6588","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ailog.tw\/lifelog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ailog.tw\/lifelog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ailog.tw\/lifelog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ailog.tw\/lifelog\/wp-json\/wp\/v2\/comments?post=6588"}],"version-history":[{"count":6,"href":"https:\/\/ailog.tw\/lifelog\/wp-json\/wp\/v2\/posts\/6588\/revisions"}],"predecessor-version":[{"id":6596,"href":"https:\/\/ailog.tw\/lifelog\/wp-json\/wp\/v2\/posts\/6588\/revisions\/6596"}],"wp:attachment":[{"href":"https:\/\/ailog.tw\/lifelog\/wp-json\/wp\/v2\/media?parent=6588"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ailog.tw\/lifelog\/wp-json\/wp\/v2\/categories?post=6588"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ailog.tw\/lifelog\/wp-json\/wp\/v2\/tags?post=6588"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}