{"id":504,"date":"2021-03-05T21:06:13","date_gmt":"2021-03-05T12:06:13","guid":{"rendered":"https:\/\/www.tiptip.today\/?p=504"},"modified":"2021-03-05T21:07:23","modified_gmt":"2021-03-05T12:07:23","slug":"prevent-system-failure-due-to-mysql-binary-log-capacity","status":"publish","type":"post","link":"https:\/\/tippang.net\/?p=504","title":{"rendered":"Prevent system failure due to MySQL Binary Log capacity"},"content":{"rendered":"

\"\"
\n“binlog” is a file that records all changes made in the server.<\/strong><\/em><\/p>\n

It is an essential element for PIT (point-in-time recovery) and replication, and if you don’t use these two functions, you don’t have to activate it. Although the empty log itself is subtle, it adds to the IO burden.<\/strong><\/em><\/p>\n

How to turn off “binlog”<\/p>\n

Step 1. Write in \/etc\/mysql\/mysql.conf.d\/mysqld.cnf as below.
\n—————————————————————————–<\/p>\n[mysqld]\n#
\n# * Basic Settings
\n#
\nskip-log-bin\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0<—Add this line into the file
\n—————————————————————————–<\/p>\n

How to check if “binlog” off
\nWhether or not the bean log is activated can be checked with “show” command in MySQL DB
\n—————————————————————————–
\nmysql> show variables like’log_bin’;
\n+—————+——-+
\n| Variable_name | Value |
\n+—————+——-+
\n| log_bin \u00a0\u00a0\u00a0\u00a0 | ON \u00a0\u00a0|
\n+—————+——-+
\n1 row in set (0.00 sec)
\n—————————————————————————–<\/p>\n","protected":false},"excerpt":{"rendered":"

“binlog” is a file that records all changes made in the server. It is an<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"om_disable_all_campaigns":false,"footnotes":""},"categories":[7,14,28],"tags":[40],"class_list":["post-504","post","type-post","status-publish","format-standard","hentry","category-itexpert","category-linux","category-wordpress","tag-mysql-failure-binlog"],"aioseo_notices":[],"yoast_head":"\nPrevent system failure due to MySQL Binary Log capacity - tippang.net<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/tippang.net\/?p=504\" class=\"yoast-seo-meta-tag\" \/>\n<meta property=\"og:locale\" content=\"en_US\" class=\"yoast-seo-meta-tag\" \/>\n<meta property=\"og:type\" content=\"article\" class=\"yoast-seo-meta-tag\" \/>\n<meta property=\"og:title\" content=\"Prevent system failure due to MySQL Binary Log capacity - tippang.net\" class=\"yoast-seo-meta-tag\" \/>\n<meta property=\"og:description\" content=\"“binlog” is a file that records all changes made in the server. It is an\" class=\"yoast-seo-meta-tag\" \/>\n<meta property=\"og:url\" content=\"https:\/\/tippang.net\/?p=504\" class=\"yoast-seo-meta-tag\" \/>\n<meta property=\"og:site_name\" content=\"tippang.net\" class=\"yoast-seo-meta-tag\" \/>\n<meta property=\"article:published_time\" content=\"2021-03-05T12:06:13+00:00\" class=\"yoast-seo-meta-tag\" \/>\n<meta property=\"article:modified_time\" content=\"2021-03-05T12:07:23+00:00\" class=\"yoast-seo-meta-tag\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.tiptip.today\/wp-content\/uploads\/2021\/03\/laptop-5906264_1280.png\" class=\"yoast-seo-meta-tag\" \/>\n<meta name=\"author\" content=\"Charles\" class=\"yoast-seo-meta-tag\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" class=\"yoast-seo-meta-tag\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" class=\"yoast-seo-meta-tag\" \/>\n\t<meta name=\"twitter:data1\" content=\"Charles\" class=\"yoast-seo-meta-tag\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" class=\"yoast-seo-meta-tag\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" class=\"yoast-seo-meta-tag\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/tippang.net\/?p=504#article\",\"isPartOf\":{\"@id\":\"https:\/\/tippang.net\/?p=504\"},\"author\":{\"name\":\"Charles\",\"@id\":\"https:\/\/tippang.net\/#\/schema\/person\/d1b0d568e5385a89b638f3eedf2dca86\"},\"headline\":\"Prevent system failure due to MySQL Binary Log capacity\",\"datePublished\":\"2021-03-05T12:06:13+00:00\",\"dateModified\":\"2021-03-05T12:07:23+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/tippang.net\/?p=504\"},\"wordCount\":136,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/tippang.net\/#organization\"},\"image\":{\"@id\":\"https:\/\/tippang.net\/?p=504#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.tiptip.today\/wp-content\/uploads\/2021\/03\/laptop-5906264_1280.png\",\"keywords\":[\"mysql failure binlog\"],\"articleSection\":[\"ITEXPERT\",\"Linux\",\"Wordpress\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/tippang.net\/?p=504#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/tippang.net\/?p=504\",\"url\":\"https:\/\/tippang.net\/?p=504\",\"name\":\"Prevent system failure due to MySQL Binary Log capacity - tippang.net\",\"isPartOf\":{\"@id\":\"https:\/\/tippang.net\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/tippang.net\/?p=504#primaryimage\"},\"image\":{\"@id\":\"https:\/\/tippang.net\/?p=504#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.tiptip.today\/wp-content\/uploads\/2021\/03\/laptop-5906264_1280.png\",\"datePublished\":\"2021-03-05T12:06:13+00:00\",\"dateModified\":\"2021-03-05T12:07:23+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/tippang.net\/?p=504#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/tippang.net\/?p=504\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/tippang.net\/?p=504#primaryimage\",\"url\":\"https:\/\/www.tiptip.today\/wp-content\/uploads\/2021\/03\/laptop-5906264_1280.png\",\"contentUrl\":\"https:\/\/www.tiptip.today\/wp-content\/uploads\/2021\/03\/laptop-5906264_1280.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/tippang.net\/?p=504#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/tippang.net\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Prevent system failure due to MySQL Binary Log capacity\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/tippang.net\/#website\",\"url\":\"https:\/\/tippang.net\/\",\"name\":\"tippang.net\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/tippang.net\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/tippang.net\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/tippang.net\/#organization\",\"name\":\"tippang.net\",\"url\":\"https:\/\/tippang.net\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/tippang.net\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/tippang.net\/wp-content\/uploads\/2021\/02\/cropped-\u110e\u1162\u1102\u1165\u11af\u110b\u1161\u110b\u1175\u110f\u1169\u11ab1_\u1100\u1165\u1107\u116e\u11a8\u110b\u1175.png\",\"contentUrl\":\"https:\/\/tippang.net\/wp-content\/uploads\/2021\/02\/cropped-\u110e\u1162\u1102\u1165\u11af\u110b\u1161\u110b\u1175\u110f\u1169\u11ab1_\u1100\u1165\u1107\u116e\u11a8\u110b\u1175.png\",\"width\":280,\"height\":280,\"caption\":\"tippang.net\"},\"image\":{\"@id\":\"https:\/\/tippang.net\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/tippang.net\/#\/schema\/person\/d1b0d568e5385a89b638f3eedf2dca86\",\"name\":\"Charles\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/tippang.net\/#\/schema\/person\/image\/\",\"url\":\"\/\/www.gravatar.com\/avatar\/3a452b00f5e85211cbb28d2708d7f18f?s=96&r=g&d=wavatar\",\"contentUrl\":\"\/\/www.gravatar.com\/avatar\/3a452b00f5e85211cbb28d2708d7f18f?s=96&r=g&d=wavatar\",\"caption\":\"Charles\"},\"description\":\"An IT Guy On earth\",\"sameAs\":[\"https:\/\/www.tiptip.today\"],\"url\":\"https:\/\/tippang.net\/author\/cm201705\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Prevent system failure due to MySQL Binary Log capacity - tippang.net","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/tippang.net\/?p=504","og_locale":"en_US","og_type":"article","og_title":"Prevent system failure due to MySQL Binary Log capacity - tippang.net","og_description":"“binlog” is a file that records all changes made in the server. It is an","og_url":"https:\/\/tippang.net\/?p=504","og_site_name":"tippang.net","article_published_time":"2021-03-05T12:06:13+00:00","article_modified_time":"2021-03-05T12:07:23+00:00","og_image":[{"url":"https:\/\/www.tiptip.today\/wp-content\/uploads\/2021\/03\/laptop-5906264_1280.png","type":"","width":"","height":""}],"author":"Charles","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Charles","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/tippang.net\/?p=504#article","isPartOf":{"@id":"https:\/\/tippang.net\/?p=504"},"author":{"name":"Charles","@id":"https:\/\/tippang.net\/#\/schema\/person\/d1b0d568e5385a89b638f3eedf2dca86"},"headline":"Prevent system failure due to MySQL Binary Log capacity","datePublished":"2021-03-05T12:06:13+00:00","dateModified":"2021-03-05T12:07:23+00:00","mainEntityOfPage":{"@id":"https:\/\/tippang.net\/?p=504"},"wordCount":136,"commentCount":0,"publisher":{"@id":"https:\/\/tippang.net\/#organization"},"image":{"@id":"https:\/\/tippang.net\/?p=504#primaryimage"},"thumbnailUrl":"https:\/\/www.tiptip.today\/wp-content\/uploads\/2021\/03\/laptop-5906264_1280.png","keywords":["mysql failure binlog"],"articleSection":["ITEXPERT","Linux","Wordpress"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/tippang.net\/?p=504#respond"]}]},{"@type":"WebPage","@id":"https:\/\/tippang.net\/?p=504","url":"https:\/\/tippang.net\/?p=504","name":"Prevent system failure due to MySQL Binary Log capacity - tippang.net","isPartOf":{"@id":"https:\/\/tippang.net\/#website"},"primaryImageOfPage":{"@id":"https:\/\/tippang.net\/?p=504#primaryimage"},"image":{"@id":"https:\/\/tippang.net\/?p=504#primaryimage"},"thumbnailUrl":"https:\/\/www.tiptip.today\/wp-content\/uploads\/2021\/03\/laptop-5906264_1280.png","datePublished":"2021-03-05T12:06:13+00:00","dateModified":"2021-03-05T12:07:23+00:00","breadcrumb":{"@id":"https:\/\/tippang.net\/?p=504#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/tippang.net\/?p=504"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/tippang.net\/?p=504#primaryimage","url":"https:\/\/www.tiptip.today\/wp-content\/uploads\/2021\/03\/laptop-5906264_1280.png","contentUrl":"https:\/\/www.tiptip.today\/wp-content\/uploads\/2021\/03\/laptop-5906264_1280.png"},{"@type":"BreadcrumbList","@id":"https:\/\/tippang.net\/?p=504#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/tippang.net\/"},{"@type":"ListItem","position":2,"name":"Prevent system failure due to MySQL Binary Log capacity"}]},{"@type":"WebSite","@id":"https:\/\/tippang.net\/#website","url":"https:\/\/tippang.net\/","name":"tippang.net","description":"","publisher":{"@id":"https:\/\/tippang.net\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/tippang.net\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/tippang.net\/#organization","name":"tippang.net","url":"https:\/\/tippang.net\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/tippang.net\/#\/schema\/logo\/image\/","url":"https:\/\/tippang.net\/wp-content\/uploads\/2021\/02\/cropped-\u110e\u1162\u1102\u1165\u11af\u110b\u1161\u110b\u1175\u110f\u1169\u11ab1_\u1100\u1165\u1107\u116e\u11a8\u110b\u1175.png","contentUrl":"https:\/\/tippang.net\/wp-content\/uploads\/2021\/02\/cropped-\u110e\u1162\u1102\u1165\u11af\u110b\u1161\u110b\u1175\u110f\u1169\u11ab1_\u1100\u1165\u1107\u116e\u11a8\u110b\u1175.png","width":280,"height":280,"caption":"tippang.net"},"image":{"@id":"https:\/\/tippang.net\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/tippang.net\/#\/schema\/person\/d1b0d568e5385a89b638f3eedf2dca86","name":"Charles","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/tippang.net\/#\/schema\/person\/image\/","url":"\/\/www.gravatar.com\/avatar\/3a452b00f5e85211cbb28d2708d7f18f?s=96&r=g&d=wavatar","contentUrl":"\/\/www.gravatar.com\/avatar\/3a452b00f5e85211cbb28d2708d7f18f?s=96&r=g&d=wavatar","caption":"Charles"},"description":"An IT Guy On earth","sameAs":["https:\/\/www.tiptip.today"],"url":"https:\/\/tippang.net\/author\/cm201705"}]}},"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/tippang.net\/index.php?rest_route=\/wp\/v2\/posts\/504","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tippang.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tippang.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tippang.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/tippang.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=504"}],"version-history":[{"count":3,"href":"https:\/\/tippang.net\/index.php?rest_route=\/wp\/v2\/posts\/504\/revisions"}],"predecessor-version":[{"id":508,"href":"https:\/\/tippang.net\/index.php?rest_route=\/wp\/v2\/posts\/504\/revisions\/508"}],"wp:attachment":[{"href":"https:\/\/tippang.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=504"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tippang.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=504"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tippang.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=504"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}