tipuce

Boujour, J'ai un gros soucis avec mon site www.scrapdeco.com, mon hebergeur a déplacé mon site sur un serveur de maintenance suite a une consommation excessive des ressources du serveur mutualisé. il apparait que notre site génére environ 800 requête Mysql par seconde et cela sature la base de données. quelqu'un peut il m'apporter une solution svp cela fait 6 jours que le site ne fonctionne plus normalement. Merci d'avance de votre aide Site: www.scrapdeco.com hebergeur: infomaniak Prestashop : 1.4.8.2 Voici le message de mon hebergeur On Wed, 10 Feb 2016, [email protected] wrote: > Cher client, > > Merci pour votre message et pour vos actions. > > Nous ne pouvons savoir quelle partie du code pose problème. > > Cependant nous pouvons vous fournir les détails des requêtes créées > par ce code : > > 29979 mysladmin localhost scrapdecocom4 Query 3 Sending data SELECT > p.`id_product` id_product\n\t\tFROM `ps_product` p\n\t\t\n\t\t INNER > JOIN ps_category_product cp\n\t\t\t\tON p.id_product = > cp.id_product\n\t\t\t\tINNER JOIN ps_category c ON (c.id_category = > cp.id_category AND\n\t\t\t\tc.nleft >= 354\n\t\t\t\tAND c.nright <= > 355\n\t\t\t\tAND c.active = 1)\n\t\tWHERE 1 AND p.`active` = 1 AND > p.id_product IN (SELECT `id_product` FROM `ps_feature_product` fp > WHERE fp.`id_feature_value` = 4487 OR fp.`id_feature_value` = 4638 OR > fp.`id_feature_value` = 4649 OR fp.`id_feature_value` = 4505 OR > fp.`id_feature_value` = 4655 OR fp.`id_feature_value` = 4512 OR > fp.`id_feature_value` = 4571 OR fp.`id_feature_value` = 4472 OR > fp.`id_feature_value` = 4662 OR fp.`id_feature_value` = 4918 OR > fp.`id_feature_value` = 4635 OR fp.`id_feature_value` = 4785 OR > fp.`id_feature_value` = 4585 OR fp.`id_feature_value` = 4607 OR > fp.`id_feature_value` = 4946) GROUP BY id_product > 29980 mysladmin localhost scrapdecocom4 Query 1 Sending data SELECT > p.`id_product` id_product\n\t\tFROM `ps_product` p\n\t\t\n\t\t INNER > JOIN ps_category_product cp\n\t\t\t\tON p.id_product = > cp.id_product\n\t\t\t\tINNER JOIN ps_category c ON (c.id_category = > cp.id_category AND\n\t\t\t\tc.nleft >= 354\n\t\t\t\tAND c.nright <= > 355\n\t\t\t\tAND c.active = 1)\n\t\tWHERE 1 AND p.`active` = 1 AND > p.id_product IN (SELECT `id_product` FROM `ps_feature_product` fp > WHERE fp.`id_feature_value` = 4586 OR fp.`id_feature_value` = 4487 OR > fp.`id_feature_value` = 4794 OR fp.`id_feature_value` = 4583 OR > fp.`id_feature_value` = 4561 OR fp.`id_feature_value` = 4824 OR > fp.`id_feature_value` = 4512 OR fp.`id_feature_value` = 4592 OR > fp.`id_feature_value` = 4571 OR fp.`id_feature_value` = 4620 OR > fp.`id_feature_value` = 4918 OR fp.`id_feature_value` = 4635 OR > fp.`id_feature_value` = 4631 OR fp.`id_feature_value` = 4489) GROUP BY > id_product 29982 mysladmin localhost scrapdecocom4 Query 1 Sending > data SELECT p.`id_product` id_product\n\t\tFROM `ps_product` p\n\t\t\n\t\t > INNER JOIN ps_category_product cp\n\t\t\t\tON p.id_product = > cp.id_product\n\t\t\t\tINNER JOIN ps_category c ON (c.id_category = > cp.id_category AND\n\t\t\t\tc.nleft >= 354\n\t\t\t\tAND c.nright <= > 355\n\t\t\t\tAND c.active = 1)\n\t\tWHERE 1 AND p.`active` = 1 AND > p.id_product IN (SELECT `id_product` FROM `ps_feature_product` fp > WHERE fp.`id_feature_value` = 4569 OR fp.`id_feature_value` = 4940 OR > fp.`id_feature_value` = 4526 OR fp.`id_feature_value` = 4622 OR > fp.`id_feature_value` = 4479 OR fp.`id_feature_value` = 4938 OR > fp.`id_feature_value` = 4628 OR fp.`id_feature_value` = 4618 OR > fp.`id_feature_value` = 4555 OR fp.`id_feature_value` = 4571 OR > fp.`id_feature_value` = 4461 OR fp.`id_feature_value` = 4592) GROUP BY > id_product 29993 mysladmin localhost scrapdecocom4 Query 1 Sending > data SELECT fl.name feature_name, fp.id_feature, fv.id_feature_value, > fvl.value,\n\t\t\t\t\tCOUNT(DISTINCT p.id_product) > nbr,\n\t\t\t\t\tlifl.url_name name_url_name, lifl.meta_title > name_meta_title, lifvl.url_name value_url_name, lifvl.meta_title > value_meta_title , m.name, psi.price_min, > psi.price_max\n\n\t\t\t\t\tFROM ps_feature_product fp\n\t\t\t\t\tINNER > JOIN ps_product p ON (p.id_product = fp.id_product)\n\t\t\t\t\tLEFT > JOIN ps_feature_lang fl ON (fl.id_feature = fp.id_feature AND > fl.id_lang = 1)\n\t\t\t\t\tINNER JOIN ps_feature_value fv ON > (fv.id_feature_value = fp.id_feature_value AND (fv.custom IS NULL OR > fv.custom = 0))\n\t\t\t\t\tLEFT JOIN ps_feature_value_lang fvl ON > (fvl.id_feature_value = fp.id_feature_value AND fvl.id_lang = > 1)\n\t\t\t\t\tLEFT JOIN ps_layered_indexable_feature_lang_value > lifl\n\t\t\t\t\tON (lifl.id_feature = fp.id_feature AND lifl.id_lang = > 1)\n\t\t\t\t\tLEFT JOIN ps_layered_indexable_feature_value_lang_value > lifvl\n\t\t\t\t\tON (lifvl.id_feature_value = fp.id_feature_value AND > lifvl.id_lang = 1) \nLEFT JOIN `ps_manufacturer` m ON > (m.id_manufacturer = > p.id_manufacturer) \n\t\t\tINNER JOIN `ps_layered_price_index` psi > \n\t\t\tON (psi.id_product = p.id_product AND psi.id_currency = 4) > \nWHERE p.`active` = 1 AND fp.id_feature = 5\n\t\t\t\t\tAND > p.id_product IN (\n\t\t\t\t\tSELECT id_product\n\t\t\t\t\tFROM > ps_category_product cp\n\t\t\t\t\tINNER JOIN ps_category c ON > (c.id_category = cp.id_category AND\n\t\t\t\t\tc.nleft >= > 354\n\t\t\t\t\tAND c.nright <= 355\n\t\t\t\t\tAND c.active = 1)) AND > p.id_product IN (SELECT id_product FROM ps_feature_product fp WHERE > fp.`id_feature_value` = 4586 OR fp.`id_feature_value` = 4487 OR > fp.`id_feature_value` = 4580 OR fp.`id_feature_value` = 4794 OR > fp.`id_feature_value` = 4583 OR fp.`id_feature_value` = 4592 OR > fp.`id_feature_value` = 4611 OR fp.`id_feature_value` = 4571 OR > fp.`id_feature_value` = 4652 OR fp.`id_feature_value` = 4590 OR > fp.`id_feature_value` = 4635 OR fp.`id_feature_value` = 4785 OR > fp.`id_feature_value` = 4464) \nGROUP BY fv.id_feature_value ORDER BY fvl.value ASC > 29996 mysladmin localhost scrapdecocom4 Query 2 Sending data SELECT > m.name, COUNT(DISTINCT p.id_product) nbr, m.id_manufacturer , m.name, > psi.price_min, psi.price_max\n\n\t\t\t\t\tFROM `ps_category_product` > cp\n\t\t\t\t\tINNER JOIN `ps_category` c ON (c.id_category = > cp.id_category)\n\t\t\t\t\tINNER JOIN ps_product p ON (p.id_product = > cp.id_product)\n\t\t\t\t\tINNER JOIN ps_manufacturer m ON > (m.id_manufacturer = p.id_manufacturer) \n\n\t\t\tINNER JOIN > `ps_layered_price_index` psi \n\t\t\tON (psi.id_product = p.id_product > AND psi.id_currency = 4) \nWHERE \n\t\t\t\t\tc.nleft >= > 354\n\t\t\t\t\tAND c.nright <= 355\n\t\t\t\t\tAND c.active = > 1\n\t\t\t\t\tAND p.active = 1 AND p.id_product IN (SELECT id_product > FROM ps_feature_product fp WHERE fp.`id_feature_value` = 4495 OR > fp.`id_feature_value` = 4638 OR fp.`id_feature_value` = 4525 OR > fp.`id_feature_value` = 4883 OR fp.`id_feature_value` = 4560 OR > fp.`id_feature_value` = 4512 OR fp.`id_feature_value` = 4437 OR > fp.`id_feature_value` = 4571 OR fp.`id_feature_value` = 4669 OR > fp.`id_feature_value` = 4472 OR fp.`id_feature_value` = 4635 OR > fp.`id_feature_value` = 4585 OR fp.`id_feature_value` = 4607 OR > fp.`id_feature_value` = 4452 OR fp.`id_feature_value` = 4647) \n GROUP > BY p.id_manufacturer ORDER BY m.name > > > Vous pouvez aussi voir ces requêtes en temps-réel via l'interface > phpMyAdmin, ou bien consulter vos slowlogs mysql.

re bonsoir, Quelqun peut'il m' aider svp ou m'indiquer ou je pourrais avoir des infos? Merci d'avance

Bonjour Suite à l'annonce de la mise à jour de sécurité, je souhaitais mettre à jour mon shop via le module 1 clic upgrade pour passer de ma ver actuel 1.4.8.2 à la ver 1.4.11.1. La mise à jour n'a pas fonctioné voici le message d'erreur aparaissant lors du lancement de la mise à jour Erreur Javascript (parseJSON) détectée pour l'action"upgradeNow".Début de la restauration ... Je ne me sens pas sur pour effectuer une mise à jour manuelle et même que cela me stress un max. Quelqu'un peut'il m'indiquer que fairfe pour applique la mise a jour de sécurité a mon shop ? Merci d'avance