Witam
Serwerownia zablokowała mi Prestę ze względu na zbyt duże obciążenie bazy danych. Kopiuje cała tresć maila, poradźcie mi czy rzeczywiście na sklepie jest coś nie tak czy po prostu presta ma to do siebie, po oględzinach nadesłanych zapytań niczego nadzwyczajnego nie widzę, ale ja się słabo znam, (Usunąłem nazwy baz serwerów i userów z poniższego tekstu):
Pragnę Państwa poinformować, iż w ramach Państwa konta pracują skrypty
powodujące nadmierną utylizację bazy danych poprzez ciągłe
przeszukiwanie bazy danych. Poniżej wklejam przykładowe zapytania:
3046743 (...DB_NAME...) (...SERVER...) (...DB_USER...) Query
7014 Sending data SELECT al.name FROM ps_product_attribute
pa\n\t\tLEFT JOIN ps_product_attribute_combination pac ON
pa.id_product_attribute = pac.id_product_attribute\n\t\tLEFT JOIN
ps_attribute_lang al ON (pac.id_attribute = al.id_attribute AND
al.id_lang = 1)\n\t\tWHERE pa.id_product = 70
3047644 (...DB_NAME...) (...SERVER...) (...DB_USER...) Query
6949 Sending data SELECT al.name FROM ps_product_attribute
pa\n\t\tLEFT JOIN ps_product_attribute_combination pac ON
pa.id_product_attribute = pac.id_product_attribute\n\t\tLEFT JOIN
ps_attribute_lang al ON (pac.id_attribute = al.id_attribute AND
al.id_lang = 1)\n\t\tWHERE pa.id_product = 70
3048072 (...DB_NAME...) (...SERVER...) (...DB_USER...) Query
6910 Sending data SELECT al.name FROM ps_product_attribute
pa\n\t\tLEFT JOIN ps_product_attribute_combination pac ON
pa.id_product_attribute = pac.id_product_attribute\n\t\tLEFT JOIN
ps_attribute_lang al ON (pac.id_attribute = al.id_attribute AND
al.id_lang = 1)\n\t\tWHERE pa.id_product = 70
3048670 (...DB_NAME...) (...SERVER...) (...DB_USER...) Query
6866 Sending data SELECT al.name FROM ps_product_attribute
pa\n\t\tLEFT JOIN ps_product_attribute_combination pac ON
pa.id_product_attribute = pac.id_product_attribute\n\t\tLEFT JOIN
ps_attribute_lang al ON (pac.id_attribute = al.id_attribute AND
al.id_lang = 1)\n\t\tWHERE pa.id_product = 70
3050732 (...DB_NAME...) (...SERVER...) (...DB_USER...) Query
6782 Sending data SELECT al.name FROM ps_product_attribute
pa\n\t\tLEFT JOIN ps_product_attribute_combination pac ON
pa.id_product_attribute = pac.id_product_attribute\n\t\tLEFT JOIN
ps_attribute_lang al ON (pac.id_attribute = al.id_attribute AND
al.id_lang = 1)\n\t\tWHERE pa.id_product = 70
3052262 (...DB_NAME...) (...SERVER...) (...DB_USER...) Query
6688 Sending data SELECT al.name FROM ps_product_attribute
pa\n\t\tLEFT JOIN ps_product_attribute_combination pac ON
pa.id_product_attribute = pac.id_product_attribute\n\t\tLEFT JOIN
ps_attribute_lang al ON (pac.id_attribute = al.id_attribute AND
al.id_lang = 1)\n\t\tWHERE pa.id_product = 70
3053979 (...DB_NAME...) (...SERVER...) (...DB_USER...) Query
6574 Sending data SELECT al.name FROM ps_product_attribute
pa\n\t\tLEFT JOIN ps_product_attribute_combination pac ON
pa.id_product_attribute = pac.id_product_attribute\n\t\tLEFT JOIN
ps_attribute_lang al ON (pac.id_attribute = al.id_attribute AND
al.id_lang = 1)\n\t\tWHERE pa.id_product = 70
3057405 (...DB_NAME...) (...SERVER...) (...DB_USER...) Query
6428 Sending data SELECT al.name FROM ps_product_attribute
pa\n\t\tLEFT JOIN ps_product_attribute_combination pac ON
pa.id_product_attribute = pac.id_product_attribute\n\t\tLEFT JOIN
ps_attribute_lang al ON (pac.id_attribute = al.id_attribute AND
al.id_lang = 1)\n\t\tWHERE pa.id_product = 70
3065794 (...DB_NAME...) (...SERVER...) (...DB_USER...) Query
5900 Sending data SELECT al.name FROM ps_product_attribute
pa\n\t\tLEFT JOIN ps_product_attribute_combination pac ON
pa.id_product_attribute = pac.id_product_attribute\n\t\tLEFT JOIN
ps_attribute_lang al ON (pac.id_attribute = al.id_attribute AND
al.id_lang = 1)\n\t\tWHERE pa.id_product = 70
3066502 (...DB_NAME...) (...SERVER...) (...DB_USER...) Query
5863 Sending data SELECT al.name FROM ps_product_attribute
pa\n\t\tLEFT JOIN ps_product_attribute_combination pac ON
pa.id_product_attribute = pac.id_product_attribute\n\t\tLEFT JOIN
ps_attribute_lang al ON (pac.id_attribute = al.id_attribute AND
al.id_lang = 1)\n\t\tWHERE pa.id_product = 70
3067109 (...DB_NAME...) (...SERVER...) (...DB_USER...) Query
5830 Sending data SELECT al.name FROM ps_product_attribute
pa\n\t\tLEFT JOIN ps_product_attribute_combination pac ON
pa.id_product_attribute = pac.id_product_attribute\n\t\tLEFT JOIN
ps_attribute_lang al ON (pac.id_attribute = al.id_attribute AND
al.id_lang = 1)\n\t\tWHERE pa.id_product = 70
3068243 f99378fb_sklep porewit.az.pl:61408 f99378fb_meble Query
5769 Sending data SELECT al.name FROM ps_product_attribute
pa\n\t\tLEFT JOIN ps_product_attribute_combination pac ON
pa.id_product_attribute = pac.id_product_attribute\n\t\tLEFT JOIN
ps_attribute_lang al ON (pac.id_attribute = al.id_attribute AND
al.id_lang = 1)\n\t\tWHERE pa.id_product = 70
3069261 (...DB_NAME...) (...SERVER...) (...DB_USER...) Query
5715 Sending data SELECT al.name FROM ps_product_attribute
pa\n\t\tLEFT JOIN ps_product_attribute_combination pac ON
pa.id_product_attribute = pac.id_product_attribute\n\t\tLEFT JOIN
ps_attribute_lang al ON (pac.id_attribute = al.id_attribute AND
al.id_lang = 1)\n\t\tWHERE pa.id_product = 70
3071251 (...DB_NAME...) (...SERVER...) (...DB_USER...) Query
5600 Sending data SELECT al.name FROM ps_product_attribute
pa\n\t\tLEFT JOIN ps_product_attribute_combination pac ON
pa.id_product_attribute = pac.id_product_attribute\n\t\tLEFT JOIN
ps_attribute_lang al ON (pac.id_attribute = al.id_attribute AND
al.id_lang = 1)\n\t\tWHERE pa.id_product = 70
3074413 (...DB_NAME...) (...SERVER...) (...DB_USER...) Query
5413 Sending data SELECT al.name FROM ps_product_attribute
pa\n\t\tLEFT JOIN ps_product_attribute_combination pac ON
pa.id_product_attribute = pac.id_product_attribute\n\t\tLEFT JOIN
ps_attribute_lang al ON (pac.id_attribute = al.id_attribute AND
al.id_lang = 1)\n\t\tWHERE pa.id_product = 70
3076632 (...DB_NAME...) (...SERVER...) (...DB_USER...) Query
5306 Sending data SELECT al.name FROM ps_product_attribute
pa\n\t\tLEFT JOIN ps_product_attribute_combination pac ON
pa.id_product_attribute = pac.id_product_attribute\n\t\tLEFT JOIN
ps_attribute_lang al ON (pac.id_attribute = al.id_attribute AND
al.id_lang = 1)\n\t\tWHERE pa.id_product = 70
3082213 (...DB_NAME...) (...SERVER...) (...DB_USER...) Query
5032 Sending data SELECT al.name FROM ps_product_attribute
pa\n\t\tLEFT JOIN ps_product_attribute_combination pac ON
pa.id_product_attribute = pac.id_product_attribute\n\t\tLEFT JOIN
ps_attribute_lang al ON (pac.id_attribute = al.id_attribute AND
al.id_lang = 1)\n\t\tWHERE pa.id_product = 70
3085076 (...DB_NAME...) (...SERVER...) (...DB_USER...) Query
4949 Sending data SELECT al.name FROM ps_product_attribute
pa\n\t\tLEFT JOIN ps_product_attribute_combination pac ON
pa.id_product_attribute = pac.id_product_attribute\n\t\tLEFT JOIN
ps_attribute_lang al ON (pac.id_attribute = al.id_attribute AND
al.id_lang = 1)\n\t\tWHERE pa.id_product = 70
3086176 (...DB_NAME...) (...SERVER...) (...DB_USER...) Query
4906 Sending data SELECT al.name FROM ps_product_attribute
pa\n\t\tLEFT JOIN ps_product_attribute_combination pac ON
pa.id_product_attribute = pac.id_product_attribute\n\t\tLEFT JOIN
ps_attribute_lang al ON (pac.id_attribute = al.id_attribute AND
al.id_lang = 1)\n\t\tWHERE pa.id_product = 70
3086608 (...DB_NAME...) (...SERVER...) (...DB_USER...) Query
4887 Sending data SELECT al.name FROM ps_product_attribute
pa\n\t\tLEFT JOIN ps_product_attribute_combination pac ON
pa.id_product_attribute = pac.id_product_attribute\n\t\tLEFT JOIN
ps_attribute_lang al ON (pac.id_attribute = al.id_attribute AND
al.id_lang = 1)\n\t\tWHERE pa.id_product = 70
3088790 (...DB_NAME...) (...SERVER...) (...DB_USER...) Query
4790 Sending data SELECT al.name FROM ps_product_attribute
pa\n\t\tLEFT JOIN ps_product_attribute_combination pac ON
pa.id_product_attribute = pac.id_product_attribute\n\t\tLEFT JOIN
ps_attribute_lang al ON (pac.id_attribute = al.id_attribute AND
al.id_lang = 1)\n\t\tWHERE pa.id_product = 70
3122494 (...DB_NAME...) (...SERVER...) (...DB_USER...) Query
2587 Sending data SELECT al.name FROM ps_product_attribute
pa\n\t\tLEFT JOIN ps_product_attribute_combination pac ON
pa.id_product_attribute = pac.id_product_attribute\n\t\tLEFT JOIN
ps_attribute_lang al ON (pac.id_attribute = al.id_attribute AND
al.id_lang = 1)\n\t\tWHERE pa.id_product = 70
3147236 (...DB_NAME...) (...SERVER...) (...DB_USER...) Query
606 Sending data SELECT al.name FROM ps_product_attribute
pa\n\t\tLEFT JOIN ps_product_attribute_combination pac ON
pa.id_product_attribute = pac.id_product_attribute\n\t\tLEFT JOIN
ps_attribute_lang al ON (pac.id_attribute = al.id_attribute AND
al.id_lang = 1)\n\t\tWHERE pa.id_product = 70
W związku z powyższym działanie serwisu zostało wyłączone poprzez zmianę
nazwy katalogu public_html na public_html_off. Uprzejmie proszę o
podjęcie działań mających na celu optymalizacje zapytań SQL, oraz
pozakładania odpowiednich indeksów.
W przypadku nie podjęcia żadnych działań konto hostingowego po terminie
7 dni zostanie administracyjnie zablokowane.
Uprzejmie proszę również o potwierdzenie wykonanych zmian.
Proszę o szybka odpowiedź.
Pozdrawiam