{"id":1354,"date":"2021-03-15T16:30:55","date_gmt":"2021-03-15T10:30:55","guid":{"rendered":"https:\/\/goodhost.kz\/wiki\/?p=1354"},"modified":"2026-11-02T18:05:46","modified_gmt":"2026-11-02T12:05:46","slug":"binlog-%d0%be%d0%b3%d1%80%d0%be%d0%bc%d0%bd%d0%be%d0%b3%d0%be-%d1%80%d0%b0%d0%b7%d0%bc%d0%b5%d1%80%d0%b0-%d0%b8-%d0%b7%d0%b0%d0%b1%d0%b8%d0%b2%d0%b0%d0%b5%d1%82-%d0%b2%d1%81%d1%91-%d0%b4%d0%b8%d1%81","status":"publish","type":"post","link":"https:\/\/goodhost.kz\/wiki\/?p=1354","title":{"rendered":"Binlog \u043e\u0433\u0440\u043e\u043c\u043d\u043e\u0433\u043e \u0440\u0430\u0437\u043c\u0435\u0440\u0430 \u0438 \u0437\u0430\u0431\u0438\u0432\u0430\u0435\u0442 \u0432\u0441\u0451 \u0434\u0438\u0441\u043a\u043e\u0432\u043e\u0435 \u043f\u0440\u043e\u0441\u0442\u0440\u0430\u043d\u0441\u0442\u0432\u043e \u043d\u0430 \u0441\u0435\u0440\u0432\u0435\u0440\u0435."},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">\u041a\u0430\u043a \u043f\u043e\u0447\u0438\u0441\u0442\u0438\u0442\u044c, \u043e\u0442\u043a\u043b\u044e\u0447\u0438\u0442\u044c \u0438\u043b\u0438 \u0443\u0434\u0430\u043b\u0438\u0442\u044c \u0431\u0438\u043d\u0430\u0440\u043d\u044b\u0435 \u043b\u043e\u0433\u0438 ?<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u0414\u043b\u044f \u044d\u0442\u043e\u0433\u043e \u0434\u043e\u0431\u0430\u0432\u043b\u044f\u0435\u043c \u0432 \u0444\u0430\u0439\u043b \u043a\u043e\u043d\u0444\u0438\u0433\u0443\u0440\u0430\u0446\u0438\u0438 mysql <em>\/etc\/my.cnf<\/em> \u0441\u043b\u0435\u0434\u0443\u044e\u0449\u0438\u0435 \u043f\u0430\u0440\u0430\u043c\u0435\u0442\u0440\u044b:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">max_binlog_size= 500M\nexpire_logs_days = 3<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u0414\u043e\u0431\u0430\u0432\u043b\u044f\u044e\u0442\u0441\u044f \u0432 \u0441\u0435\u043a\u0446\u0438\u044e&nbsp;[mysqld]. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u041f\u043e\u0441\u043b\u0435 \u044d\u0442\u043e\u0433\u043e mysql \u043d\u0430\u0434\u043e \u043f\u0435\u0440\u0435\u0437\u0430\u043f\u0443\u0441\u0442\u0438\u0442\u044c:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\"># systemctl restart mariadb<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u041f\u043e\u0441\u043b\u0435 \u043f\u0435\u0440\u0435\u0437\u0430\u043f\u0443\u0441\u043a\u0430 \u0431\u0430\u0437\u0430 \u0441\u0430\u043c\u0430 \u043f\u043e\u0447\u0438\u0441\u0442\u0438\u0442 \u043b\u043e\u0433 \u0438 \u0443\u043c\u0435\u043d\u044c\u0448\u0438\u0442 \u0440\u0430\u0437\u043c\u0435\u0440 \u0444\u0430\u0439\u043b\u043e\u0432&nbsp;mysql-bin, \u043b\u0438\u0448\u043d\u0438\u0435 \u043f\u0440\u0438 \u044d\u0442\u043e\u043c \u0431\u0443\u0434\u0443\u0442 \u043f\u0440\u043e\u0441\u0442\u043e \u0443\u0434\u0430\u043b\u0435\u043d\u044b. \u0415\u0441\u043b\u0438 \u0443 \u0432\u0430\u0441 \u043d\u0435\u0442 \u0440\u0435\u043f\u043b\u0438\u043a\u0430\u0446\u0438\u0438, \u0442\u043e \u0441\u043e\u0437\u0434\u0430\u043d\u0438\u0435 \u0431\u0438\u043d\u0430\u0440\u043d\u044b\u0445 \u043b\u043e\u0433\u043e\u0432 \u043c\u043e\u0436\u043d\u043e \u043e\u0442\u043a\u043b\u044e\u0447\u0438\u0442\u044c, \u0443\u0434\u0430\u043b\u0438\u0432 \u0432\u0441\u0435 \u043f\u0430\u0440\u0430\u043c\u0435\u0442\u0440\u044b, \u043a\u043e\u0442\u043e\u0440\u044b\u0435 \u0437\u0430 \u043d\u0438\u0445 \u043e\u0442\u0432\u0435\u0447\u0430\u044e\u0442. <\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">log-bin = \/var\/lib\/mysql\/mysql-bin\nbinlog-do-db = database<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u041f\u043e\u0441\u043b\u0435 \u044d\u0442\u043e\u0433\u043e \u043f\u0435\u0440\u0435\u0437\u0430\u043f\u0443\u0441\u043a\u0430\u0435\u043c \u0431\u0430\u0437\u0443. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u041b\u0438\u0431\u043e:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code># \u041e\u0442\u043a\u043b\u044e\u0447\u0438\u0442\u0435 \u0431\u0438\u043d\u043b\u043e\u0433\ndisable-log-bin\n# \u0438\u043b\u0438\nskip-log-bin\n# \u0417\u0430 \u043a\u043e\u043c\u043c\u0435\u043d\u0442\u0438\u0440\u0443\u0439\u0442\u0435 \u0432\u0441\u0435 \u043f\u043e\u0437\u0438\u0446\u0438\u0438 \u0441\u0432\u044f\u0437\u0430\u043d\u043d\u044b\u0435 \u0441 \u0431\u0438\u043d\u043b\u043e\u0433\u043e\u043c\n# expire_logs_days        = 3\n# max_binlog_size         = 500M<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u041f\u0435\u0440\u0435\u0437\u0430\u043f\u0443\u0441\u0442\u0438\u0442\u0435 \u0431\u0430\u0437\u0443 \u0434\u0430\u043d\u043d\u044b\u0445.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>service mysqld restart<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">\u0415\u0441\u043b\u0438 \u0443 \u0412\u0430\u0441 ISPmanager <\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\u041f\u0435\u0440\u0435\u0445\u043e\u0434\u0438\u043c \u0432 <strong>&#171;\u041d\u0430\u0441\u0442\u0440\u043e\u0439\u043a\u0438&#187;-&#171;\u0421\u0435\u0440\u0432\u0435\u0440\u044b \u0431\u0430\u0437 \u0434\u0430\u043d\u043d\u044b\u0445&#187;-&#171;\u041d\u0430\u0441\u0442\u0440\u043e\u0439\u043a\u0438&#187;<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"860\" height=\"531\" src=\"https:\/\/goodhost.kz\/wiki\/wp-content\/uploads\/2021\/03\/Screenshot811.png\" alt=\"\" class=\"wp-image-1355\" srcset=\"https:\/\/goodhost.kz\/wiki\/wp-content\/uploads\/2021\/03\/Screenshot811.png 860w, https:\/\/goodhost.kz\/wiki\/wp-content\/uploads\/2021\/03\/Screenshot811-300x185.png 300w, https:\/\/goodhost.kz\/wiki\/wp-content\/uploads\/2021\/03\/Screenshot811-768x474.png 768w, https:\/\/goodhost.kz\/wiki\/wp-content\/uploads\/2021\/03\/Screenshot811-150x93.png 150w\" sizes=\"auto, (max-width: 860px) 100vw, 860px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">\u0418 \u0438\u0437\u043c\u0435\u043d\u044f\u0435\u043c \u043f\u0430\u0440\u0430\u043c\u0435\u0442\u0440 <strong>expire-logs-days<\/strong> \u0441\u043e \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u044f &#171;0&#187; \u043d\u0430 &#171;3&#187; \u0432 \u043d\u0430\u0448\u0435\u043c \u0441\u043b\u0443\u0447\u0430\u0435.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"771\" height=\"218\" src=\"https:\/\/goodhost.kz\/wiki\/wp-content\/uploads\/2021\/03\/Screenshot812.png\" alt=\"\" class=\"wp-image-1356\" srcset=\"https:\/\/goodhost.kz\/wiki\/wp-content\/uploads\/2021\/03\/Screenshot812.png 771w, https:\/\/goodhost.kz\/wiki\/wp-content\/uploads\/2021\/03\/Screenshot812-300x85.png 300w, https:\/\/goodhost.kz\/wiki\/wp-content\/uploads\/2021\/03\/Screenshot812-768x217.png 768w, https:\/\/goodhost.kz\/wiki\/wp-content\/uploads\/2021\/03\/Screenshot812-150x42.png 150w\" sizes=\"auto, (max-width: 771px) 100vw, 771px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">\u041f\u0440\u0438\u043c\u0435\u043d\u044f\u0435\u043c \u0438\u0437\u043c\u0435\u043d\u0435\u043d\u0438\u044f &#171;\u041e\u041a&#187;, \u043f\u043e\u0441\u043b\u0435 \u0447\u0435\u0433\u043e \u0411\u0414 \u0430\u0432\u0442\u043e\u043c\u0430\u0442\u0438\u0447\u0435\u0441\u043a\u0438 \u043f\u0435\u0440\u0435\u0437\u0430\u0433\u0440\u0443\u0437\u0438\u0442\u0441\u044f \u0438 \u043b\u043e\u0433\u0438 \u0441\u0442\u0430\u0440\u0448\u0435 \u0442\u0440\u0435\u0445 \u0434\u043d\u0435\u0439 \u0430\u0432\u0442\u043e\u043c\u0430\u0442\u0438\u0447\u0435\u0441\u043a\u0438 \u0431\u0443\u0434\u0443\u0442 \u0443\u0434\u0430\u043b\u044f\u0442\u044c\u0441\u044f. <\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u041a\u0430\u043a \u043f\u043e\u0447\u0438\u0441\u0442\u0438\u0442\u044c, \u043e\u0442\u043a\u043b\u044e\u0447\u0438\u0442\u044c \u0438\u043b\u0438 \u0443\u0434\u0430\u043b\u0438\u0442\u044c \u0431\u0438\u043d\u0430\u0440\u043d\u044b\u0435 \u043b\u043e\u0433\u0438 ? \u0414\u043b\u044f \u044d\u0442\u043e\u0433\u043e \u0434\u043e\u0431\u0430\u0432\u043b\u044f\u0435\u043c \u0432 \u0444\u0430\u0439\u043b \u043a\u043e\u043d\u0444\u0438\u0433\u0443\u0440\u0430\u0446\u0438\u0438 mysql \/etc\/my.cnf \u0441\u043b\u0435\u0434\u0443\u044e\u0449\u0438\u0435 \u043f\u0430\u0440\u0430\u043c\u0435\u0442\u0440\u044b: max_binlog_size= 500M expire_logs_days = 3 \u0414\u043e\u0431\u0430\u0432\u043b\u044f\u044e\u0442\u0441\u044f \u0432 \u0441\u0435\u043a\u0446\u0438\u044e&nbsp;[mysqld]. \u041f\u043e\u0441\u043b\u0435 \u044d\u0442\u043e\u0433\u043e mysql \u043d\u0430\u0434\u043e \u043f\u0435\u0440\u0435\u0437\u0430\u043f\u0443\u0441\u0442\u0438\u0442\u044c: # systemctl restart mariadb \u041f\u043e\u0441\u043b\u0435 \u043f\u0435\u0440\u0435\u0437\u0430\u043f\u0443\u0441\u043a\u0430 \u0431\u0430\u0437\u0430 \u0441\u0430\u043c\u0430 \u043f\u043e\u0447\u0438\u0441\u0442\u0438\u0442 \u043b\u043e\u0433 \u0438 \u0443\u043c\u0435\u043d\u044c\u0448\u0438\u0442 \u0440\u0430\u0437\u043c\u0435\u0440 \u0444\u0430\u0439\u043b\u043e\u0432&nbsp;mysql-bin, \u043b\u0438\u0448\u043d\u0438\u0435 \u043f\u0440\u0438 \u044d\u0442\u043e\u043c \u0431\u0443\u0434\u0443\u0442 \u043f\u0440\u043e\u0441\u0442\u043e \u0443\u0434\u0430\u043b\u0435\u043d\u044b. \u0415\u0441\u043b\u0438 \u0443 \u0432\u0430\u0441 \u043d\u0435\u0442 ..<\/p>\n<div class=\"clear-fix\"><\/div>\n<p><a href=\"https:\/\/goodhost.kz\/wiki\/?p=1354\" title=\"\u0447\u0438\u0442\u0430\u0442\u044c...\">\u0427\u0438\u0442\u0430\u0442\u044c \u0434\u0430\u043b\u0435\u0435<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6],"tags":[],"class_list":["post-1354","post","type-post","status-publish","format-standard","hentry","category---vds-vps"],"_links":{"self":[{"href":"https:\/\/goodhost.kz\/wiki\/index.php?rest_route=\/wp\/v2\/posts\/1354","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/goodhost.kz\/wiki\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/goodhost.kz\/wiki\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/goodhost.kz\/wiki\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/goodhost.kz\/wiki\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1354"}],"version-history":[{"count":6,"href":"https:\/\/goodhost.kz\/wiki\/index.php?rest_route=\/wp\/v2\/posts\/1354\/revisions"}],"predecessor-version":[{"id":1656,"href":"https:\/\/goodhost.kz\/wiki\/index.php?rest_route=\/wp\/v2\/posts\/1354\/revisions\/1656"}],"wp:attachment":[{"href":"https:\/\/goodhost.kz\/wiki\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1354"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/goodhost.kz\/wiki\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1354"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/goodhost.kz\/wiki\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1354"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}