Buenas,

De aqui a un tiempo se cae la base de datos de mi tienda prestashop 1.4.6.2.

Los de soporte del hospedaje (cyberneticos.com) me dijeron que al realizar busquedas en la tienda se bloqueaban las llamadas en la base de datos hasta que se caia.

Me enviaron este archivo:

——————————-+—————-+———————+————-+———-+———————+———————————————————————————————————————————————————+ | Id | User | Host | db | Command | Time | State | Info | ——————————-+—————-+———————+————-+———-+———————+———————————————————————————————————————————————————+ | 361192 | tienda_shop | localhost | tienda_spain | Query | 31819 | Sending data | SELECT DISTINCT cp.`id_product` FROM `ps_category_group` cg INNER JOIN `ps_category_product` cp | | 361194 | tienda_shop | localhost | tienda_spain | Query | 31819 | Sending data | SELECT DISTINCT cp.`id_product` FROM `ps_category_group` cg INNER JOIN `ps_category_product` cp | | 380070 | tienda_shop | localhost | tienda_spain | Query | 11541 | Locked | TRUNCATE ps_search_index | | 380146 | tienda_shop | localhost | tienda_spain | Query | 11481 | Locked | SELECT DISTINCT cp.`id_product` FROM `ps_category_group` cg INNER JOIN `ps_category_product` cp | | 384977 | tienda_shop | localhost | tienda_spain | Query | 7590 | Locked | DELETE FROM ps_search_index WHERE id_product IN (59541,59542,59543,59544,59545,59546,59547,59548,595 | | 385322 | tienda_shop | localhost | tienda_spain | Query | 7205 | Locked | DELETE FROM ps_search_index WHERE id_product IN (59541,59542,59543,59544,59545,59546,59547,59548,595 | | 386816 | tienda_shop | localhost | tienda_spain | Query | 5900 | Locked | SELECT DISTINCT cp.`id_product` FROM `ps_category_group` cg INNER JOIN `ps_category_product` cp | | 386817 | tienda_shop | localhost | tienda_spain | Query | 5900 | Locked | SELECT DISTINCT cp.`id_product` FROM `ps_category_group` cg INNER JOIN `ps_category_product` cp | | 386818 | tienda_shop | localhost | tienda_spain | Query | 5899 | Locked | SELECT DISTINCT cp.`id_product` FROM `ps_category_group` cg INNER JOIN `ps_category_product` cp | | 386861 | tienda_shop | localhost | tienda_spain | Query | 5844 | Locked | SELECT DISTINCT cp.`id_product` FROM `ps_category_group` cg INNER JOIN `ps_category_product` cp | | 386881 | tienda_shop | localhost | tienda_spain | Query | 5827 | Locked | SELECT DISTINCT cp.`id_product` FROM `ps_category_group` cg INNER JOIN `ps_category_product` cp | | 386924 | tienda_shop | localhost | tienda_spain | Query | 5797 | Locked | SELECT DISTINCT cp.`id_product` FROM `ps_category_group` cg INNER JOIN `ps_category_product` cp | | 387780 | tienda_shop | localhost | tienda_spain | Query | 4739 | Locked | SELECT DISTINCT cp.`id_product` FROM `ps_category_group` cg INNER JOIN `ps_category_product` cp | | 387781 | tienda_shop | localhost | tienda_spain | Query | 4738 | Locked | SELECT DISTINCT cp.`id_product` FROM `ps_category_group` cg INNER JOIN `ps_category_product` cp | | 387782 | tienda_shop | localhost | tienda_spain | Query | 4738 | Locked | SELECT DISTINCT cp.`id_product` FROM `ps_category_group` cg INNER JOIN `ps_category_product` cp | | 387783 | tienda_shop | localhost | tienda_spain | Query | 4737 | Locked | SELECT DISTINCT cp.`id_product` FROM `ps_category_group` cg INNER JOIN `ps_category_product` cp | | 387784 | tienda_shop | localhost | tienda_spain | Query | 4737 | Locked | SELECT DISTINCT cp.`id_product` FROM `ps_category_group` cg INNER JOIN `ps_category_product` cp | | 387785 | tienda_shop | localhost | tienda_spain | Query | 4735 | Locked | SELECT DISTINCT cp.`id_product` FROM `ps_category_group` cg INNER JOIN `ps_category_product` cp | | 387786 | tienda_shop | localhost | tienda_spain | Query | 4735 | Locked | SELECT DISTINCT cp.`id_product` FROM `ps_category_group` cg INNER JOIN `ps_category_product` cp | | 387787 | tienda_shop | localhost | tienda_spain | Query | 4735 | Locked | SELECT DISTINCT cp.`id_product` FROM `ps_category_group` cg INNER JOIN `ps_category_product` cp | | 387788 | tienda_shop | localhost | tienda_spain | Query | 4734 | Locked | SELECT DISTINCT cp.`id_product` FROM `ps_category_group` cg INNER JOIN `ps_category_product` cp | | 387789 | tienda_shop | localhost | tienda_spain | Query | 4734 | Locked | SELECT DISTINCT cp.`id_product` FROM `ps_category_group` cg INNER JOIN `ps_category_product` cp | | 387790 | tienda_shop | localhost | tienda_spain | Query | 4734 | Locked | SELECT DISTINCT cp.`id_product` FROM `ps_category_group` cg INNER JOIN `ps_category_product` cp | | 387791 | tienda_shop | localhost | tienda_spain | Query | 4734 | Locked | SELECT DISTINCT cp.`id_product` FROM `ps_category_group` cg INNER JOIN `ps_category_product` cp | | 387792 | tienda_shop | localhost | tienda_spain | Query | 4733 | Locked | SELECT DISTINCT cp.`id_product` FROM `ps_category_group` cg INNER JOIN `ps_category_product` cp | | 387795 | tienda_shop | localhost | tienda_spain | Query | 4732 | Locked | SELECT DISTINCT cp.`id_product` FROM `ps_category_group` cg INNER JOIN `ps_category_product` cp | | 396035 | root | localhost | | Query | 0 | | show processlist | —————

Siempre se tiene que reiniciar el servidor vuelve a la normalidad y al cabo de 3 dias o incluso despues de una horas se vuelve a colapsarse la base de datos.

Tengo instalado el modulo memcached pero sigue igual.

Me recomendaron cambiar de hosting pero no quiero perder el posicionamiento de google asi que prefiero buscar otra solucion como optimizar la base de datos.

Espero vuestro presupuesto

Saludos!!