Oh no! Where's the JavaScript?
Your Web browser does not have JavaScript enabled or does not support JavaScript. Please enable JavaScript on your Web browser to properly view this Web site, or upgrade to a Web browser that does support JavaScript.
Sign In
Not a member yet? Click here to register.

Account overloaded on host

I got this from my host and do not know what to do...:

Quote

We are notifying you that your account, or a portion or feature of your account has caused an overload on one of our servers. We have a shared hosting environment that we must maintain at a certain level of performance. This performance is monitored and balanced by us, however there are times when accounts can cause the server's load to increase degrading the performance for all other customers on this server.

Unfortunately, until this issue is resolved your account will have to remain limited.

To protect your account from further action you must agree to our request for compliance. Please respond to this message stating your intent to do so. You may either log into your control panel with us, and access this ticket via the 24/7 help desk, or provide this ticket number to our Live Chat or phone representatives.

Amount of query: 1117
Slow query time: 6176.195
Lock time: 0.202
Rows sent: 12827850
Rows examined: 12827850
Query example:
SELECT * FROM fusion_guestbook_entry WHERE gb_show=1;

Access to database rikkeri_survivalteam has been chmoded to 0.
Database optimization;
You are using shared hosting,these types of plans are for smaller sites:
Clean the DB up some,drop / delete unwanted entries,or upgrade your account at your hosting provider.
LOL it needs more than database optimization Gillette.

"SELECT * FROM fusion_guestbook_entry WHERE gb_show=1;"

If you have thousands of guestbook entries and it's querying all those without pagination then you are in trouble and the creator should get throat punched. Even if that's just their way to query the total amount of entries you do not use *... Clearly this infusion is NOT efficient.
Thread Information
Author
Replies
3 posts
Views
2,006 times
Last Post
Last updated on 7 years ago
You can view all discussion threads in this forum.
You cannot set up a bounty in this discussion thread.
You can start a new discussion thread in this forum.
You cannot reply in this discussion thread.
You cannot start on a poll in this forum.
You cannot upload attachments in this forum.
You can download attachments in this forum.
You cannot up or down-vote on the post in this discussion thread.
Users who participated in discussion: Martijn78, Tyler, Gillette