Maksym H.

Maksym H.

Winning proposal
24 0
  • Projects 24
  • Rating 5.0
  • Rating 3 006

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.

  • Projects -
  • Rating -
  • Rating 365

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):

  • Projects 43
  • Rating 4.6
  • Rating 4 975

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.

  • Projects 236
  • Rating 5.0
  • Rating 6 497

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

  • Projects 11
  • Rating 4.4
  • Rating 776

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.

  • Projects 35
  • Rating 5.0
  • Rating 1 323

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.

  • Projects -
  • Rating -
  • Rating 231

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.

Proposals concealed

The list does not show proposals concealed by the client or freelancer with a Plus profile, as well as proposals violating rules

Current freelance projects in the category Databases & SQL

3 July
2 July
1 July