{"id":322,"date":"2023-05-17T12:27:55","date_gmt":"2023-05-17T08:27:55","guid":{"rendered":"https:\/\/kidds.co.za\/?p=322"},"modified":"2023-05-17T12:27:55","modified_gmt":"2023-05-17T08:27:55","slug":"mysql-purge-bin-files","status":"publish","type":"post","link":"https:\/\/kidds.co.za\/index.php\/2023\/05\/17\/mysql-purge-bin-files\/","title":{"rendered":"MySQL Purge BIN files"},"content":{"rendered":"\n<p><em>Do not delete the files from the file system.<\/em> <em>MySQL will complain at some time in the future. Save yourself the unnecessary downtime by using<\/em>\u00a0<code>PURGE BINARY LOGS<\/code>\u00a0<em>command from within MySQL<\/em><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>mysql&gt; SHOW BINARY LOGS;<\/code><\/pre>\n\n\n\n<pre class=\"wp-block-code\"><code>mysql> PURGE BINARY LOGS BEFORE '2023-01-01 00:00:00';<\/code><\/pre>\n\n\n\n<p>or<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>mysql&gt; PURGE BINARY LOGS TO 'mysql-bin.12345';<\/code><\/pre>\n\n\n\n<p>Change automatic default purge expiry from 30days (default)<\/p>\n\n\n\n<p><strong>For long term <\/strong>set the BIN logs to a shorter time frame<\/p>\n\n\n\n<p>1 day<\/p>\n\n\n\n<p>mysql> SET GLOBAL binlog_expire_logs_seconds = 86400; <\/p>\n\n\n\n<p>3 days<\/p>\n\n\n\n<p>mysql> SET GLOBAL binlog_expire_logs_seconds = 259200; <\/p>\n\n\n\n<p>5 days<\/p>\n\n\n\n<p>mysql> SET GLOBAL binlog_expire_logs_seconds = 432000; <\/p>\n\n\n\n<p>10 days <\/p>\n\n\n\n<p>mysql> SET GLOBAL binlog_expire_logs_seconds = 864000; <\/p>\n","protected":false},"excerpt":{"rendered":"<p>Do not delete the files from the file system. MySQL will complain at some time in the future. Save yourself the unnecessary downtime by using\u00a0PURGE BINARY LOGS\u00a0command from within MySQL or Change automatic default purge expiry from 30days (default) For long term set the BIN logs to a shorter time frame 1 day mysql> SET [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[23],"tags":[],"class_list":["post-322","post","type-post","status-publish","format-standard","hentry","category-mysql"],"_links":{"self":[{"href":"https:\/\/kidds.co.za\/index.php\/wp-json\/wp\/v2\/posts\/322","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kidds.co.za\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kidds.co.za\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kidds.co.za\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kidds.co.za\/index.php\/wp-json\/wp\/v2\/comments?post=322"}],"version-history":[{"count":1,"href":"https:\/\/kidds.co.za\/index.php\/wp-json\/wp\/v2\/posts\/322\/revisions"}],"predecessor-version":[{"id":323,"href":"https:\/\/kidds.co.za\/index.php\/wp-json\/wp\/v2\/posts\/322\/revisions\/323"}],"wp:attachment":[{"href":"https:\/\/kidds.co.za\/index.php\/wp-json\/wp\/v2\/media?parent=322"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kidds.co.za\/index.php\/wp-json\/wp\/v2\/categories?post=322"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kidds.co.za\/index.php\/wp-json\/wp\/v2\/tags?post=322"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}