{"id":655,"title":"\u5982\u4f55\u6e05\u7406mysql\u7684binlog\u51cf\u5c11\u5bf9\u78c1\u76d8\u7a7a\u95f4\u7684\u5360\u7528","good":0,"bad":0,"hit":337,"created_at":"2025-02-02 18:19:16","content":"<p><span style=\"text-wrap-mode: nowrap;\">\u6709\u4e9b\u5c0f\u9879\u76ee\uff0c\u78c1\u76d8\u7a7a\u95f4\u4e0d\u5927\uff0c\u5982\u679c\u6709\u9ad8\u9891\u7684\u8bfb\u5199\u64cd\u4f5c\uff0c\u6bd4\u5982\uff1a\u5b9a\u65f6\u4efb\u52a1\u7b49\uff0c\u53ef\u4ee5\u4f1a\u4ea7\u751f\u5927\u91cf\u7684binlog\u65e5\u5fd7\uff0c\u53ef\u80fd\u5bfc\u81f4\u78c1\u76d8\u7a7a\u95f4\u88ab\u5360\u6ee1\uff1b<\/span><\/p><p><span style=\"text-wrap-mode: nowrap;\">\u53ef\u4ee5\u624b\u52a8\u6e05\u7406\uff0c\u6216\u5f7b\u5e95\u5173\u95ed<\/span><\/p><p><span style=\"text-wrap-mode: nowrap;\"><br\/><\/span><\/p><p><span style=\"text-wrap-mode: nowrap;\">binlog\u5728\u8fd9\u4e2a\u76ee\u5f55\u4e0b<\/span><\/p><p><span style=\"text-wrap-mode: nowrap;\">\/www\/server\/data<\/span><\/p><p><span style=\"text-wrap-mode: nowrap;\">\u4ee5\u4e0b\u547d\u4ee4\u53ea\u4fdd\u7559mysql-bin.000034\u5176\u5b83\u7684\u90fd\u6e05\u9664<\/span><\/p><p><span style=\"text-wrap-mode: nowrap;\">PURGE BINARY LOGS TO&#39;mysql-bin.000034&#39;;<\/span><\/p><p><span style=\"text-wrap-mode: nowrap;\"><br\/><\/span><\/p><p><span style=\"text-wrap-mode: nowrap;\">\u5982\u679c\u8981\u901a\u8fc7\u914d\u7f6e\u6587\u4ef6\u6c38\u4e45\u505c\u6b62 MySQL \u7684 binlog \u8bb0\u5f55\uff0c\u53ef\u4ee5\u6309\u7167\u4ee5\u4e0b\u6b65\u9aa4\u8fdb\u884c\u64cd\u4f5c\uff1a<\/span><\/p><p><span style=\"text-wrap-mode: nowrap;\">\u627e\u5230 MySQL \u7684\u914d\u7f6e\u6587\u4ef6\uff0c\u901a\u5e38\u662fmy.cnf\uff08Linux \u548c macOS\uff09\u6216my.ini\uff08Windows\uff09\u3002<\/span><\/p><p><span style=\"text-wrap-mode: nowrap;\">\u6253\u5f00\u914d\u7f6e\u6587\u4ef6\uff0c\u5728\u6587\u4ef6\u4e2d\u627e\u5230\u4ee5\u4e0b\u884c\uff1a<\/span><\/p><p><span style=\"text-wrap-mode: nowrap;\">log-bin=mysql-bin\uff08\u53ef\u80fd\u5177\u4f53\u540d\u79f0\u7565\u6709\u4e0d\u540c\uff09\u3002<\/span><\/p><p><span style=\"text-wrap-mode: nowrap;\">\u5728\u8be5\u884c\u5f00\u5934\u6dfb\u52a0#\u8fdb\u884c\u6ce8\u91ca\uff0c\u4f7f\u5176\u53d8\u4e3a\uff1a<\/span><\/p><p><span style=\"text-wrap-mode: nowrap;\">#log-bin=mysql-bin\u3002<\/span><\/p><p><br\/><\/p>"}