Fine-tuning of the web server
33 USD 
Problem description:
We have a server on AlmaLinux with ISPManager installed, a MariaDB database, and online stores on the OpenCart platform, running on PHP 7.3. There are about 7 users on the server, each with several OpenCart sites. Currently, there is often a problem with the max_user_connections error due to a large number of simultaneous requests to the database, leading to server overload and crashes.
Task:
Problem analysis:
Evaluate the MariaDB configuration on the server.
Check the current settings for max_user_connections and other parameters that may lead to database overload.
Solutions to limit max_user_connections:
Develop a strategy to limit the number of simultaneous connections for each user separately to prevent server overload.
Configure MariaDB so that each user has individual connection limits, which will help avoid situations where one user can overload the entire server.
Optimization of MariaDB configuration:
Check and optimize the database configuration to improve its stability and efficiency under high loads.
Recommend changes to MariaDB settings if necessary for the stable operation of multiple online stores on OpenCart.
Monitoring and overload alerts:
Set up monitoring tools to track the status of the server and database to timely detect overloads or approaches to critical limits.
Configure alerts for high load thresholds to take timely action.
Improvement recommendations:
Provide recommendations for further steps to maintain high server availability and optimize the operation of online stores, including caching settings, improving database performance, etc.
Expected results:
Individual limits for max_user_connections for each user.
Optimized MariaDB settings to improve stability under high loads.
Configured monitoring of the server and database to prevent overloads.
Detailed recommendations for further optimization of the server infrastructure.
Additional requirements:
Experience with AlmaLinux, MariaDB, ISPManager, OpenCart.
Knowledge of optimization methods for server and basic settings for PHP and MariaDB.
Availability of a portfolio or experience in performing similar tasks.
If you have any questions or need further clarifications, please feel free to reach out!
-
2 days33 USD
562 3 2 2 days33 USD
Hello, I am ready to help with the execution of your project.
Price - according to your budget, deadline - as per your request and need.
I will be waiting for your feedback.
-
1 day33 USD
598 12 2 1 day33 USD
I will complete your task immediately. Quickly and with quality. Over 6 years of experience in programming and administration.
-
1 - прибрати ISP Manager, у сервера зʼявиться більше ресурсів. Від нього більше збитку чим користі.
2 - оновити PHP!!!
3 - добавити моніторинг, щоб робити якусь оптимізацію
-
Current freelance projects in the category Databases & SQL
Power BI
16 USD
The dashboard runs on a Google server, we need to transfer all logic + code Required skills: deployment of ETL processes on a Linux server + working with BigQuery and Postgre There is working code that runs on Google, where the database itself is, we need to transfer it to… Python, Databases & SQL ∙ 2 days 6 hours back ∙ 15 proposals |
Need a 1C specialist for refinements and development.I am looking for a 1C specialist for freelance collaboration. I am currently working with a contractor who provides support and maintenance for the 1C system. However, due to the contractor's workload, there is a need for prompt execution of additional tasks, improvements, and… Databases & SQL ∙ 4 days 6 hours back ∙ 11 proposals |
Restoring Instagram after a banOn March 3, 2026, my Instagram was blocked due to a violation of rules. I believe there has been some mistake, as the page was personal with photos and videos of my personal trips. I did not post any comments anywhere. I have sent several appeals. I cannot download my files… Databases & SQL, Web Programming ∙ 4 days 17 hours back ∙ 5 proposals |
Eliminate the issue of incomplete data import from Excel files of Nova Poshta specifications into 1C:
45 USD
Goal: There is a processing in 1C for uploading the specifications of Nova Poshta. For unclear reasons, it has stopped loading some tabular data. We need to find the reason and eliminate the problem of incomplete data import from Excel files of Nova Poshta specifications into… System & Network Administration, Databases & SQL ∙ 8 days back ∙ 16 proposals |
Accounting, planning, and sales system for a mushroom farm
603 USD
Here is the complete, final text of the Technical Assignment (TA). It combines all your requirements: 16 chambers, 20 contractors, a schedule by days, accounting for containers, profitability calculation, and a mandatory division into three grades of mushrooms. You can fully… Databases & SQL, Client Management & CRM ∙ 10 days 4 hours back ∙ 61 proposals |
Kyiv