The VPS server is hanging.
34 USD
A competent specialist who organized everything clearly during the consultation and promptly completed the task.
Maksym H.
Winning proposal
29
0
Budget: 1500 UAH Deadline: 1 day
Hello!
The problem is not with the external parser and not with the request limits — these are just symptoms. The server crashes due to MySQL overload from heavy SQL queries. It worked for 10 years, and now it has started — most likely, the product database has grown, the cache has failed, and the filter queries can no longer keep up.
I will start working on it right now. I will quickly diagnose, find the cause, and fix it. The server will stop hanging.
0
0
Budget: 10000 UAH Deadline: 10 days
Based on the provided htop screenshot, it can be concluded that your server is in a state of critical overload. As an administrator managing systems with root privileges, you have likely already noticed significant lag in operation. Here is a detailed analysis of key metrics:
1. Extreme Load (Load Average)
Load Average: 47.53, 44.80, 44.96.
The system has 4 cores (threads), as seen from the top indicators (1-4). For a 4-core system, the normal Load Average should be around 4.0. A figure of 47.53 means that the system is overloaded by approximately 11-12 times. Over 40 processes are constantly queued for execution, waiting for CPU availability.
2. CPU and Memory Status
CPU: All 4 cores are loaded at 100%. This is the system's bottleneck at this time.
RAM: 3.03 GB used out of 3.85 GB. Although there is still memory available, the remaining amount is small.
Swap: 0K/0K. There is no swap file or partition configured on the server at all. In the event of a spike in memory consumption by MySQL (which is the main consumer), the system may simply "crash" or start killing processes due to OOM Killer.
3. Process Analysis
The main factor of the load is MySQL (mysqld):
The process with PID 12866 is consuming 188% CPU (which is nearly two full cores in total).
The list shows a huge number of mysql threads, each consuming between 6% to 8% CPU.
There is also activity from nginx and user konstanti processes (likely PHP scripts via phpfarm), but they are secondary compared to the database.
There are several potential solutions.
41
4
Budget: 1000 UAH Deadline: 3 days
Good day!
We have encountered a problem with the VPS hanging due to high MySQL load, likely from an external parser. I am ready to analyze the logs and set up request limiting rules to stabilize the server's operation. I have experience in optimizing MySQL and configuring servers.
Message me privately, and we will clarify the details.
229
4
Budget: 800 UAH Deadline: 1 day
Hello
We have already collaborated
I will set everything up now
Message me privately
I will start right away
11
2
Budget: 1000 UAH Deadline: 1 day
Good day, I have successful experience in solving similar tasks, for discussion please write to me in private messages.
36
1
Budget: 2000 UAH Deadline: 1 day
Hello. I have a good understanding of VPS, and I can perform analysis on databases. Feel free to contact me, most often this can be overcome.
0
0
Budget: 12100 UAH Deadline: 2 days
Please let us know which hosting/panel you are currently using (cPanel/ISPmanager/other) and if Cloudflare is connected? Will you be able to provide access to the panel or at least screenshots from the latest MySQL load peaks — this is enough to identify the source of parsing and adjust the limits.
We have experience in quickly resolving such "hangs": we set up rate limiting and bot blocking (nginx/Cloudflare/fail2ban), connection limits, caching, as well as basic MySQL optimization (slow queries, indexes). We work with MySQL and Redis; Python/JS — 4 years in production.
We are ready to start today: we will conduct a short audit and immediately set rules so that MySQL does not overload the server. Write to us — we will agree on access and start.
The list does not show proposals concealed by the client or freelancer with a Plus profile, as well as proposals violating rules
