{"id":2346,"date":"2015-11-06T11:14:38","date_gmt":"2015-11-06T11:14:38","guid":{"rendered":"http:\/\/blog.designed79.co.uk\/?p=2346"},"modified":"2015-11-06T11:14:38","modified_gmt":"2015-11-06T11:14:38","slug":"mariadb-autopurge-binlogs","status":"publish","type":"post","link":"https:\/\/blog.designed79.co.uk\/?p=2346","title":{"rendered":"MariaDB &#8211; Autopurge binlogs"},"content":{"rendered":"<p class=\"anchored_heading\">Add the following into you my.cnf and restart mariaDB<\/p>\n<h4 id=\"expire_logs_days\" class=\"anchored_heading\">\n<div class=\"codecolorer-container text default\" style=\"overflow:auto;white-space:nowrap;\"><div class=\"text codecolorer\">expire_logs_days<\/div><\/div>\n<\/h4>\n<ul>\n<li><strong>Description:<\/strong> Number of days after which the <a href=\"https:\/\/mariadb.com\/kb\/en\/binary-log\/\">binary log<\/a> will be automatically removed. By default 0, or no automatic removal. When using replication, should always be set higher than the maximum lag by any slave.<\/li>\n<li><strong>Commandline:<\/strong>\n<div class=\"codecolorer-container text default fixed\" style=\"overflow:auto;white-space:nowrap;\"><div class=\"text codecolorer\">--expire-logs-days=#<\/div><\/div>\n<\/li>\n<li><strong>Scope:<\/strong> Global<\/li>\n<li><strong>Dynamic:<\/strong> Yes<\/li>\n<li><strong>Data Type:<\/strong>\n<div class=\"codecolorer-container text default\" style=\"overflow:auto;white-space:nowrap;\"><div class=\"text codecolorer\">numeric<\/div><\/div>\n<\/li>\n<li><strong>Default Value:<\/strong>\n<div class=\"codecolorer-container text default\" style=\"overflow:auto;white-space:nowrap;\"><div class=\"text codecolorer\">0<\/div><\/div>\n<\/li>\n<li><strong>Range:<\/strong>\n<div class=\"codecolorer-container text default\" style=\"overflow:auto;white-space:nowrap;\"><div class=\"text codecolorer\">0<\/div><\/div>\n<p>to<\/p>\n<div class=\"codecolorer-container text default\" style=\"overflow:auto;white-space:nowrap;\"><div class=\"text codecolorer\">99<\/div><\/div>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Add the following into you my.cnf and restart mariaDB expire_logs_days Description: Number of days after which the binary log will be automatically [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-2346","post","type-post","status-publish","format-standard","hentry","category-info-on-tech"],"_links":{"self":[{"href":"https:\/\/blog.designed79.co.uk\/index.php?rest_route=\/wp\/v2\/posts\/2346","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.designed79.co.uk\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.designed79.co.uk\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.designed79.co.uk\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.designed79.co.uk\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2346"}],"version-history":[{"count":0,"href":"https:\/\/blog.designed79.co.uk\/index.php?rest_route=\/wp\/v2\/posts\/2346\/revisions"}],"wp:attachment":[{"href":"https:\/\/blog.designed79.co.uk\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2346"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.designed79.co.uk\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2346"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.designed79.co.uk\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2346"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}