Exceeding CPU limits
OpenCart Optimization: Reducing CPU and Resolving 524
Project
Online store on OpenCart
https://jeansok.com.ua/
Due to a stable exceedance of CPU limits (100 min/day), it was necessary to switch to business hosting.
The task is to optimize the site so that it operates within the limits of regular hosting.
Problem
CPU usage is consistently above normal
Occasionally encounters Cloudflare Error 524
Cloudflare is connected, but did not resolve the issue
Load increased after:
adding the English version
launching the blog
growth of traffic from abroad
❗ Blocking search and AI bots is not allowed
Technical Data
CMS: OpenCart
Hosting: ukraine.com.ua
Cloudflare: connected
Server logs (January):
https://u.ua/d/7J2Jk4i/charts https://docs.google.com/document/d/1IfCfHq6ScfpZfBQ5-uIE_xfP8r7Yjl5-mXl2klN5MIg/edit?tab=t.0
What Needs to Be Done
Analyze server logs
Identify the causes of high CPU
Optimize:
OpenCart (modules, SQL)
blog and multilingualism
caching
Eliminate the causes of Error 524
Properly configure Cloudflare
Expected Result
CPU ≤ 100 min/day
Absence of 524
Stable operation of the site
Ability to return to regular hosting
No loss of SEO and language versions
Requirements
Experience with OpenCart
Understanding CPU limits of shared hosting
Experience working with Cloudflare
Ability to analyze logs
Budget
Exorbitant budgets will not be considered
A reasonable cost for specific results is required
Preference will be given to performers who can justify the price and scope of work
In your response, please include:
Experience with OpenCart
How you search for the causes of high CPU
A brief action plan
If you want, I can:
further condense the text (to fit on one screen of Freelancehunt)
or create a version with a fixed budget corridor, so there is no need to negotiate.
Applications 1
Client's review of cooperation with Yevgeny T.
Exceeding CPU limitsEverything is well done. I fixed what was working incorrectly. I suggested what to add. I recommend.
Freelancer's review of cooperation with Vlad Vlad
Exceeding CPU limitsThank you. Everything went well.
-
Good day, I have been developing and maintaining websites on OpenCart for more than 8 years. I have encountered, fixed, nothing new, I will perform quickly and qualitatively. Write to me, we will discuss.
-
1973 17 0 1 Hello! I have extensive experience in optimizing OpenCart. I understand the nature of error 524 (Timeout) — the server fails to respond in time, most often due to database hangs.
Judging by the description (multilingualism + blog), the problem is likely in heavy SQL queries (JOINs of translation tables) and the absence of indexes.
My approach to finding the causes:
I analyze the MySQL slow query log — this will show specific queries that "consume" CPU.
I analyze the Access log — to see which specific pages (filters, categories, blog) create load during bot visits.
Action plan:
… Database: Adding missing indexes and optimizing queries (this will sharply reduce CPU usage).
Modules: Profiling installed blog and language modules, disabling unnecessary hooks.
Caching: Setting up server-side caching (or optimizing existing one) to serve static content to bots without querying the database.
Cloudflare: Setting up Page Rules for caching static content on the CDN side, so requests do not reach the hosting.
-
442 Hello! I have thoroughly analyzed your logs and load graphs for jeansok.com.ua. The issue of exceeding CPU limits and encountering error 524 is quite solvable without losing functionality.
What I saw during the initial audit of your logs:
Aggressive scanning by AI bots. The logs record mass visits from Claude-SearchBot and Applebot. They access heavy pages with parameters (filters, tags, pagination), which causes a cascading load on the database.
Problematic requests Journal 3: I see a large number of POST requests to route=journal3/price. This is a common issue with this template; the dynamic recalculation of prices with each product view loads PHP processes and often becomes the cause of Cloudflare error 524.
Heavy multilingualism: The increase in load after adding the English version confirms that the indexes for the description and URL alias tables are not optimized in the database.
-
277 1 1 Hello, I can complete this project quickly and efficiently, as I have experience in similar projects! We can discuss the details and do this in 2 days.
-
726 9 1 Hello! I have reviewed the project and am ready to start working. I am sure you will be satisfied with the result.
-
573 9 0 Let's move to another hosting. It will be possible to solve the problem for the price of a regular tariff. Write in private messages, I will tell you more details.
-
2649 19 0 The specific result will be on its own server. 5-6 euros per month. Stable and quality. Ukraine has long been out of the ranks of good hosts. I can implement everything from A to Z.
-
1328 35 1 Hello. The only reason for the load is the large number of requests to the site. The only way to combat this is database optimization + caching. Please reach out.
-
96232 1273 1 10 Hello. I have extensive experience in speeding up websites. I am ready to collaborate.
-
6512 229 4 7 Hello
I optimize Opencart
Write in private messages
We will discuss the details
-
4183 46 0 I have practical experience in optimizing OpenCart under strict CPU limits of shared hosting and working with Cloudflare. In similar projects, I have brought stores from constant 524 errors and CPU overloads to stable operation within limits without losing SEO. In your case, I will analyze server logs and load graphs, identify specific points of CPU spikes (modules, SQL queries, blog, multilingualism, bots, slow backend responses), optimize OpenCart and the database, configure proper caching and Cloudflare for real traffic, eliminate the causes of Error 524, and bring the site to stable operation with CPU usage up to 100 minutes per day, so you can safely return to regular hosting at a reasonable, justified cost and with clear results.
Current freelance projects in the category Databases & SQL
Basketball Coaching Education Platform + Custom CMSBasketball Coaching Education Platform + Custom CMSProject Overview We are looking for an experienced web development team or full-stack developer to build a modern basketball coaching education platform. The website will provide basketball coaches with access to educational… Databases & SQL, Web Programming ∙ 8 hours 56 minutes back ∙ 38 proposals |
Integration of Viber in 8.3
223 USD
Need Viber integration into own CRM (1C 8.3)About the Company The company "Domofon System" is engaged in the installation and maintenance of intercom systems. Base of over 40,000 subscribers. We work on our own customized system based on 1C 8.3. We are looking for a specialist… Databases & SQL, Bot Development ∙ 12 hours 17 minutes back ∙ 7 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 ∙ 2 days 10 hours back ∙ 6 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 ∙ 3 days 1 hour back ∙ 8 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 ∙ 8 days back ∙ 12 proposals |