Maksym H.
Winning proposal- 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.
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.
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.
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
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.
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.
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
Proposals are currently absent
Proposals concealed
-
Serhii Motchany 4 MayДоброго дня.
Підкажіть:
1. Який у вас хостинг?
2. Скільки у вас сайтів на VPS і яка у них CMS.
Дякую.
Current freelance projects in the category Databases & SQL
Hello There is a small department where patients are admitted. It is necessary to develop a simple "database" where consumables, medications, and others can be entered, along with incoming and outgoing records, as well as assigning usage to a specific patient. Required functionality Directories Medications Consumables (manual entry option) Patients (ability to continuously add new ones and delete those who have been discharged) Employees (ability to modify)Movement Accounting A single table (movement log) where everything is registered Incoming and write-off Manual correction option When writing off, the nurse must select: date; patient; medication or material; quantity; her full name. The system automatically reduces the balance. When receiving, the head nurse must be able to enter: Delivery date; Medication/material; Remaining quantity; Source; Expiration dateAutomatic Functionality automatic balance calculation; minimum stock control; expiration date control; low stock warnings; protection against writing off more than is available; drop-down lists; data entry validation; conditional formatting.Reports It is necessary to implement automatic reports: current balances; usage over a period; usage by patient; usage by employee; history of movement of a specific medication.Preferred implementation on Google Sheets; We will fill in the databases ourselves. A template for work is needed. I don't know how much this costs, so let's start with $50, and you can suggest your options, preferably with experience.
C# / .NET WPF Developer – Completion of Migration of a Large Invoicing Program RAFSOFT.NET Sp. z o.o. is looking for a C# / .NET developer to complete the rewriting of a large, long-standing invoicing program to a new technology. The project involves the migration of an extensive desktop application for companies, used for invoicing, handling sales documents, contractors, records, and accounting-tax functions. The new version of the program is being created in C# / .NET, using DevExpress components. The project is already about 70% rewritten. We are looking for someone who can help bring it to completion, organize the missing elements, perform tests, and ensure the new version operates in accordance with the existing program. Scope of Work: completion of the migration of a large desktop application to C# / .NET, recreation of the functionality of the old program in the new version, maintaining as identical logic of operation, appearance, and handling as possible, working with DevExpress components, analyzing existing code and comparing the operation of the old and new versions of the program, fixing bugs, completing missing functions, and testing the application, collaborating on the final preparation of the program for deployment. Requirements: very good knowledge of C# and .NET, experience in creating desktop applications for Windows, knowledge of WPF or WinForms, experience with DevExpress or similar UI component libraries, ability to analyze a large existing project, accuracy and patience in reproducing existing functionality, ability to test one's own changes, very good ability to use AI tools supporting programming, code analysis, refactoring, and testing. Preferred: experience with legacy projects, knowledge of or previous work with Visual Basic 6.0, experience in migrating applications from older technologies to C# / .NET, knowledge of issues related to invoicing, accounting, JPK, or KSeF, experience working with large business applications. Who We Are Looking For: We are looking for a self-sufficient, precise, and technically experienced person who can enter an existing project, understand its logic, and consistently bring it to completion. In this project, it is very important not only to write new code but also to faithfully reproduce the operation of the old program — both in terms of functionality and appearance as well as handling. We also require proficiency in using AI tools in daily programming work. We are looking for someone who can use AI practically: for code analysis, bug finding, speeding up migration, creating tests, and organizing the project. About the Company: RAFSOFT.NET Sp. z o.o. is a Polish company creating software for entrepreneurs, accounting offices, and small and medium-sized enterprises. Our main product is the VAT Invoice program, supporting the daily handling of invoices, sales documents, contractors, records, and settlements in accordance with Polish regulations. We develop our own desktop applications and tools related to invoicing, accounting, KSeF, JPK, and automation of business processes. Our solutions are designed with stability, ease of use, and practical application in users' daily work in mind. Company website: www.rafsoft.net
It is necessary to calculate statistics in a medical project (including correlations). Additionally, there is a request to create a mathematical model for predicting the development of pathologies based on available data.
Hello, I need your help in implementing a task. Fix the bugs on the website page, the page displays a 404 error.
Project Meta Implement Viber integration without using third-party CRM systems. All work with messages should be done directly in our internal CRM based on BAS / 1C 8.3.Current System BAS / 1C 8.3 Custom configuration "Customer Service" Database of over 40,000 subscribersRequired Implementation Integration through an official Viber Business provider (TurboSMS, GMS Worldwide, or another agreed service). The button "Write to Viber" in the subscriber card. Sending messages directly from BAS. Receiving incoming messages via Webhook. Automatic linking of messages to the subscriber by phone number. Complete preservation of correspondence history in the subscriber card. Displaying the time, message status, and the manager who responded. Simultaneous work of multiple managers. Message templates for quick responses. Assistance with setting up the Viber provider, API keys, and Webhook. Transfer of all source code and settings after the work is completed.Acceptance Conditions The work is considered completed after successful testing of all functions on the working database and transfer of the source code.Guarantee 1 month warranty for fixing bugs related to the implemented functionality. Further modifications are carried out by separate agreement.Result After the project is completed, managers should be able to fully work with Viber directly in BAS: write to clients, receive responses, view correspondence history, and communicate without using third-party CRMs. All source code, modifications, API keys, and settings will be transferred to the client after the project is completed.