XF 1.5 Constant SQL Usage High - Host is shutting off access

[quiksilver895]

I am really new to this and am in dire need of some help. We keep getting an email from our host telling us that we are exceeding usage and they are restricting access to MySQL. We have less than 300 members and shouldnt be using that many resources. I have copied the text from the email below in hopes that someone can point me in the right direction. Thanks!


Hello,

Unfortunately, we have been forced to temporarily restrict access to MySQL for jtaglia on gator3015.hostgator.com. Please take a moment to review this email in full as it contains important information and resources to assist you in resolving this issue. Please note that while this restriction is temporary, you should take actions to resolve the issue(s) which may have caused it in order to avoid further down-time/permanent restrictions.

- How can you resolve the issue?
We have two solutions available. Moving the account to a dedicated server, which will allow far greater hardware resources or you may try following the basic recommendations for optimizing your database. If you feel your database has already been optimized, it may simply be time to consider the hardware upgrade. http://support.hostgator.com/articles/specialized-help/technical/optimize-mysql-resource-usage

- Why did this happen?
Per our terms of service (http://www.hostgator.com/tos) a single hosting account may use no more than 25% of the entire server's resources. Accounts are typically not actively restricted until they exceed those resource limitations exceptionally. Unfortunately, in this instance, we were forced to place a temporary restriction on your user to prevent service issues with the server's over-all system performance. For more information about resource usage limitations, please see:https://support.hostgator.com/artic...rules-terms-of-service/account-limits-summary

Please reply to this email once you have determined a resolution to this issue.

CPU_TIME:79 table_rows_read:20898230 SELECTS:0 ROWS_UPDATED:201548 ROWS_FETCHED:214145 BUSY_TIME:557 ONNECTED_TIME:826 BYTES_SENT:2667121676 BYTES_RECEIVED:926284014 WAIT_TIME:478


Top table row reads:
DB_USER: -- TOTAL_CONNECTIONS: 495 -- CONNECTED_TIME: 826 -- CPU_TIME: 79 -- TABLE_ROW_READS: 20898230 -- SELECT_COMMANDS: 0 -- UPDATE_COMMANDS: -- BUSY_TIME: 557 -- BYTES_SENT: 2667121676 -- BYTES_RECEIVED: 926284014 -- WAIT_TIME (IO): 478



Top WAIT (IO) TIME:
DB_USER: -- TOTAL_CONNECTIONS: 495 -- CONNECTED_TIME: 826 -- CPU_TIME: 79 -- TABLE_ROW_READS: 20898230 -- SELECT_COMMANDS: 0 -- UPDATE_COMMANDS: -- BUSY_TIME: 557 -- BYTES_SENT: 2667121676 -- BYTES_RECEIVED: 926284014 -- WAIT_TIME (IO): 478



jtaglia 244161 11.3 0.0 193736 32736 ? SN 15:55 0:00 /opt/php71/bin/php-cgi /home4/jtaglia/public_html/admin.php

Fri Dec 6 15:55:53 CST 2019
Running Processes:
jtaglia 244161 8.5 0.0 193892 33000 ? SN 15:55 0:00 /opt/php71/bin/php-cgi /home4/jtaglia/public_html/admin.php
jtaglia 244293 28.0 0.0 186416 25656 ? SN 15:55 0:00 /opt/php71/bin/php-cgi /home4/jtaglia/public_html/index.php

Running Queries:
1. row
USER: jtaglia_reqrp
DB: jtaglia_requiemlibraryrp
STATE: Creating sort index
TIME: 3
COMMAND: Execute
INFO: SELECT *
FROM xf_style
ORDER BY title

Open connections

Current Site Requests:


Reference: ui
Server: gator3015.hostgator.com
Brand: hostgator
Srv. Type: cpanel
Created: Sat Jul 27 12:26:23 2019
Acct Type: Shared
Plan: Business
Theme: hostgator
User: jtaglia
U. Domain:
Email:
IP:

Doc Root: /home4/jtaglia/public_html
Shell: /usr/local/cpanel/bin/jailshell

CPU Usage: 41.8% (warning)
SSL: SSL error: missing certificate (warning)



Bytes received hit 926284014 > 473741824

Current load: 15:55:55 up 17:24, 2 users, load average: 0.18, 0.04, 0.01

 

[Slavik]

If im honest, find a new host, or speak to someone here about setting you up a cheap VPS.

 

[Fullmoon]

Second that. Hostgator

 

[DigNap15]

I had a simalar problem
My webhost just cut me off saying I was using too many resources.
I have 1000 members of who only 400 are active, but they are very active.
New posts come in thick and fast sometimes.
(that is why I dont listen to members on here who say "Change to another host", :this one is cheap" (they might have a slow forum themselves)
My host explained that it is every page load that is the problem for them.
So I upgarded to their cloud service. (much faster now)
But I will be looking in detail into my SQL database to see what is causing the slow page loads and the overuse.

 

[Mr Lucky]

(that is why I dont listen to members on here who say "Change to another host", :this one is cheap" (they might have a slow forum themselves)

Or they might have a very fast one.

 

[Ozzy47]

Or they might have a very fast one.

Or a good host.

 

[Mr Lucky]

Or both. As in my case.

 

[Ozzy47]

It could even be down to the server being configured correctly or not oversold.