The VPS server is hanging.
34 USD I have encountered a problem lately where the server constantly hangs and needs to be restarted, support says:
You always have the same problem. MYSQL is overloading your server - https://prnt.sc/n1SXzl2r1duR
The load from the websites is simply ridiculous, they are likely created by some external parser, as the problem appeared recently, and everything was fine for years before that. It is necessary to create some kind of rule to limit the number of requests.
Client's review of cooperation with Maksym H.
The VPS server is hanging.A competent specialist who organized everything clearly during the consultation and promptly completed the task.
Freelancer's review of cooperation with Konstantin Podushkin
The VPS server is hanging.Thank you for your trust and cooperation. I worked with pleasure, everything was clear and adequate.
-
Winning proposal1 day34 USD
3061 23 0 Winning proposal1 day34 USD
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.
-
10 days226 USD
365 10 days226 USD
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.
-
3 days23 USD
4987 41 4 1 3 days23 USD
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.
-
1 day18 USD
6495 229 4 7 1 day18 USD
Hello
We have already collaborated
I will set everything up now
Message me privately
I will start right away
-
1 day23 USD
776 11 2 1 day23 USD
Good day, I have successful experience in solving similar tasks, for discussion please write to me in private messages.
-
1 day45 USD
1267 35 1 1 day45 USD
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.
-
2 days273 USD
231 2 days273 USD
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.
-
Доброго дня.
Підкажіть:
1. Який у вас хостинг?
2. Скільки у вас сайтів на VPS і яка у них CMS.
Дякую.
-
Current freelance projects in the category Databases & SQL
Need a Power BI specialist to build management reporting based on BAS Accounting CORP
About the CompanyWe are a distributor of international sports brands in Ukraine. Accounting is maintained in BAS Accounting CORP.We are looking for a specialist who can help build a management reporting system for the company's management based on Power BI.Important: we are… Databases & SQL, Accounting Services ∙ 1 day 1 hour back ∙ 3 proposals |
Technical task: Integration of Telegram chatbot with BAS1. General Description It is necessary to implement the integration of the chatbot with the BAS system for the transfer and recording of data about products (orders). 2. Input Data (sent by the chatbot): Group ID Product name (with product code) Product price 3. Logic of… Enterprise Resource Planning (ERP), Databases & SQL ∙ 1 day 4 hours back ∙ 17 proposals |
1C data integration
Organize quality preparation and data transfer from 1C to BigQuery for further use in Looker:Organize the data according to the required fields.Prepare a clear structure of tables and intermediate datasets on which dashboards will be built.Set up data loading, gather key… Databases & SQL, Data Processing ∙ 2 days 19 hours back ∙ 9 proposals |
Development of a simple controlling and management record system in Google Sheets "turnkey"
Task name: Development of a simple controlling and management record system in Google Sheets "turnkey" for a construction company in Poland (+ online training and implementation assistance) About the company, context, and my main problem Hello, I am looking for an experienced… Databases & SQL, Accounting Services ∙ 4 days back ∙ 36 proposals |
Development of an analytical Power BI dashboard
45 USD
This is our request, we need a person who understands Power BI: Screen 1: Strategic Cockpit (Financial Health of the Plant) Goal: To understand in 5 seconds, "where are we losing money and how much?". KPI Tiles (Top Bar): Overall margin (Actual vs Plan) in %. Amount of "lost… Databases & SQL ∙ 4 days 4 hours back ∙ 13 proposals |
Kyiv