Colapso base de datos y reinicio del servidor

[benja]

Buenas, de aqui a un tiempo se colapsa la base de datos de mi tienda prestashop. Los de soporte del hospedaje me dijeron que habian llamadas bloqueadas en la base de datos. 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 y al cabo de 3 dias vuelve a colapsarse la base de datos
No entiendo muy bien lo que quiere decir, si alguien me puede ayudar lo agradeceria.
Saludos!!

[benja]

Al final me dicen los del hosting:

"Estimado cliente,

Observando las caídas que ha sufrido su servidor en las últimos días, llegamos a la conclusión que el problema viene del buscador que hay en la tienda.
Por cada letra que se intoroduce intenta realizar una consulta a la base de datos, la cual se satura rápidamente con una simple búsqueda. Le aconsejamos que deshabilite dicho buscador, lo optimice o lo cambie.

Un saludo cordial,"

Como puedo solucionar este problema??

SAludos!!

[AMA1MD]

Si el buscador es el estandar de prestashop te aconsejo cambiar de proveedor de hosting.