{"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\/es\/odms-r7\/1329-sql-bin-log-data-setting\/","title":{"rendered":"Configuraci\u00f3n de datos de registro de SQL BIN"},"content":{"rendered":"<p>Esta gu\u00eda explica c\u00f3mo cambiar la configuraci\u00f3n de datos de registro de SQL BIN, si ocupa demasiado espacio de almacenamiento en el servidor.<\/p>\n<p>El registro binario que est\u00e1 viendo ocupa mucho espacio en disco en el directorio de &quot;datos&quot; es una configuraci\u00f3n predeterminada en MySQL\/MariaDB que proporciona una funcionalidad importante. El uso principal es en la replicaci\u00f3n de bases de datos a servidores esclavos, que SCP no utiliza. Sin embargo, tambi\u00e9n se pueden usar como una restauraci\u00f3n de emergencia, ya que los registros binarios esencialmente permiten reproducir todas las transacciones de la base de datos.<\/p>\n<p>Por supuesto, puede desactivar esta funci\u00f3n en cualquier momento si lo desea.<\/p>\n<p>Las siguientes configuraciones en \u201cC:SCPmariadb-10.2.8my.ini\u201d configuran el registro binario:<\/p>\n<p>registro-bin = mysql-bin<\/p>\n<p>Configura el nombre de archivo utilizado para el registro binario y tambi\u00e9n controla si la funci\u00f3n est\u00e1 habilitada. Puede eliminar (o comentar) esta l\u00ednea y reiniciar el servicio &quot;oac_maria&quot; para desactivar los registros binarios por completo. A continuaci\u00f3n, puede eliminar de forma segura los archivos mysql-bin.<\/p>\n<p>expirar-registros-d\u00edas = 90<\/p>\n<p>Esto no est\u00e1 en el archivo de configuraci\u00f3n cuando lo enviamos, pero puede agregarlo debajo de la l\u00ednea &quot;log-bin&quot;. 90 d\u00edas es el per\u00edodo de caducidad predeterminado, pero puede reducir este n\u00famero de forma segura, especialmente si realiza copias de seguridad con regularidad. El servidor eliminar\u00e1 autom\u00e1ticamente los archivos caducados al reiniciar el servicio.<\/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.3 - 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\/es\/odms-r7\/1329-sql-bin-log-data-setting\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\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\/es\/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=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"Webmaster\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minuto\" \/>\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\":\"es\"},{\"@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\":\"es\",\"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\":\"es\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/audiosupport.omsystem.com\\\/en\\\/#\\\/schema\\\/person\\\/436dfd3216eb25b356a1613aa339d8f6\",\"name\":\"Webmaster\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@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\\\/es\\\/author\\\/gliffen\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Configuraci\u00f3n de datos del registro BIN de SQL - Soporte de audio profesional","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\/es\/odms-r7\/1329-sql-bin-log-data-setting\/","og_locale":"es_ES","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\/es\/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":{"Escrito por":"Webmaster","Tiempo de lectura":"1 minuto"},"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":"es"},{"@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":"Configuraci\u00f3n de datos del registro BIN de SQL - Soporte de audio profesional","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":"es","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":"Soporte de audio profesional","description":"Soluciones digitales 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":"es"},{"@type":"Person","@id":"https:\/\/audiosupport.omsystem.com\/en\/#\/schema\/person\/436dfd3216eb25b356a1613aa339d8f6","name":"Administrador de p\u00e1gina web","image":{"@type":"ImageObject","inLanguage":"es","@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\/es\/author\/gliffen\/"}]}},"_links":{"self":[{"href":"https:\/\/audiosupport.omsystem.com\/es\/wp-json\/wp\/v2\/posts\/1666","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/audiosupport.omsystem.com\/es\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/audiosupport.omsystem.com\/es\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/audiosupport.omsystem.com\/es\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/audiosupport.omsystem.com\/es\/wp-json\/wp\/v2\/comments?post=1666"}],"version-history":[{"count":0,"href":"https:\/\/audiosupport.omsystem.com\/es\/wp-json\/wp\/v2\/posts\/1666\/revisions"}],"wp:attachment":[{"href":"https:\/\/audiosupport.omsystem.com\/es\/wp-json\/wp\/v2\/media?parent=1666"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/audiosupport.omsystem.com\/es\/wp-json\/wp\/v2\/categories?post=1666"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/audiosupport.omsystem.com\/es\/wp-json\/wp\/v2\/tags?post=1666"}],"curies":[{"name":"gracias","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}