Resolve the loading issue on the PrestaShop website hosting
22 USD 
The website requires more and more resources each month. The host's response: During the server check, increased load from the MySQL database server was recorded. At times of the 500 error, the MySQL process uses a significant portion of CPU resources, which can lead to unstable website performance and unavailability of certain pages.
Unfortunately, as part of the hosting technical support, we cannot analyze the database structure, SQL queries, or the website's code. To determine the exact cause, diagnostics from a developer or system administrator are necessary.
We are looking for a specialist to analyze and resolve the issue.
p/s/ Initially, the website was on hosting - then it was moved to VPS, accordingly the PHP changed to another one and certain nuances likely occurred.
Client's review of cooperation with Yury Bichurin
Resolve the loading issue on the PrestaShop website hostingI am more than satisfied with the contractor's work. Completed at 12 out of 10. The report is detailed, and recommendations for further maintenance and speeding up the website have been provided.
Freelancer's review of cooperation with Dmitriy Kosilkin
Resolve the loading issue on the PrestaShop website hostingI am very grateful to Dmytro for his trust. He prepared the specifications, provided all the access for the project, did not distract me, and gave me complete freedom in my work.
-
2 days31 USD
2 days31 USD
👋 Hello! I'm ready to start working right now. I clearly understand the task and have successful experience in implementing exactly such projects (examples are in the reviews). I will complete the task today, quickly and without unnecessary questions. Let's discuss the details and get started! 🚀
-
2 days67 USD
2581 283 2 5 2 days67 USD
Good day!)
I have extensive experience working with Prestashop)
I know it "inside and out," you can see in the reviews)
I know where to look, what to check, and how to find the bottlenecks)
Feel free to reach out, I will do everything excellently, you will be satisfied with the result)
-
3 days67 USD
284 3 days67 USD
Hello! My name is Roman, from the Echocode team. Digital.
Most likely, after the PHP version change, some old functions or SQL queries in the website code started to work incorrectly (causing loops or so-called "heavy" queries that do not use indexes). Also, the MySQL server on the new VPS is probably running with default settings and is not optimized for the size of your database.
We have 8 years of experience in web development and administration of complex systems. We are ready to involve our Senior Backend Developer and system administrator to solve the task.
Message us privately! We will discuss server access, conduct initial diagnostics, and quickly restore stable operation to the website.
-
2 days89 USD
570 4 0 2 days89 USD
Good. Over 20 years of web programming experience. Ready to investigate and resolve the issue with the load.
-
5 days100 USD
368 5 days100 USD
Hello.
Your problem seems similar to common complications currently faced with PrestaShop.
If the load increases for a certain period of time, it is likely due to aggressive bot scanning.
In this case, they generate all possible sorting options on the pages and cause such errors and high load.
It may also be a poorly implemented third-party module that needs optimization.
I have experience in solving all PrestaShop issues, from database settings to writing custom modules. In particular, I have a module for limiting the frequency of bot scanning.
Specific reasons can be discussed after access to the server and logs.
-
2 days67 USD
3481 49 2 2 days67 USD
Hello!
I have reviewed your task - I have relevant experience in similar projects, so I understand how to implement everything efficiently and without unnecessary delays.
I can start working immediately after we agree on the details.
I look forward to collaborating!
-
Winning proposal1 day22 USD
504 20 1 2 Winning proposal1 day22 USD
Good day! I am ready to take on this task and complete it within the specified deadlines. I am an experienced system administrator and SRE/DevOps specialist with over 15 years of experience. I have extensive experience working with various systems and tools, which allows me to effectively solve any tasks.
-
2 days78 USD
532 3 0 2 days78 USD
Hello! I have extensive experience understanding the PrestaShop+Mysql issue, and I have also dealt with a similar problem before. So feel free to reach out, I will analyze it, find the issue(s), and as far as I remember, we will solve the problems with SQL queries.
-
1 day27 USD
1328 35 1 1 day27 USD
Hello. Databases are my specialty. If the issue is with them, I will find and fix it. Feel free to reach out.
-
2 days78 USD
702 1 0 2 days78 USD
Hello! Ready to collaborate. I have experience correcting similar mistakes. Write to me.
-
2 days89 USD
2928 81 0 2 days89 USD
We can do it. Payment upon verification. I guarantee the quality.
-
3 days267 USD
196 3 days267 USD
We already have a practically ready approach for diagnosing PrestaShop under load, which can be quickly adapted to your site and run the check; I am available to discuss.))
Preliminary estimate - 12,000 UAH and up to 3 days for diagnosing MySQL, PHP, modules, cache, logs 500, and basic troubleshooting of the identified cause.
If a heavy module or a problem in the data structure is found, I will provide a separate plan without unnecessary magic - because a cheap patch is often more expensive than proper diagnostics.
After stabilization, we can add AI log monitoring and notifications to catch such spikes before the site crashes.
At the start, we need access to the VPS, PrestaShop admin panel, MySQL, error logs, and preferably a backup or test environment.
Questions - what version of PrestaShop, PHP, and MySQL are currently being used, and is the slow query log enabled?
Another question - does the 500 error occur on specific pages, in the admin panel, during product imports, or randomly under traffic?
- https://business.ingello.com/eva - similar in the direction of e-commerce and technical processes of retail.
- https://business.ingello.com/carveli - a close example of online sales and systematic work around the store.
… - https://systems-fl.ingello.com/ua - our FLH landing page on automation, AI, and business systems.
-
3 days178 USD
976 4 0 3 days178 USD
Good day. My name is Dmytro. I have experience in optimizing WordPress, WooCommerce, Laravel, and other web projects, as well as diagnosing issues with MySQL, VPS, and high server load.
From the description of the situation, it seems that the problem may be related to the database itself (slow SQL queries, lack of indexes, table growth) as well as the consequences of migrating the site to a VPS and changing the PHP, MySQL, or server environment versions.
I can conduct a full audit:
— analysis of MySQL load;
— search for slow queries;
— checking the database structure and indexes;
— auditing plugins and modules that create load;
— checking PHP, MySQL, and web server settings after migration;
— analyzing 500 error logs;
… — optimizing caching and database performance.
After the audit, I will provide a clear report with the causes of the problem and carry out the necessary adjustments for stable site operation without constant increases in server resources.
I am ready to familiarize myself with the project details and conduct an initial diagnosis to assess the scope of work and timelines.
-
2 days111 USD
4188 46 0 2 days111 USD
Good day. I can conduct a diagnosis of the website on PrestaShop and find the real cause of the load on MySQL and the 500 errors. I will check the operation of the database, slow SQL queries, modules, caching, PHP/MySQL settings after the migration to VPS, server logs, and the structure of the website itself to understand what exactly is consuming resources. After the analysis, I will not just provide general recommendations, but I will fix the identified problems: optimize queries, server settings, cache, problematic modules, or sections of code that create load. As a result, the website should operate more stably, without constant 500 errors and without unjustified growth in resource consumption each month.
-
3 days89 USD
12437 600 0 3 days89 USD
Good day, can I help with hosting in Ukraine sometimes?) Feel free to contact me.
Current freelance projects in the category Databases & SQL
Python/CAD Developer for automatic processing of DXF
178 USD
Development of a module for automatic labeling of parts in DXF for laser cutting is needed. Input data: - We use BAS for production accounting. - Laser cutting is performed on Senfeng with CypCut software. - We have ready layout files in DXF format. - Each part must receive a… Python, Databases & SQL ∙ 2 hours 38 minutes back ∙ 12 proposals |
Refinement of 1C UT 11 for Zebra TSD (RDP): different sound signals when scanning
22 USD
Configuration: 1C UT 11 Address warehouse Zebra TC26 TSD Work via RDP Product scanning is performed in receiving, placement, picking documents, and other warehouse operations. Current problem: Warehouse workers operate through the Zebra TSD. When scanning, they do not always… C#, Databases & SQL ∙ 14 hours 16 minutes back ∙ 5 proposals |
Heal the 1C configuration
111 USD
Configuration of CRM & ERP SmartCeiling (2.8.26.0) Protection via Registration Code. Registered until the end of the year. Databases & SQL ∙ 1 day 5 hours back ∙ 7 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 ∙ 6 days 4 hours back ∙ 12 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 ∙ 6 days 15 hours back ∙ 6 proposals |
Lisichansk