{"id":1666,"date":"2022-03-21T00:00:00","date_gmt":"2022-03-21T00:00:00","guid":{"rendered":"https:\/\/audiosupport.omsystem.com\/2022\/03\/21\/1329-sql-bin-log-data-setting\/"},"modified":"2022-03-21T00:00:00","modified_gmt":"2022-03-21T00:00:00","slug":"1329-sql-bin-log-data-setting","status":"publish","type":"post","link":"https:\/\/audiosupport.omsystem.com\/fr\/odms-r7\/1329-sql-bin-log-data-setting\/","title":{"rendered":"Param\u00e8tre de donn\u00e9es de journal SQL BIN"},"content":{"rendered":"<p>Ce guide explique comment modifier le param\u00e8tre de donn\u00e9es du journal SQL BIN, s&#039;il occupe trop d&#039;espace de stockage sur le serveur.<\/p>\n<p>Le journal binaire que vous voyez utilise beaucoup d&#039;espace disque dans le r\u00e9pertoire &quot;data&quot; est un param\u00e8tre par d\u00e9faut dans MySQL\/MariaDB qui fournit des fonctionnalit\u00e9s importantes. L&#039;utilisation principale est la r\u00e9plication de bases de donn\u00e9es sur des serveurs esclaves, que SCP n&#039;utilise pas. Cependant, ils peuvent \u00e9galement \u00eatre utilis\u00e9s comme restauration d&#039;urgence, car les journaux binaires permettent essentiellement de relire toutes les transactions de la base de donn\u00e9es.<\/p>\n<p>Vous pouvez bien s\u00fbr d\u00e9sactiver cette fonctionnalit\u00e9 \u00e0 tout moment si vous le souhaitez.<\/p>\n<p>Les param\u00e8tres suivants dans &quot;C:SCPmariadb-10.2.8my.ini&quot; configurent le journal binaire\u00a0:<\/p>\n<p>log-bin = mysql-bin<\/p>\n<p>Configure le nom de fichier utilis\u00e9 pour le journal binaire et contr\u00f4le \u00e9galement si la fonctionnalit\u00e9 est activ\u00e9e. Vous pouvez supprimer (ou commenter) cette ligne et red\u00e9marrer le service &quot;oac_maria&quot; pour d\u00e9sactiver compl\u00e8tement les journaux binaires. Vous pouvez ensuite supprimer en toute s\u00e9curit\u00e9 les fichiers mysql-bin.<\/p>\n<p>expire-journaux-jours = 90<\/p>\n<p>Ce n&#039;est pas dans le fichier de configuration tel que nous l&#039;exp\u00e9dions, mais vous pouvez l&#039;ajouter sous la ligne &quot;log-bin&quot;. 90 jours est la p\u00e9riode d&#039;expiration par d\u00e9faut, mais vous pouvez r\u00e9duire ce nombre en toute s\u00e9curit\u00e9, surtout si vous effectuez r\u00e9guli\u00e8rement des sauvegardes. Le serveur \u00e9laguera automatiquement les fichiers expir\u00e9s pour vous lors du red\u00e9marrage du service.<\/p>","protected":false},"excerpt":{"rendered":"<p>This guide goes through how to change the SQL BIN log data setting, if its taking up too much storage space on the server. The binary log that you are seeing use up a lot of disk space in the &#8220;data&#8221; directory is a default setting in MySQL\/MariaDB that provides important functionality. The primary usage [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"ghostkit_customizer_options":"","ghostkit_custom_css":"","ghostkit_custom_js_head":"","ghostkit_custom_js_foot":"","ghostkit_typography":"","footnotes":""},"categories":[72],"tags":[129,151],"class_list":["post-1666","post","type-post","status-publish","format-standard","hentry","category-odms-r7","tag-scp","tag-webscp"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>SQL BIN log data setting - Professional Audio Support<\/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:\/\/audiosupport.omsystem.com\/fr\/odms-r7\/1329-sql-bin-log-data-setting\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL BIN log data setting - Professional Audio Support\" \/>\n<meta property=\"og:description\" content=\"This guide goes through how to change the SQL BIN log data setting, if its taking up too much storage space on the server. The binary log that you are seeing use up a lot of disk space in the &#8220;data&#8221; directory is a default setting in MySQL\/MariaDB that provides important functionality. The primary usage [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/audiosupport.omsystem.com\/fr\/odms-r7\/1329-sql-bin-log-data-setting\/\" \/>\n<meta property=\"og:site_name\" content=\"Professional Audio Support\" \/>\n<meta property=\"article:published_time\" content=\"2022-03-21T00:00:00+00:00\" \/>\n<meta name=\"author\" content=\"Webmaster\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@gliffen\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"Webmaster\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/audiosupport.omsystem.com\\\/odms-r7\\\/1329-sql-bin-log-data-setting\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/audiosupport.omsystem.com\\\/odms-r7\\\/1329-sql-bin-log-data-setting\\\/\"},\"author\":{\"name\":\"Webmaster\",\"@id\":\"https:\\\/\\\/audiosupport.omsystem.com\\\/en\\\/#\\\/schema\\\/person\\\/436dfd3216eb25b356a1613aa339d8f6\"},\"headline\":\"SQL BIN log data setting\",\"datePublished\":\"2022-03-21T00:00:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/audiosupport.omsystem.com\\\/odms-r7\\\/1329-sql-bin-log-data-setting\\\/\"},\"wordCount\":219,\"keywords\":[\"SCP\",\"WebSCP\"],\"articleSection\":[\"ODMS R8\\\/R7\\\/R6\"],\"inLanguage\":\"fr-FR\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/audiosupport.omsystem.com\\\/odms-r7\\\/1329-sql-bin-log-data-setting\\\/\",\"url\":\"https:\\\/\\\/audiosupport.omsystem.com\\\/odms-r7\\\/1329-sql-bin-log-data-setting\\\/\",\"name\":\"SQL BIN log data setting - Professional Audio Support\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/audiosupport.omsystem.com\\\/en\\\/#website\"},\"datePublished\":\"2022-03-21T00:00:00+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/audiosupport.omsystem.com\\\/en\\\/#\\\/schema\\\/person\\\/436dfd3216eb25b356a1613aa339d8f6\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/audiosupport.omsystem.com\\\/odms-r7\\\/1329-sql-bin-log-data-setting\\\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/audiosupport.omsystem.com\\\/odms-r7\\\/1329-sql-bin-log-data-setting\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/audiosupport.omsystem.com\\\/odms-r7\\\/1329-sql-bin-log-data-setting\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/audiosupport.omsystem.com\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL BIN log data setting\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/audiosupport.omsystem.com\\\/en\\\/#website\",\"url\":\"https:\\\/\\\/audiosupport.omsystem.com\\\/en\\\/\",\"name\":\"Professional Audio Support\",\"description\":\"OM Digital Solutions\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/audiosupport.omsystem.com\\\/en\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/audiosupport.omsystem.com\\\/en\\\/#\\\/schema\\\/person\\\/436dfd3216eb25b356a1613aa339d8f6\",\"name\":\"Webmaster\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/e488d5421d254a9a6a8aa55683f571ed403d3c3687642355aa48e00b19c8d5ca?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/e488d5421d254a9a6a8aa55683f571ed403d3c3687642355aa48e00b19c8d5ca?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/e488d5421d254a9a6a8aa55683f571ed403d3c3687642355aa48e00b19c8d5ca?s=96&d=mm&r=g\",\"caption\":\"Webmaster\"},\"sameAs\":[\"http:\\\/\\\/audiosupport.omsystem.com\",\"https:\\\/\\\/x.com\\\/gliffen\"],\"url\":\"https:\\\/\\\/audiosupport.omsystem.com\\\/fr\\\/author\\\/gliffen\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Param\u00e9trage des donn\u00e9es du journal SQL BIN - Assistance audio professionnelle","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:\/\/audiosupport.omsystem.com\/fr\/odms-r7\/1329-sql-bin-log-data-setting\/","og_locale":"fr_FR","og_type":"article","og_title":"SQL BIN log data setting - Professional Audio Support","og_description":"This guide goes through how to change the SQL BIN log data setting, if its taking up too much storage space on the server. The binary log that you are seeing use up a lot of disk space in the &#8220;data&#8221; directory is a default setting in MySQL\/MariaDB that provides important functionality. The primary usage [&hellip;]","og_url":"https:\/\/audiosupport.omsystem.com\/fr\/odms-r7\/1329-sql-bin-log-data-setting\/","og_site_name":"Professional Audio Support","article_published_time":"2022-03-21T00:00:00+00:00","author":"Webmaster","twitter_card":"summary_large_image","twitter_creator":"@gliffen","twitter_misc":{"\u00c9crit par":"Webmaster","Dur\u00e9e de lecture estim\u00e9e":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/audiosupport.omsystem.com\/odms-r7\/1329-sql-bin-log-data-setting\/#article","isPartOf":{"@id":"https:\/\/audiosupport.omsystem.com\/odms-r7\/1329-sql-bin-log-data-setting\/"},"author":{"name":"Webmaster","@id":"https:\/\/audiosupport.omsystem.com\/en\/#\/schema\/person\/436dfd3216eb25b356a1613aa339d8f6"},"headline":"SQL BIN log data setting","datePublished":"2022-03-21T00:00:00+00:00","mainEntityOfPage":{"@id":"https:\/\/audiosupport.omsystem.com\/odms-r7\/1329-sql-bin-log-data-setting\/"},"wordCount":219,"keywords":["SCP","WebSCP"],"articleSection":["ODMS R8\/R7\/R6"],"inLanguage":"fr-FR"},{"@type":"WebPage","@id":"https:\/\/audiosupport.omsystem.com\/odms-r7\/1329-sql-bin-log-data-setting\/","url":"https:\/\/audiosupport.omsystem.com\/odms-r7\/1329-sql-bin-log-data-setting\/","name":"Param\u00e9trage des donn\u00e9es du journal SQL BIN - Assistance audio professionnelle","isPartOf":{"@id":"https:\/\/audiosupport.omsystem.com\/en\/#website"},"datePublished":"2022-03-21T00:00:00+00:00","author":{"@id":"https:\/\/audiosupport.omsystem.com\/en\/#\/schema\/person\/436dfd3216eb25b356a1613aa339d8f6"},"breadcrumb":{"@id":"https:\/\/audiosupport.omsystem.com\/odms-r7\/1329-sql-bin-log-data-setting\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/audiosupport.omsystem.com\/odms-r7\/1329-sql-bin-log-data-setting\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/audiosupport.omsystem.com\/odms-r7\/1329-sql-bin-log-data-setting\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/audiosupport.omsystem.com\/"},{"@type":"ListItem","position":2,"name":"SQL BIN log data setting"}]},{"@type":"WebSite","@id":"https:\/\/audiosupport.omsystem.com\/en\/#website","url":"https:\/\/audiosupport.omsystem.com\/en\/","name":"Assistance audio professionnelle","description":"Solutions num\u00e9riques OM","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/audiosupport.omsystem.com\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"fr-FR"},{"@type":"Person","@id":"https:\/\/audiosupport.omsystem.com\/en\/#\/schema\/person\/436dfd3216eb25b356a1613aa339d8f6","name":"Webmestre","image":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/secure.gravatar.com\/avatar\/e488d5421d254a9a6a8aa55683f571ed403d3c3687642355aa48e00b19c8d5ca?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/e488d5421d254a9a6a8aa55683f571ed403d3c3687642355aa48e00b19c8d5ca?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/e488d5421d254a9a6a8aa55683f571ed403d3c3687642355aa48e00b19c8d5ca?s=96&d=mm&r=g","caption":"Webmaster"},"sameAs":["http:\/\/audiosupport.omsystem.com","https:\/\/x.com\/gliffen"],"url":"https:\/\/audiosupport.omsystem.com\/fr\/author\/gliffen\/"}]}},"_links":{"self":[{"href":"https:\/\/audiosupport.omsystem.com\/fr\/wp-json\/wp\/v2\/posts\/1666","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/audiosupport.omsystem.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/audiosupport.omsystem.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/audiosupport.omsystem.com\/fr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/audiosupport.omsystem.com\/fr\/wp-json\/wp\/v2\/comments?post=1666"}],"version-history":[{"count":0,"href":"https:\/\/audiosupport.omsystem.com\/fr\/wp-json\/wp\/v2\/posts\/1666\/revisions"}],"wp:attachment":[{"href":"https:\/\/audiosupport.omsystem.com\/fr\/wp-json\/wp\/v2\/media?parent=1666"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/audiosupport.omsystem.com\/fr\/wp-json\/wp\/v2\/categories?post=1666"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/audiosupport.omsystem.com\/fr\/wp-json\/wp\/v2\/tags?post=1666"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}