Issue of hosting load

Started by soxcell, Nov 19, 2022, 02:39 AM

Previous topic - Next topic

soxcellTopic starter

Hello for everyone. Maybe I'm not writing there, but I'll try anyway. I am a content manager. I am engaged in filling sites. I am filling out 1 site (the site is in the filling stage). I fill it out 1, no one else fills it out.
The hosting providers write to the customer that there is a big load on hosting. I attach a letter from the hosting provider.

"Hello!
You are a SpaceWeb customer.
Your login: ***
Contract number: ***
Over the past day, the load created by the MySQL databases of your account amounted to 2764 processor seconds. This exceeds the permissible load of 1000 processor seconds on virtual hosting tariffs and is a violation of clause 2.11 of the Rules for the Provision of Services specified in Appendix 1 to the Public Offer Agreement.

In accordance with clause 2.3. of the Agreement, the work of the account may be suspended: "2.3. The Contractor has the right to suspend the provision of services in cases of violation by the Customer of clauses 2.10-2.12. of Appendix 1 to this Agreement until the reason for the suspension of the provision of services is eliminated."
In order to avoid the shutdown of your account, please reduce the load created as soon as possible.
To reduce the load, we recommend:
to carry out technical work on optimizing SQL queries in site scripts.
use indexes in databases

The customer writes to me that I am putting a load on hosting, adding a lot of goods per day (on average 150-200 pcs. per day).
This is a description of the creature and a picture of 100-200 kb. And I, alas, do not understand the load on hosting.

Please give me some advice!!!
Is the customer right that I put a load on hosting with my filling, or is it not about me. Then tell me how it can be fixed.
Thanks.
  •  

kevin66

the site was made by newbie, whose hands are worth tearing off for such performance.

Host swear at the CPU load of the DBMS, this is just because of the large number of calls to the database during filling. And what will happen with a bunch of complex read requests, I'm even afraid to imagine.
How to solve: to convey to the customer the idea that saving $1 per month, he loses on the performance of the site on such hosting by overdoing conversions.
The download speed of the same product catalog directly depends on the response time of the database, so it is in his interest to change web hosting to something adequate.
  •