Not sure how to go about fixing this issue our host is complaining about with our sites generating high usage which is "abusive" by their guidelines. The host is Surpass Hosting. We are on a shared server. There are two sites which appear to be contributing www.navigatorschoice.com (zen cart 1.5.4) and www.scubastevesmarine.com (zen cart 1.5.1). I use templates on the sites from picaflor-azul. I really don't know what details are needed or where to start to resolve this issue. Any guidance and assistance would be appreciated. Thanks.
Below is the stats provided by the hosting company.
Once again this account is consuming too many resources on the server as shown below:
############
2016-03-11
Account: scubast Domain: scubasteve.biz CPU: 54.33 Mem: 0.39 MySQL: 1.5
%CPU 52.0 - [php53]
%CPU 51.0 - [php53]
%CPU 50.0 - [php53]
2016-03-10
Account: scubast Domain: scubasteve.biz CPU: 94.05 Mem: 0.60 MySQL: 2.5
%CPU 53.0 - /usr/bin/php53 /home/scubast/public_html/westchaseproducts/scubastevesmarine/index.php
%CPU 52.0 - /usr/bin/php53 /home/scubast/public_html/westchaseproducts/scubastevesmarine/index.php
%CPU 49.0 - [php53]
2016-03-09
Account: scubast Domain: scubasteve.biz CPU: 102.20 Mem: 0.72 MySQL: 3.1
%CPU 58.0 - /usr/bin/php53 /home/scubast/public_html/westchaseproducts/scubastevesmarine/index.php
%CPU 54.0 - [php53]
%CPU 36.0 - /usr/bin/php53 /home/scubast/public_html/westchaseproducts/scubastevesmarine/index.php
2016-03-08
Account: scubast Domain: scubasteve.biz CPU: 91.78 Mem: 0.61 MySQL: 2.5
%CPU 58.0 - /usr/bin/php53 /home/scubast/public_html/westchaseproducts/scubastevesmarine/index.php
%CPU 56.0 - /usr/bin/php53 /home/scubast/public_html/westchaseproducts/scubastevesmarine/index.php
%CPU 53.0 - [php53]
2016-03-07
Account: scubast Domain: scubasteve.biz CPU: 42.91 Mem: 0.29 MySQL: 1.2
%CPU 51.0 - [php53]
%CPU 50.0 - /usr/bin/php53 /home/scubast/public_html/westchaseproducts/scubastevesmarine/index.php
%CPU 49.0 - [php53]
2016-03-06
Account: scubast Domain: scubasteve.biz CPU: 105.24 Mem: 0.63 MySQL: 2.8
%CPU 68.0 - /usr/bin/php53 /home/scubast/public_html/westchaseproducts/scubastevesmarine/index.php
%CPU 59.0 - /usr/bin/php53 /home/scubast/public_html/westchaseproducts/scubastevesmarine/index.php
%CPU 55.0 - /usr/bin/php53 /home/scubast/public_html/westchaseproducts/scubastevesmarine/index.php
2016-03-05
Account: scubast Domain: scubasteve.biz CPU: 111.94 Mem: 0.78 MySQL: 3.4
%CPU 55.0 - /usr/bin/php53 /home/scubast/public_html/westchaseproducts/scubastevesmarine/index.php
%CPU 54.0 - /usr/bin/php53 /home/scubast/public_html/westchaseproducts/scubastevesmarine/index.php
%CPU 53.0 - [php53]
############
Please ensure this high usage is addressed as soon as possible:
###################
USER: sc_zc
TOTAL_CONNECTIONS: 150
CONCURRENT_CONNECTIONS: 0
CONNECTED_TIME: 84
BUSY_TIME: 37
CPU_TIME: 18
###################
Below are the tables being accessed and altered the most by the account:
+-----------------+------------------------------------+-----------+--------------+------------------------+
| TABLE_SCHEMA | TABLE_NAME | ROWS_READ | ROWS_CHANGED | ROWS_CHANGED_X_INDEXES |
+-----------------+------------------------------------+-----------+--------------+------------------------+
| scubast_nach9 | zen_banners_history | 6556 | 4 | 8 |
| scubast_znct3 | zen_specials | 14049 | 0 | 0 |
| scubast_znct3 | zen_manufacturers | 17323 | 0 | 0 |
| scubast_znct3 | zen_products_to_categories | 28951 | 0 | 0 |
| scubast_znct3 | zen_banners | 31995 | 0 | 0 |
| scubast_znct3 | zen_products_description | 73432 | 8 | 16 |
| scubast_znct3 | zen_products | 107537 | 0 | 0 |
| scubast_znct3 | zen_sessions | 159925 | 329 | 329 |
| scubast_znct3 | zen_banners_history | 4129607 | 1302 | 2604 |
+-----------------+------------------------------------+-----------+--------------+------------------------+
###################


Reply With Quote
