{"id":4924,"date":"2024-01-05T11:04:51","date_gmt":"2024-01-05T11:04:51","guid":{"rendered":"https:\/\/audiosupport.omsystem.com\/?p=4924"},"modified":"2024-01-05T11:06:39","modified_gmt":"2024-01-05T11:06:39","slug":"reduce-space-of-bin-files-in-mariadb","status":"publish","type":"post","link":"https:\/\/audiosupport.omsystem.com\/es\/kb\/reduce-space-of-bin-files-in-mariadb\/","title":{"rendered":"Reducir el espacio de los archivos bin en MariaDB"},"content":{"rendered":"<p>Siempre que los registros binarios ocupen demasiado espacio en el disco en una instalaci\u00f3n SCP, existe la posibilidad de liberar algo de espacio.<\/p>\n\n\n\n<p>Para hacer esto, hay una serie de instrucciones que deben seguirse:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Abierto <strong>Potencia Shell<\/strong><\/li>\n\n\n\n<li>Ir al camino <strong>C:\\SCP\\mariadb-10xx\\bin<\/strong><\/li>\n\n\n\n<li>Tipo <strong><strong>.\\mysql -uroot avena<\/strong><\/strong> y<strong> presione la tecla Intro<\/strong><\/li>\n\n\n\n<li>Tipo <strong>comenzar<\/strong> y <strong>presione la tecla Intro<\/strong><\/li>\n\n\n\n<li>Tipo\u00a0<strong>PURGAR REGISTROS BINARIOS ANTES DE &#039;2021-02-01 00:00:00<\/strong> (esta fecha es meramente un ejemplo, se puede establecer una fecha diferente, siempre y cuando la sintaxis sea la misma) y <strong>presione la tecla Intro<\/strong><\/li>\n<\/ol>\n\n\n\n<p> Los archivos deben eliminarse y luego se puede cerrar la ventana de Powershell<\/p>\n\n\n\n<p><\/p>","protected":false},"excerpt":{"rendered":"<p>Siempre que los registros binarios ocupen demasiado espacio en el disco de una instalaci\u00f3n SCP, existe la posibilidad de liberar algo de espacio. Para hacer eso, hay una serie de instrucciones que deben seguirse: Los archivos deben eliminarse y luego se puede cerrar la ventana de Powershell.<\/p>","protected":false},"author":4,"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":[1],"tags":[229,85,129],"class_list":["post-4924","post","type-post","status-publish","format-standard","hentry","category-kb","tag-mariadb","tag-odms-r7","tag-scp"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Reduce space of bin files in MariaDB - 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\/kb\/reduce-space-of-bin-files-in-mariadb\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Reduce space of bin files in MariaDB - Professional Audio Support\" \/>\n<meta property=\"og:description\" content=\"Whenever binary logs are taking up too much disk space in a SCP installation, there&#8217;s the possibility to free up some space. In order to do that, there&#8217;s a set of instructions that need be followed: The files should be purged and then the Powershell window can be closed\" \/>\n<meta property=\"og:url\" content=\"https:\/\/audiosupport.omsystem.com\/es\/kb\/reduce-space-of-bin-files-in-mariadb\/\" \/>\n<meta property=\"og:site_name\" content=\"Professional Audio Support\" \/>\n<meta property=\"article:published_time\" content=\"2024-01-05T11:04:51+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-01-05T11:06:39+00:00\" \/>\n<meta name=\"author\" content=\"A. R.\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"A. R.\" \/>\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\\\/kb\\\/reduce-space-of-bin-files-in-mariadb\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/audiosupport.omsystem.com\\\/kb\\\/reduce-space-of-bin-files-in-mariadb\\\/\"},\"author\":{\"name\":\"A. R.\",\"@id\":\"https:\\\/\\\/audiosupport.omsystem.com\\\/en\\\/#\\\/schema\\\/person\\\/c672ff02167045ba308e9421e62f4720\"},\"headline\":\"Reduce space of bin files in MariaDB\",\"datePublished\":\"2024-01-05T11:04:51+00:00\",\"dateModified\":\"2024-01-05T11:06:39+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/audiosupport.omsystem.com\\\/kb\\\/reduce-space-of-bin-files-in-mariadb\\\/\"},\"wordCount\":112,\"keywords\":[\"MariaDB\",\"ODMS R7\",\"SCP\"],\"articleSection\":[\"Knowledge Base\"],\"inLanguage\":\"es\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/audiosupport.omsystem.com\\\/kb\\\/reduce-space-of-bin-files-in-mariadb\\\/\",\"url\":\"https:\\\/\\\/audiosupport.omsystem.com\\\/kb\\\/reduce-space-of-bin-files-in-mariadb\\\/\",\"name\":\"Reduce space of bin files in MariaDB - Professional Audio Support\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/audiosupport.omsystem.com\\\/en\\\/#website\"},\"datePublished\":\"2024-01-05T11:04:51+00:00\",\"dateModified\":\"2024-01-05T11:06:39+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/audiosupport.omsystem.com\\\/en\\\/#\\\/schema\\\/person\\\/c672ff02167045ba308e9421e62f4720\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/audiosupport.omsystem.com\\\/kb\\\/reduce-space-of-bin-files-in-mariadb\\\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/audiosupport.omsystem.com\\\/kb\\\/reduce-space-of-bin-files-in-mariadb\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/audiosupport.omsystem.com\\\/kb\\\/reduce-space-of-bin-files-in-mariadb\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/audiosupport.omsystem.com\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Reduce space of bin files in MariaDB\"}]},{\"@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\\\/c672ff02167045ba308e9421e62f4720\",\"name\":\"A. R.\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/d8d70fc51a43f561cca296030a720dee38045d77d7cb7cb780c6b4f710c8f12f?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/d8d70fc51a43f561cca296030a720dee38045d77d7cb7cb780c6b4f710c8f12f?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/d8d70fc51a43f561cca296030a720dee38045d77d7cb7cb780c6b4f710c8f12f?s=96&d=mm&r=g\",\"caption\":\"A. R.\"},\"url\":\"https:\\\/\\\/audiosupport.omsystem.com\\\/es\\\/author\\\/angela-rodrigues\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Reducir el espacio de los archivos bin en MariaDB - 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\/kb\/reduce-space-of-bin-files-in-mariadb\/","og_locale":"es_ES","og_type":"article","og_title":"Reduce space of bin files in MariaDB - Professional Audio Support","og_description":"Whenever binary logs are taking up too much disk space in a SCP installation, there&#8217;s the possibility to free up some space. In order to do that, there&#8217;s a set of instructions that need be followed: The files should be purged and then the Powershell window can be closed","og_url":"https:\/\/audiosupport.omsystem.com\/es\/kb\/reduce-space-of-bin-files-in-mariadb\/","og_site_name":"Professional Audio Support","article_published_time":"2024-01-05T11:04:51+00:00","article_modified_time":"2024-01-05T11:06:39+00:00","author":"A. R.","twitter_card":"summary_large_image","twitter_misc":{"Escrito por":"A. R.","Tiempo de lectura":"1 minuto"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/audiosupport.omsystem.com\/kb\/reduce-space-of-bin-files-in-mariadb\/#article","isPartOf":{"@id":"https:\/\/audiosupport.omsystem.com\/kb\/reduce-space-of-bin-files-in-mariadb\/"},"author":{"name":"A. R.","@id":"https:\/\/audiosupport.omsystem.com\/en\/#\/schema\/person\/c672ff02167045ba308e9421e62f4720"},"headline":"Reduce space of bin files in MariaDB","datePublished":"2024-01-05T11:04:51+00:00","dateModified":"2024-01-05T11:06:39+00:00","mainEntityOfPage":{"@id":"https:\/\/audiosupport.omsystem.com\/kb\/reduce-space-of-bin-files-in-mariadb\/"},"wordCount":112,"keywords":["MariaDB","ODMS R7","SCP"],"articleSection":["Knowledge Base"],"inLanguage":"es"},{"@type":"WebPage","@id":"https:\/\/audiosupport.omsystem.com\/kb\/reduce-space-of-bin-files-in-mariadb\/","url":"https:\/\/audiosupport.omsystem.com\/kb\/reduce-space-of-bin-files-in-mariadb\/","name":"Reducir el espacio de los archivos bin en MariaDB - Soporte de audio profesional","isPartOf":{"@id":"https:\/\/audiosupport.omsystem.com\/en\/#website"},"datePublished":"2024-01-05T11:04:51+00:00","dateModified":"2024-01-05T11:06:39+00:00","author":{"@id":"https:\/\/audiosupport.omsystem.com\/en\/#\/schema\/person\/c672ff02167045ba308e9421e62f4720"},"breadcrumb":{"@id":"https:\/\/audiosupport.omsystem.com\/kb\/reduce-space-of-bin-files-in-mariadb\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/audiosupport.omsystem.com\/kb\/reduce-space-of-bin-files-in-mariadb\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/audiosupport.omsystem.com\/kb\/reduce-space-of-bin-files-in-mariadb\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/audiosupport.omsystem.com\/"},{"@type":"ListItem","position":2,"name":"Reduce space of bin files in MariaDB"}]},{"@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\/c672ff02167045ba308e9421e62f4720","name":"Arkansas","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/secure.gravatar.com\/avatar\/d8d70fc51a43f561cca296030a720dee38045d77d7cb7cb780c6b4f710c8f12f?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/d8d70fc51a43f561cca296030a720dee38045d77d7cb7cb780c6b4f710c8f12f?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/d8d70fc51a43f561cca296030a720dee38045d77d7cb7cb780c6b4f710c8f12f?s=96&d=mm&r=g","caption":"A. R."},"url":"https:\/\/audiosupport.omsystem.com\/es\/author\/angela-rodrigues\/"}]}},"_links":{"self":[{"href":"https:\/\/audiosupport.omsystem.com\/es\/wp-json\/wp\/v2\/posts\/4924","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\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/audiosupport.omsystem.com\/es\/wp-json\/wp\/v2\/comments?post=4924"}],"version-history":[{"count":6,"href":"https:\/\/audiosupport.omsystem.com\/es\/wp-json\/wp\/v2\/posts\/4924\/revisions"}],"predecessor-version":[{"id":5090,"href":"https:\/\/audiosupport.omsystem.com\/es\/wp-json\/wp\/v2\/posts\/4924\/revisions\/5090"}],"wp:attachment":[{"href":"https:\/\/audiosupport.omsystem.com\/es\/wp-json\/wp\/v2\/media?parent=4924"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/audiosupport.omsystem.com\/es\/wp-json\/wp\/v2\/categories?post=4924"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/audiosupport.omsystem.com\/es\/wp-json\/wp\/v2\/tags?post=4924"}],"curies":[{"name":"gracias","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}