{"id":1036,"date":"2021-11-05T17:57:00","date_gmt":"2021-11-05T16:57:00","guid":{"rendered":"https:\/\/juanfernandez.net\/?p=1036"},"modified":"2021-11-05T11:58:44","modified_gmt":"2021-11-05T10:58:44","slug":"haciendo-limpieza-en-la-base-de-datos-de-prestashop","status":"publish","type":"post","link":"https:\/\/fdev.es\/en\/haciendo-limpieza-en-la-base-de-datos-de-prestashop\/","title":{"rendered":"Haciendo limpieza en la base de datos de Prestashop"},"content":{"rendered":"<p>Esta semana enviamos un ticket a la empresa de hosting debido a la lentitud de las webs que tenemos alojadas en nuestra cuenta. Nos respondieron que se estaba consumiendo mucha CPU y que entre otros motivos, contribu\u00eda <strong>una base de datos que estaba ocupando demasiado espacio, m\u00e1s de 500 MB<\/strong>.<\/p>\n\n\n\n<p>Al revisar dicha base de datos, que pertenec\u00eda a un Prestashop 1.7, y ordenando las tablas por tama\u00f1o desde <em>Phpmyadmin<\/em>, me encontr\u00e9 con que algunas de esas tablas ocupaban m\u00e1s de 100 MB. Estas tablas en concreto eran dos:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><strong>ps_guest<\/strong>, relacionada con estad\u00edsticas de cuentas de invitado<\/li><li><strong>ps_connections<\/strong>, relacionada con estad\u00edsticas de fecha de conexi\u00f3n.<\/li><\/ul>\n\n\n\n<p>No es de extra\u00f1ar que estas tablas hayan acumulado muchos datos ya que es una tienda que recibe mucho tr\u00e1fico y tambi\u00e9n muchas ventas. <\/p>\n\n\n\n<p>Adem\u00e1s les segu\u00edan de cerca m\u00e1s tablas que ocupaban tambi\u00e9n bastante, pero sin superar los 100 MB. Eran las siguientes:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><strong>ps_connections_source<\/strong>, que guarda la url de la que procede una visita.<\/li><li><strong>ps_advice_lang<\/strong>, que guarda tips (los t\u00edpicos que emergen de un iconito de interrogante) del BO.<\/li><li><strong>ps_log<\/strong>, el registro de conexiones al BO.<\/li><li><strong>ps_statssearch<\/strong>, un registro de estad\u00edsticas de palabras introducidas en el buscador de la web.<\/li><\/ul>\n\n\n\n<p>Dejando a un lado la tabla <meta charset=\"utf-8\"><strong>ps_advice_lang<\/strong> que guarda informaci\u00f3n est\u00e1tica (no aumentar\u00e1 con el paso del tiempo) y que adem\u00e1s es propia de la documentaci\u00f3n de nuestra web, el resto de tablas podr\u00edan vaciarse sin afectar al funcionamiento de nuestra tienda online en Prestahsop, ya que son simplemente estad\u00edsticas.<\/p>\n\n\n\n<p>Evidentemente, <strong>si vaciamos todas estas tablas, nuestras estad\u00edsticas se perder\u00e1n<\/strong>, pero si usas Google Analytics u otro programa externo para registrar la actividad, puede que algunos o todos estos datos no te sean de utilidad.<\/p>\n\n\n\n<p>Tambi\u00e9n puedes <strong>filtrar por fecha y eliminar las estad\u00edsticas m\u00e1s antiguas<\/strong>, pero no olvides <strong>hacer una copia de seguridad de la base de datos,<\/strong> y no solo por seguridad, tambi\u00e9n para consultarla en caso de querer recuperar alg\u00fan dato del hist\u00f3rico.<\/p>","protected":false},"excerpt":{"rendered":"<p>Esta semana enviamos un ticket a la empresa de hosting debido a la lentitud de las webs que tenemos alojadas en nuestra cuenta. Nos respondieron que se estaba consumiendo mucha CPU y que entre otros motivos, contribu\u00eda una base de datos que estaba ocupando demasiado espacio, m\u00e1s de 500 MB. Al revisar dicha base de [&hellip;]<\/p>","protected":false},"author":1,"featured_media":1040,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_uag_custom_page_level_css":"","site-sidebar-layout":"default","site-content-layout":"default","ast-site-content-layout":"","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"default","adv-header-id-meta":"","stick-header-meta":"default","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[51,77],"tags":[79,78],"class_list":["post-1036","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-comercio-electronico","category-prestashop","tag-base-de-datos","tag-prestashop"],"acf":[],"uagb_featured_image_src":{"full":["https:\/\/fdev.es\/wp-content\/uploads\/2021\/11\/optimizar-base-de-datos-prestashop.jpg",1500,1000,false],"thumbnail":["https:\/\/fdev.es\/wp-content\/uploads\/2021\/11\/optimizar-base-de-datos-prestashop-150x150.jpg",150,150,true],"medium":["https:\/\/fdev.es\/wp-content\/uploads\/2021\/11\/optimizar-base-de-datos-prestashop-300x200.jpg",300,200,true],"medium_large":["https:\/\/fdev.es\/wp-content\/uploads\/2021\/11\/optimizar-base-de-datos-prestashop-768x512.jpg",768,512,true],"large":["https:\/\/fdev.es\/wp-content\/uploads\/2021\/11\/optimizar-base-de-datos-prestashop-1024x683.jpg",1024,683,true],"1536x1536":["https:\/\/fdev.es\/wp-content\/uploads\/2021\/11\/optimizar-base-de-datos-prestashop.jpg",1500,1000,false],"2048x2048":["https:\/\/fdev.es\/wp-content\/uploads\/2021\/11\/optimizar-base-de-datos-prestashop.jpg",1500,1000,false],"trp-custom-language-flag":["https:\/\/fdev.es\/wp-content\/uploads\/2021\/11\/optimizar-base-de-datos-prestashop.jpg",18,12,false],"woocommerce_thumbnail":["https:\/\/fdev.es\/wp-content\/uploads\/2021\/11\/optimizar-base-de-datos-prestashop-300x300.jpg",300,300,true],"woocommerce_single":["https:\/\/fdev.es\/wp-content\/uploads\/2021\/11\/optimizar-base-de-datos-prestashop-600x400.jpg",600,400,true],"woocommerce_gallery_thumbnail":["https:\/\/fdev.es\/wp-content\/uploads\/2021\/11\/optimizar-base-de-datos-prestashop-100x100.jpg",100,100,true]},"uagb_author_info":{"display_name":"Juan Fern\u00e1ndez M.","author_link":"https:\/\/fdev.es\/en\/author\/juanfz\/"},"uagb_comment_info":26,"uagb_excerpt":"Esta semana enviamos un ticket a la empresa de hosting debido a la lentitud de las webs que tenemos alojadas en nuestra cuenta. Nos respondieron que se estaba consumiendo mucha CPU y que entre otros motivos, contribu\u00eda una base de datos que estaba ocupando demasiado espacio, m\u00e1s de 500 MB. Al revisar dicha base de&hellip;","_links":{"self":[{"href":"https:\/\/fdev.es\/en\/wp-json\/wp\/v2\/posts\/1036","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/fdev.es\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/fdev.es\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/fdev.es\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/fdev.es\/en\/wp-json\/wp\/v2\/comments?post=1036"}],"version-history":[{"count":6,"href":"https:\/\/fdev.es\/en\/wp-json\/wp\/v2\/posts\/1036\/revisions"}],"predecessor-version":[{"id":1043,"href":"https:\/\/fdev.es\/en\/wp-json\/wp\/v2\/posts\/1036\/revisions\/1043"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/fdev.es\/en\/wp-json\/wp\/v2\/media\/1040"}],"wp:attachment":[{"href":"https:\/\/fdev.es\/en\/wp-json\/wp\/v2\/media?parent=1036"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/fdev.es\/en\/wp-json\/wp\/v2\/categories?post=1036"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/fdev.es\/en\/wp-json\/wp\/v2\/tags?post=1036"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}