Hosting Issues over utilized

General questions relating to Joomla! 5.x.

Moderator: General Support Moderators

Forum rules
Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting.
Forum Post Assistant - If you are serious about wanting help, you should use this tool to help you post.
Windows Defender SmartScreen Issues <-- please read this if using Windows 10
Post Reply
wejom21
Joomla! Apprentice
Joomla! Apprentice
Posts: 9
Joined: Mon Aug 23, 2021 4:19 am

Hosting Issues over utilized

Post by wejom21 » Thu Mar 28, 2024 8:00 am

Hi Joomla Experts,

I would like to ask if any of you have encountered this:

I got an email from my hosting company (Namecheap) I am on shared hosting that overutilized the resources and they gave me these logs; I do not get why these logs have issues.

So; what do these logs mean? on my Cpanel statistics, I fall within the range but the hosting shared with me that they can only able to see and check the issues for themselves.

Any idea or advice on these logs?

If there is an issue; how to solve this?

Looking forward for experts advice.

[ MySQL Queries ]====================================

| 5309260 | user_sde73 | localhost | user_sde73 | Query | 353 | Creating sort index | SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, | 0.000 |
| 5309660 | user_sde73 | localhost | user_sde73 | Query | 301 | Creating sort index | SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, | 0.000 |
| 5309753 | user_sde73 | localhost | user_sde73 | Query | 291 | Creating sort index | SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, | 0.000 |
| 5309782 | user_sde73 | localhost | user_sde73 | Query | 284 | Creating sort index | SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, | 0.000 |
| 5309938 | user_sde73 | localhost | user_sde73 | Query | 266 | Sending data | SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, | 0.000 |
| 5310147 | user_sde73 | localhost | user_sde73 | Query | 238 | Sending data | SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, | 0.000 |
| 5310422 | user_sde73 | localhost | user_sde73 | Query | 203 | Sending data | SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, | 0.000 |
| 5310504 | user_sde73 | localhost | user_sde73 | Query | 193 | Sending data | SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, | 0.000 |
| 5310657 | user_sde73 | localhost | user_sde73 | Query | 168 | Sending data | SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, | 0.000 |
| 5310668 | user_sde73 | localhost | user_sde73 | Query | 166 | Sending data | SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, | 0.000 |
| 5310798 | user_sde73 | localhost | user_sde73 | Query | 140 | Sending data | SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, | 0.000 |
| 5310844 | user_sde73 | localhost | user_sde73 | Query | 137 | Sending data | SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, | 0.000 |
| 5310920 | user_sde73 | localhost | user_sde73 | Query | 128 | Sending data | SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, | 0.000 |
| 5311278 | user_sde73 | localhost | user_sde73 | Query | 72 | Sending data | SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, | 0.000 |
| 5311414 | user_sde73 | localhost | user_sde73 | Query | 59 | Sending data | SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, | 0.000 |
| 5311607 | user_sde73 | localhost | user_sde73 | Query | 30 | Sending data | SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, | 0.000 |
| 5311807 | user_sde73 | localhost | user_sde73 | Sleep | 0 |

User avatar
pe7er
Joomla! Master
Joomla! Master
Posts: 24986
Joined: Thu Aug 18, 2005 8:55 pm
Location: Nijmegen, Netherlands
Contact:

Re: Hosting Issues over utilized

Post by pe7er » Thu Mar 28, 2024 9:58 am

I searched for "Namecheap reviews" and saw very mixed reviews about that hosting.

Your website seems to generate a large number of MySQL queries that seem to take a large amount of time to execute.
The queries you posted are from Joomla's core com_content (articles) component.

What else do you use on your website?
Could you use the Forum Post Assistant to give more details?
https://forumpostassistant.github.io/docs/
Kind Regards,
Peter Martin, Global Moderator
Company website: https://db8.nl/en/ - Joomla specialist, Nijmegen, Netherlands
The best website: https://the-best-website.com


Post Reply

Return to “General Questions/New to Joomla! 5.x”