Experiencing A Significant Spike In CPU
korosten.today
Hi Support Team, I am experiencing a significant spike in CPU usage on my hosting account (see attached screenshot). The site is running on Joomla 6, and the issue seems to trigger when SP Page Builder fetches news articles for the homepage via SQL queries. The resource usage jumped from a steady baseline to nearly 40% starting around 09:00 today. Could you please help me identify the specific heavy SQL queries or processes causing this? I need to know if this is a database indexing issue or if a specific plugin is hanging. Looking forward to your assistance.
Toufiq
Accepted AnswerHi there,
Thank you for reaching out. Did you use cdn to load main.js file? It could be the problem.
Best regards,
Toufiqur Rahman (Team Lead, Support)
korosten.today
Accepted AnswerThank you for the quick response.
However, the issue I am reporting is server-side CPU usage (as seen in the hosting panel statistics), which seems to be triggered by SQL queries when SP Page Builder fetches articles.
The link you mentioned belongs to the Cloudflare security challenge. While it handles traffic, it shouldn't cause the heavy database load I am seeing on the backend.
Could you please check if the Articles addon in SP Page Builder (Joomla 6) has known issues with unoptimized SQL queries or if there is a way to enable caching specifically for those database calls?
korosten.today
Accepted AnswerThe video shows that the site loads fine on the frontend, but that is not the issue I am reporting.
The problem is excessive server-side resource consumption (CPU usage) triggered by SP Page Builder's database queries. Even if the site appears "fast" to a single visitor, the hosting panel shows that the CPU is hitting critical limits (see my previous screenshot at 09:00–10:00).
Please involve a senior developer to check the SQL query execution plan for the "Articles" or "Latest Posts" addon used on the homepage. I am seeing slow queries that are overloading the database.
Simply browsing the site is not a valid test for server load. We need to look at how the component handles multiple requests and database calls.
korosten.today
Accepted AnswerI have identified the "smoking gun" causing the high CPU usage on my server (refer to the 40%+ spikes in the hosting panel).
The SP Page Builder Articles addon on my homepage generates the following unoptimized SQL query: SELECT a.*, b.alias AS category_alias, b.title AS category FROM wnm6h_content a LEFT JOIN wnm6h_categories b ON a.catid = b.id WHERE (b.extension='com_content' AND a.state='1' AND a.catid IN (...багато ID з дублікатами...)) AND (a.publish_up IS NULL OR a.publish_up='0000-00-00 00:00:00' OR a.publish_up<=NOW()) AND (a.publish_down IS NULL OR a.publish_down='0000-00-00 00:00:00' OR a.publish_down>=NOW()) AND a.access IN (1,5) ORDER BY a.publish_up DESC, a.created DESC LIMIT 15261;
Why this query is killing my server:
Critical Limit Issue: The query has a LIMIT 15261. Even though the homepage only displays a few news items, the addon is forcing the database to process and sort over 15,000 records.
Resource Overload: It uses SELECT a.*, which fetches all columns (including full article text) for 15,000+ rows. This is extremely heavy for a simple news list.
Server Impact: Every time a user (or a bot) visits the page, this query triggers, leading to the CPU spikes I previously shared.
Please investigate why the addon is generating such a massive LIMIT and how to fix this behavior in Joomla 6. We need this query to fetch only the required number of articles (e.g., 10 or 20) to keep the server stable.
korosten.today
Accepted AnswerGood afternoon, please tell me when I can expect a response from the developers?
korosten.today
Accepted AnswerGood afternoon, please tell me when I can expect a response from the developers?
korosten.today
Accepted AnswerI'd like to know how my issue is progressing. How long will it take? It's very important for me to resolve this issue as soon as possible.
korosten.today
Accepted AnswerDear Support!
We are forced to contact you again due to the long-standing unresolved technical issue with our website. For a considerable time we have been receiving responses stating that the issue will be addressed “soon”, but no actual changes have yet occurred.
We emphasize: this is not a commercial entertainment resource, but an important regional news site operating in a full-scale war. We publish information about shelling, the security situation, community life and other critically important news for residents of the region every day. The stable operation of the platform directly affects the timely information of people.
Given the social importance of our work, we ask you to make an exception and consider this issue as a priority right now. We also ask you to forward our appeal to the management to speed up the decision-making process.
We hope for a responsible attitude and a prompt response.