Periodic freezing of the resource, incl. online store website
Good afternoon
For the last 4 weeks, we have had a problem with the site periodically freezing and the load on the server jumping up to 150%+, sometimes 250%+
at the same time, rebooting the database sometimes helps. Monitoring processes in various such freezes, I am attaching screenshots of loading in case of such failures
As far as I can see, an approximate request always jumps
"3199 db_chekho localhost db_chekhol 0 Query SELECT `shopproduct`.* FROM `shopproduct` WHERE (shopproduct.id IN (-1,9,10,11,12,16,17,28,30,31,32,33,39 ,54,55,56,57,58,60,61,62,63,64,65,67,68,70,71,72,73,74,75,76,77,78,79,80,81 ,82,83,85,90,98,99,100,101,1...
Please help me figure this out. It scares away all buyers and we ourselves cannot work at the same time
Original question is available on version: ru
For the last 4 weeks, we have had a problem with the site periodically freezing and the load on the server jumping up to 150%+, sometimes 250%+
at the same time, rebooting the database sometimes helps. Monitoring processes in various such freezes, I am attaching screenshots of loading in case of such failures
As far as I can see, an approximate request always jumps
"3199 db_chekho localhost db_chekhol 0 Query SELECT `shopproduct`.* FROM `shopproduct` WHERE (shopproduct.id IN (-1,9,10,11,12,16,17,28,30,31,32,33,39 ,54,55,56,57,58,60,61,62,63,64,65,67,68,70,71,72,73,74,75,76,77,78,79,80,81 ,82,83,85,90,98,99,100,101,1...
Please help me figure this out. It scares away all buyers and we ourselves cannot work at the same time
Answers:
most likely you have a DDoS attack.
you have to watch when it happens. Now I don't see the load
you have to watch when it happens. Now I don't see the load
19.10.2022, 17:39
Original comment available on version: ru
How can I organize this check or how can I capture the information you need?
The query itself is shopproduct.id IN (-1,9,10,11,12,16,17,28,30,31,32,33,39,54,55,56,57,58,60,61,62, 63,64,65,67,68,70,71,72,73,74,75,76,77,78,79,80,81,82,83,85,90,98,99,100,101,1..
what can mean? I understand that this is some kind of request for goods, right?
The query itself is shopproduct.id IN (-1,9,10,11,12,16,17,28,30,31,32,33,39,54,55,56,57,58,60,61,62, 63,64,65,67,68,70,71,72,73,74,75,76,77,78,79,80,81,82,83,85,90,98,99,100,101,1..
what can mean? I understand that this is some kind of request for goods, right?
24.10.2022, 10:06
Original comment available on version: ru
I understand that you need to take the time to understand the current problem. Willing to pay for the time spent.
24.10.2022, 10:10
Original comment available on version: ru
Please join the conversation. If you have something to say - please write a comment. You will need a mobile phone and an SMS code for identification to enter.
Log in and comment
Copyright © OneBox 2024
