Messages

Ok I found some of it.

Social_media_set was broken and failing to construct something, and I just uninstalled it completely.  But then I have these appearing in the logs.  Anyone know what these are?   They keep repeating, these huge number of queries that take a long time to complete with no label.  Anyone know of a way to find these?   These three issues are appearing in the logs. 


First issue is this repeating all the time
9101::App Warning
Dataset inconsistency data issue detected. Dataset ID: 2. Column_name: item_icon_rl_id Column data type: varchar in /home1/darksyde/public_html/core/lib/dataset.php on line 555



Second issue, lots of query records like this:

2015-08-06 13:12:20 - Queries - 1171
Queries execution time - 13.50666
PHP Execution time - 14.8977

2015-08-06 13:12:34 - Queries - 1011
Queries execution time - 23.59370
PHP Execution time - 27.2407

2015-08-06 13:12:43 -

2015-08-06 13:12:47 - Queries - 1169
Queries execution time - 24.75642
PHP Execution time - 26.4147

2015-08-06 13:12:56 -

2015-08-06 13:12:59 - Queries - 1077
Queries execution time - 10.98523
PHP Execution time - 12.6464

2015-08-06 13:13:04 - Queries - 1010
Queries execution time - 11.14578
PHP Execution time - 15.2364

Third issue this repeating all the time:

2015-08-06 13:16:51 - database error: AbanteCart core v.1.2.3 Error:
SELECT DISTINCT
e.extension_id,
e.type,
e.key,
e.category,
e.priority,
e.version,
e.license_key,
e.date_installed,
e.date_modified,
e.date_added,
s.store_id,
st.alias as store_name,
s.value as status
FROM extensions e
LEFT JOIN settings s ON ( TRIM(s.`group`) = TRIM(e.`key`) AND TRIM(s.`key`) = CONCAT(TRIM(e.`key`),'_status') )
LEFT JOIN stores st ON st.store_id = s.store_id
WHERE e.`type` IN ('extensions', 'payment', 'shipping', 'template', 'language')AND COALESCE(s.`store_id`,0) = '0' in <b>/home1/darksyde/public_html/core/database/amysqli.php</b> on line <b>105</b>

I tried setting logging to level 2 and then went to the error logs page and this was below the dashboard repeated tons of times.


9101::App Warning
Dataset inconsistency data issue detected. Dataset ID: 2. Column_name: item_icon_rl_id Column data type: varchar in /home1/darksyde/public_html/core/lib/dataset.php on line 555

How would I be sure if something got deleted or not? The file and path that the error is referring to is there.

I personally do not get into my database nor my ftp usually.  I only have since these issues started. 

These two errors keep repeating in the error logs. 

2015-08-05 11:55:29 - database error: AbanteCart core v.1.2.3 Error:
SELECT DISTINCT
e.extension_id,
e.type,
e.key,
e.category,
e.priority,
e.version,
e.license_key,
e.date_installed,
e.date_modified,
e.date_added,
s.store_id,
st.alias as store_name,
s.value as status
FROM extensions e
LEFT JOIN settings s ON ( TRIM(s.`group`) = TRIM(e.`key`) AND TRIM(s.`key`) = CONCAT(TRIM(e.`key`),'_status') )
LEFT JOIN stores st ON st.store_id = s.store_id
WHERE e.`type` IN ('extensions', 'payment', 'shipping', 'template', 'language')AND COALESCE(s.`store_id`,0) = '0' in <b>/home1/darksyde/public_html/core/database/amysqli.php</b> on line <b>105</b>




*******************************************************************************


2015-07-23 10:30:57 - warning: AbanteCart core v.1.2.3 filemtime(): stat failed for /home1/darksyde/public_html/system/cache/resources/resources.image.categories.196.1_0.1437751856 in <b>/home1/darksyde/public_html/core/lib/cache.php</b> on line <b>78</b>

Turning off the google third party extensions did not help. 

The time it takes to save an edit to a product the first time I make an edit about 31 seconds.

The next time I attempt to edit the same product it takes less than 1 second. 

The setting in admin general does not apply to products if you have multiple parent categories.

I have selected and saved sort products as default by Name A-Z.

Go to http://openblindboxes.com

On a category on my site like Tokidoki > Cactus Friends you can navigate to it and see it loads sorting by A-Z.

However go to Kidrobot > Dunny > Dunny Series 2 and you can see it sorts by default.  Which is not A-Z. 

All my testing seems to show this occurs when the product has 2 levels of parent categories or more.  I have viewed many products on my site and this seems to be the pattern. 

This is only a defect submission and does is not a high priority fix. 

I think I found somewhere to gain some speed in my site.  Every page loads every thumbnail for each category and I have a lot....So can I not have the image load in the categories?

I still would want them on the parent page....I will give examples below.


The first image I would like to no longer serve these images in the header...or to make it an option to turn off.  Even if there is no image loaded for that category it still uses the blank camera image.  I think I am going to need them all to be removed. 


I would still like the thumbs to load in the parent pages however.  The second image. 

I would like to work with you all on getting the site sped up, you can see my speeds at openblindboxes.com 

You can message me here, if you need me to try anything. 

I do not have the slow query log, I need them to turn it on but they are taking a long time to reply.  I do not know if my server is hacked.  This is what Hostgator sent me in the original email.

Running Processes:
=============== Pass 1 ===============
darksyde 3317 0.2 0.0 315612 28572 ? SN 21:47 0:01 /opt/php54/bin/php-cgi /home1/darksyde/public_html/index.php
darksyde 3526 0.2 0.0 315356 28540 ? SN 21:47 0:01 /opt/php54/bin/php-cgi /home1/darksyde/public_html/index.php
darksyde 5169 0.2 0.0 315356 28436 ? SN 21:48 0:01 /opt/php54/bin/php-cgi /home1/darksyde/public_html/index.php
darksyde 5519 0.2 0.0 315356 28492 ? SN 21:48 0:01 /opt/php54/bin/php-cgi /home1/darksyde/public_html/index.php
darksyde 5840 0.0 0.0 311244 23656 ? SN 21:48 0:00 /opt/php54/bin/php-cgi /home1/darksyde/public_html/index.php
darksyde 6088 0.2 0.0 315356 28336 ? SN 21:48 0:01 /opt/php54/bin/php-cgi /home1/darksyde/public_html/index.php
darksyde 6113 0.0 0.0 311244 23652 ? SN 21:48 0:00 /opt/php54/bin/php-cgi /home1/darksyde/public_html/index.php
darksyde 6339 0.2 0.0 315356 28404 ? SN 21:48 0:01 /opt/php54/bin/php-cgi /home1/darksyde/public_html/index.php
darksyde 6807 0.2 0.0 315356 28408 ? SN 21:48 0:01 /opt/php54/bin/php-cgi /home1/darksyde/public_html/index.php
darksyde 6871 0.2 0.0 315356 28340 ? SN 21:48 0:01 /opt/php54/bin/php-cgi /home1/darksyde/public_html/index.php
darksyde 7055 0.2 0.0 315356 28356 ? SN 21:49 0:01 /opt/php54/bin/php-cgi /home1/darksyde/public_html/index.php
darksyde 8978 0.2 0.0 315100 28184 ? SN 21:49 0:01 /opt/php54/bin/php-cgi /home1/darksyde/public_html/index.php
darksyde 9482 0.0 0.0 311244 23660 ? SN 21:49 0:00 /opt/php54/bin/php-cgi /home1/darksyde/public_html/index.php
darksyde 10015 0.0 0.0 311244 23660 ? SN 21:50 0:00 /opt/php54/bin/php-cgi /home1/darksyde/public_html/index.php
darksyde 10480 0.0 0.0 311244 23656 ? SN 21:50 0:00 /opt/php54/bin/php-cgi /home1/darksyde/public_html/index.php
darksyde 10515 0.0 0.0 311244 23652 ? SN 21:50 0:00 /opt/php54/bin/php-cgi /home1/darksyde/public_html/index.php
darksyde 10788 0.2 0.0 315100 28132 ? SN 21:50 0:01 /opt/php54/bin/php-cgi /home1/darksyde/public_html/index.php
darksyde 11410 0.0 0.0 311244 23664 ? SN 21:50 0:00 /opt/php54/bin/php-cgi /home1/darksyde/public_html/index.php
darksyde 12337 0.0 0.0 311244 23668 ? SN 21:50 0:00 /opt/php54/bin/php-cgi /home1/darksyde/public_html/index.php
darksyde 14968 0.2 0.0 249052 27284 ? SN 21:51 0:01 /opt/php54/bin/php-cgi /home1/darksyde/public_html/index.php
darksyde 24676 0.4 0.0 249052 27404 ? SN 21:55 0:00 /opt/php54/bin/php-cgi /home1/darksyde/public_html/index.php
darksyde 29792 1.0 0.0 313820 26548 ? SN 21:57 0:00 /opt/php54/bin/php-cgi /home1/darksyde/public_html/index.php
darksyde 32319 7.0 0.0 313564 26408 ? SN 21:57 0:00 /opt/php54/bin/php-cgi /home1/darksyde/public_html/index.php
=============== Pass 2 ===============
darksyde 3317 0.2 0.0 315612 28572 ? SN 21:47 0:01 /opt/php54/bin/php-cgi /home1/darksyde/public_html/index.php
darksyde 3526 0.2 0.0 315612 28556 ? SN 21:47 0:01 /opt/php54/bin/php-cgi /home1/darksyde/public_html/index.php
darksyde 5169 0.2 0.0 315356 28436 ? SN 21:48 0:01 /opt/php54/bin/php-cgi /home1/darksyde/public_html/index.php
darksyde 5519 0.2 0.0 315356 28492 ? SN 21:48 0:01 /opt/php54/bin/php-cgi /home1/darksyde/public_html/index.php
darksyde 5840 0.0 0.0 311244 23656 ? SN 21:48 0:00 /opt/php54/bin/php-cgi /home1/darksyde/public_html/index.php
darksyde 6088 0.2 0.0 315356 28348 ? SN 21:48 0:01 /opt/php54/bin/php-cgi /home1/darksyde/public_html/index.php
darksyde 6113 0.0 0.0 311244 23652 ? SN 21:48 0:00 /opt/php54/bin/php-cgi /home1/darksyde/public_html/index.php
darksyde 6339 0.2 0.0 315356 28404 ? SN 21:48 0:01 /opt/php54/bin/php-cgi /home1/darksyde/public_html/index.php
darksyde 6807 0.2 0.0 315356 28408 ? SN 21:48 0:01 /opt/php54/bin/php-cgi /home1/darksyde/public_html/index.php
darksyde 6871 0.2 0.0 315356 28340 ? SN 21:48 0:01 /opt/php54/bin/php-cgi /home1/darksyde/public_html/index.php
darksyde 7055 0.2 0.0 315356 28356 ? SN 21:49 0:01 /opt/php54/bin/php-cgi /home1/darksyde/public_html/index.php
darksyde 8978 0.2 0.0 315100 28184 ? SN 21:49 0:01 /opt/php54/bin/php-cgi /home1/darksyde/public_html/index.php
darksyde 9482 0.0 0.0 311244 23660 ? SN 21:49 0:00 /opt/php54/bin/php-cgi /home1/darksyde/public_html/index.php
darksyde 10015 0.0 0.0 311244 23660 ? SN 21:50 0:00 /opt/php54/bin/php-cgi /home1/darksyde/public_html/index.php
darksyde 10480 0.0 0.0 311244 23656 ? SN 21:50 0:00 /opt/php54/bin/php-cgi /home1/darksyde/public_html/index.php
darksyde 10515 0.0 0.0 311244 23652 ? SN 21:50 0:00 /opt/php54/bin/php-cgi /home1/darksyde/public_html/index.php
darksyde 10788 0.2 0.0 315100 28140 ? SN 21:50 0:01 /opt/php54/bin/php-cgi /home1/darksyde/public_html/index.php
darksyde 11410 0.0 0.0 311244 23664 ? SN 21:50 0:00 /opt/php54/bin/php-cgi /home1/darksyde/public_html/index.php
darksyde 12337 0.0 0.0 311244 23668 ? SN 21:50 0:00 /opt/php54/bin/php-cgi /home1/darksyde/public_html/index.php
darksyde 14968 0.2 0.0 249052 27284 ? SN 21:51 0:01 /opt/php54/bin/php-cgi /home1/darksyde/public_html/index.php
darksyde 24676 0.4 0.0 249052 27412 ? SN 21:55 0:00 /opt/php54/bin/php-cgi /home1/darksyde/public_html/index.php
darksyde 29792 1.0 0.0 313820 26556 ? SN 21:57 0:00 /opt/php54/bin/php-cgi /home1/darksyde/public_html/index.php
darksyde 32319 6.0 0.0 313564 26416 ? SN 21:57 0:00 /opt/php54/bin/php-cgi /home1/darksyde/public_html/index.php
=============== Pass 3 ===============
darksyde 3317 0.2 0.0 315612 28572 ? SN 21:47 0:01 /opt/php54/bin/php-cgi /home1/darksyde/public_html/index.php
darksyde 3526 0.2 0.0 315612 28556 ? SN 21:47 0:01 /opt/php54/bin/php-cgi /home1/darksyde/public_html/index.php
darksyde 5169 0.2 0.0 315356 28436 ? SN 21:48 0:01 /opt/php54/bin/php-cgi /home1/darksyde/public_html/index.php
darksyde 5519 0.2 0.0 315356 28492 ? SN 21:48 0:01 /opt/php54/bin/php-cgi /home1/darksyde/public_html/index.php
darksyde 5840 0.0 0.0 311244 23656 ? SN 21:48 0:00 /opt/php54/bin/php-cgi /home1/darksyde/public_html/index.php
darksyde 6088 0.2 0.0 315356 28348 ? SN 21:48 0:01 /opt/php54/bin/php-cgi /home1/darksyde/public_html/index.php
darksyde 6113 0.0 0.0 311244 23652 ? SN 21:48 0:00 /opt/php54/bin/php-cgi /home1/darksyde/public_html/index.php
darksyde 6339 0.2 0.0 315356 28416 ? SN 21:48 0:01 /opt/php54/bin/php-cgi /home1/darksyde/public_html/index.php
darksyde 6807 0.2 0.0 315356 28424 ? SN 21:48 0:01 /opt/php54/bin/php-cgi /home1/darksyde/public_html/index.php
darksyde 6871 0.2 0.0 315356 28344 ? SN 21:48 0:01 /opt/php54/bin/php-cgi /home1/darksyde/public_html/index.php
darksyde 7055 0.2 0.0 315356 28360 ? SN 21:49 0:01 /opt/php54/bin/php-cgi /home1/darksyde/public_html/index.php
darksyde 8978 0.2 0.0 315100 28184 ? SN 21:49 0:01 /opt/php54/bin/php-cgi /home1/darksyde/public_html/index.php
darksyde 9482 0.0 0.0 311244 23660 ? SN 21:49 0:00 /opt/php54/bin/php-cgi /home1/darksyde/public_html/index.php
darksyde 10015 0.0 0.0 311244 23660 ? SN 21:50 0:00 /opt/php54/bin/php-cgi /home1/darksyde/public_html/index.php
darksyde 10480 0.0 0.0 311244 23656 ? SN 21:50 0:00 /opt/php54/bin/php-cgi /home1/darksyde/public_html/index.php
darksyde 10515 0.0 0.0 311244 23652 ? SN 21:50 0:00 /opt/php54/bin/php-cgi /home1/darksyde/public_html/index.php
darksyde 10788 0.2 0.0 315100 28140 ? SN 21:50 0:01 /opt/php54/bin/php-cgi /home1/darksyde/public_html/index.php
darksyde 11410 0.0 0.0 311244 23664 ? SN 21:50 0:00 /opt/php54/bin/php-cgi /home1/darksyde/public_html/index.php
darksyde 12337 0.0 0.0 311244 23668 ? SN 21:50 0:00 /opt/php54/bin/php-cgi /home1/darksyde/public_html/index.php
darksyde 14968 0.2 0.0 249052 27292 ? SN 21:51 0:01 /opt/php54/bin/php-cgi /home1/darksyde/public_html/index.php
darksyde 24676 0.4 0.0 249052 27412 ? SN 21:55 0:00 /opt/php54/bin/php-cgi /home1/darksyde/public_html/index.php
darksyde 29792 1.0 0.0 313820 26560 ? SN 21:57 0:00 /opt/php54/bin/php-cgi /home1/darksyde/public_html/index.php
darksyde 32319 5.3 0.0 313564 26420 ? SN 21:57 0:00 /opt/php54/bin/php-cgi /home1/darksyde/public_html/index.php

Running Queries:
*************************** 1. row ***************************

STATE: Copying to tmp table
TIME: 0
COMMAND: Query
INFO: SELECT DISTINCT p.manufacturer_id, m.name
FROM products p
LEFT JOIN manufacturers m ON p.manufacturer_id = m.manufacturer_id
WHERE p.product_id IN (SELECT DISTINCT p2c.product_id
FROM products_to_categories p2c
INNER JOIN products p ON p.product_id = p2c.product_id
WHERE p.status = '1' AND p2c.category_id IN (1, 2, 67))
*************************** 2. row ***************************

STATE: Copying to tmp table
TIME: 0
COMMAND: Query
INFO: SELECT DISTINCT p.manufacturer_id, m.name
FROM products p
LEFT JOIN manufacturers m ON p.manufacturer_id = m.manufacturer_id
WHERE p.product_id IN (SELECT DISTINCT p2c.product_id
FROM products_to_categories p2c
INNER JOIN products p ON p.product_id = p2c.product_id
WHERE p.status = '1' AND p2c.category_id IN (1, 2, 140))
*************************** 3. row ***************************

STATE: Copying to tmp table
TIME: 0
COMMAND: Query
INFO: SELECT DISTINCT p.manufacturer_id, m.name
FROM products p
LEFT JOIN manufacturers m ON p.manufacturer_id = m.manufacturer_id
WHERE p.product_id IN (SELECT DISTINCT p2c.product_id
FROM products_to_categories p2c
INNER JOIN products p ON p.product_id = p2c.product_id
WHERE p.status = '1' AND p2c.category_id IN (1, 105))
*************************** 4. row ***************************

STATE: Copying to tmp table
TIME: 0
COMMAND: Query
INFO: SELECT DISTINCT p.manufacturer_id, m.name
FROM products p
LEFT JOIN manufacturers m ON p.manufacturer_id = m.manufacturer_id
WHERE p.product_id IN (SELECT DISTINCT p2c.product_id
FROM products_to_categories p2c
INNER JOIN products p ON p.product_id = p2c.product_id
WHERE p.status = '1' AND p2c.category_id IN (98, 99))
*************************** 5. row ***************************

STATE: Sending data
TIME: 0
COMMAND: Query
INFO: SELECT COUNT(DISTINCT p2c.product_id) AS total
FROM products_to_categories p2c
INNER JOIN products p ON p.product_id = p2c.product_id
WHERE p.status = '1' AND p2c.category_id IN (5, 48)
*************************** 6. row ***************************

STATE: Sending data
TIME: 0
COMMAND: Query
INFO: SELECT COUNT(DISTINCT p2c.product_id) AS total
FROM products_to_categories p2c
INNER JOIN products p ON p.product_id = p2c.product_id
WHERE p.status = '1' AND p2c.category_id IN (129, 270)
*************************** 7. row ***************************

STATE: Copying to tmp table
TIME: 0
COMMAND: Query
INFO: SELECT DISTINCT p.manufacturer_id, m.name
FROM products p
LEFT JOIN manufacturers m ON p.manufacturer_id = m.manufacturer_id
WHERE p.product_id IN (SELECT DISTINCT p2c.product_id
FROM products_to_categories p2c
INNER JOIN products p ON p.product_id = p2c.product_id
WHERE p.status = '1' AND p2c.category_id IN (118, 186))
***************Row 8**************
STATE: Copying to tmp table
TIME: 1
COMMAND: Query
INFO: SELECT DISTINCT p.manufacturer_id, m.name
FROM products p
LEFT JOIN manufacturers m ON p.manufacturer_id = m.manufacturer_id
WHERE p.product_id IN (SELECT DISTINCT p2c.product_id
FROM products_to_categories p2c
INNER JOIN products p ON p.product_id = p2c.product_id
WHERE p.status = '1' AND p2c.category_id IN (118, 186))
*************************** 9. row ***************************

STATE: Sending data
TIME: 0
COMMAND: Query
INFO: SELECT COUNT(DISTINCT p2c.product_id) AS total
FROM products_to_categories p2c
INNER JOIN products p ON p.product_id = p2c.product_id
WHERE p.status = '1' AND p2c.category_id IN (108, 109)
*************************** 10. row ***************************

STATE: Copying to tmp table
TIME: 1
COMMAND: Query
INFO: SELECT DISTINCT p.manufacturer_id, m.name
FROM products p
LEFT JOIN manufacturers m ON p.manufacturer_id = m.manufacturer_id
WHERE p.product_id IN (SELECT DISTINCT p2c.product_id
FROM products_to_categories p2c
INNER JOIN products p ON p.product_id = p2c.product_id
WHERE p.status = '1' AND p2c.category_id IN (230))
*************************** 11. row ***************************

STATE: Copying to tmp table
TIME: 1
COMMAND: Query
INFO: SELECT DISTINCT p.manufacturer_id, m.name
FROM products p
LEFT JOIN manufacturers m ON p.manufacturer_id = m.manufacturer_id
WHERE p.product_id IN (SELECT DISTINCT p2c.product_id
FROM products_to_categories p2c
INNER JOIN products p ON p.product_id = p2c.product_id
WHERE p.status = '1' AND p2c.category_id IN (42, 43))
*************************** 12. row ***************************

STATE: Sending data
TIME: 0
COMMAND: Query
INFO: SELECT COUNT(DISTINCT p2c.product_id) AS total
FROM products_to_categories p2c
INNER JOIN products p ON p.product_id = p2c.product_id
WHERE p.status = '1' AND p2c.category_id IN (189, 190)
*************************** 13. row ***************************

STATE: Copying to tmp table
TIME: 0
COMMAND: Query
INFO: SELECT DISTINCT p.manufacturer_id, m.name
FROM products p
LEFT JOIN manufacturers m ON p.manufacturer_id = m.manufacturer_id
WHERE p.product_id IN (SELECT DISTINCT p2c.product_id
FROM products_to_categories p2c
INNER JOIN products p ON p.product_id = p2c.product_id
WHERE p.status = '1' AND p2c.category_id IN (189))
*************************** 14. row ***************************

STATE: Sending data
TIME: 0
COMMAND: Query
INFO: SELECT COUNT(DISTINCT p2c.product_id) AS total
FROM products_to_categories p2c
INNER JOIN products p ON p.product_id = p2c.product_id
WHERE p.status = '1' AND p2c.category_id IN (70, 274)
*************************** 15. row ***************************

STATE: Copying to tmp table
TIME: 0
COMMAND: Query
INFO: SELECT DISTINCT p.manufacturer_id, m.name
FROM products p
LEFT JOIN manufacturers m ON p.manufacturer_id = m.manufacturer_id
WHERE p.product_id IN (SELECT DISTINCT p2c.product_id
FROM products_to_categories p2c
INNER JOIN products p ON p.product_id = p2c.product_id
WHERE p.status = '1' AND p2c.category_id IN (70, 272))

Open connections:

Recent Site Requests:
157.55.39.101   openblindboxes.com   GET   /le-merde-bangal-price-2011-dunny?keyword=2011%20Series
157.55.39.97   openblindboxes.com   GET   /aaron-meshon-dunny-2tone-series?keyword=Red%20Tail
157.55.39.97   openblindboxes.com   GET   /index.php?rt=product/search&keyword=Rob%20Zombie
157.55.39.97   openblindboxes.com   GET   /index.php?rt=product/search&keyword=Squid%20Kids%20Ink
157.55.39.97   openblindboxes.com   GET   /index.php?rt=product/search&keyword=flame
157.55.39.97   openblindboxes.com   GET   /montana-fatcap-series-1
157.55.39.98   openblindboxes.com   GET   /butters-south-park-kidrobot?keyword=South%20Park
157.55.39.98   openblindboxes.com   GET   /deranged-country-kid?keyword=Open%20Blind%20Boxes
157.55.39.98   openblindboxes.com   GET   /ryu-grey-street-fighter-series-1-kidrobot?keyword=World%20
173.35.126.96   openblindboxes.com   GET   /
173.35.126.96   openblindboxes.com   GET   /dunny-series-3?sort=date_modified-DESC
173.35.126.96   openblindboxes.com   GET   /dunny-series-3?sort=date_modified-DESC
173.35.126.96   openblindboxes.com   GET   /dunny-series-3?sort=date_modified-DESC
173.35.126.96   openblindboxes.com   GET   /dunny-series-3?sort=date_modified-DESC
173.35.126.96   openblindboxes.com   GET   /french?sort=date_modified-DESC
173.35.126.96   openblindboxes.com   GET   /french?sort=date_modified-DESC
173.35.126.96   openblindboxes.com   GET   /index.php?rt=checkout/cart
173.35.126.96   openblindboxes.com   GET   /index.php?rt=checkout/cart
173.35.126.96   openblindboxes.com   GET   /index.php?rt=checkout/cart
180.76.15.138   openblindboxes.com   GET   /marvel-frenzies
207.46.13.126   openblindboxes.com   GET   /index.php?rt=product/search&keyword=Big%20Bottle
207.46.13.34   openblindboxes.com   GET   /bruttino-tokidoki-cactus-friends?keyword=Kitty
207.46.13.34   openblindboxes.com   GET   /game-of-thrones-funko-mystery-minis
207.46.13.34   openblindboxes.com   GET   /mc-boooya-by-mad?keyword=Mad
220.181.108.81   openblindboxes.com   GET   /game-of-thrones-funko-mystery-minis
66.249.75.94   openblindboxes.com   GET   /scribe-bunny-costume-dunny-mardivale
76.28.36.114   openblindboxes.com   GET   /
99.135.189.220   openblindboxes.com   GET   /
99.135.189.220   openblindboxes.com   GET   /

I do have some extensions....

Otherwise nothing else has been installed on the server, this was a clean build with abantecart was the only thing ever on this server. 

The extensions I have are...
google merchant feed
Google sitemap
Paypal

And I think a couple of others, but I can not look at them, because they have taken me down and have not whitelisted my IP yet.  When they respond and let me back in I can reply with that.  I can get to my database though through myphpadmin so if there is an sql you want me to run, I can. 

Hostgator has taken my site down.  It says it was taking up too much of the server allocation and I need to repair some things to get it back online.  So essentially unless these things are fixed abantecart will no longer be allowed by hostgator for all clients.


Here is a list of recommendations from myphpadmin against my site.  Please let me know if any of these things can be fixed quickly?  If not then I will have to move to a new cart and anyone using hostgator will most likely have to as well. If I can do them on my side please let me know. I will be trying to figure out how to do some of these things. 


1.
Issue:
Too many sorts are causing temporary tables.

Recommendation:
Consider increasing sort_buffer_size and/or read_rnd_buffer_size, depending on your system memory limits

Justification:
Temporary tables average: 2.42 per second, this value should be less than 1 per hour.

Used variable / formula:
Sort_merge_passes / Uptime

Test:
value * 60 * 60 > 1

2.
Issue:
There are lots of rows being sorted.

Recommendation:
While there is nothing wrong with a high amount of row sorting, you might want to make sure that the queries which require a lot of sorting use indexed columns in the ORDER BY clause, as this will result in much faster sorting

Justification:
Sorted rows average: 13015.78 per second

Used variable / formula:
Sort_rows / Uptime

Test:
value * 60 >= 1

3.
Issue:
There are too many joins without indexes.

Recommendation:
This means that joins are doing full table scans. Adding indexes for the columns being used in the join conditions will greatly speed up table joins

Justification:
Table joins average: 115.63 per second, this value should be less than 1 per hour

Used variable / formula:
(Select_range_check + Select_scan + Select_full_join) / Uptime

Test:
value * 60 * 60 > 1


4.
Issue:
The rate of reading data from a fixed position is high.

Recommendation:
This indicates that many queries need to sort results and/or do a full table scan, including join queries that do not use indexes. Add indexes where applicable.

Justification:
Rate of reading fixed position average: 7701.54 per second, this value should be less than 1 per hour

Used variable / formula:
Handler_read_rnd / Uptime

Test:
value * 60 * 60 > 1

5.
Issue:
The rate of reading the next table row is high.

Recommendation:
This indicates that many queries are doing full table scans. Add indexes where applicable.

Justification:
Rate of reading next table row: 222113.76 per second, this value should be less than 1 per hour

Used variable / formula:
Handler_read_rnd_next / Uptime


6.
Issue:
Too many table locks were not granted immediately.

Recommendation:
Optimize queries and/or use InnoDB to reduce lock wait.

Justification:
Table lock wait rate: 7.16 per minute, this value should be less than 1 per hour

Used variable / formula:
Table_locks_waited / Uptime

7.
Issue:
Too many clients are aborted.

Recommendation:
Clients are usually aborted when they did not close their connection to MySQL properly. This can be due to network issues or code not closing a database handler properly. Check your network and code.

Justification:
Aborted client rate is at 40.14 per hour, this value should be less than 1 per hour

Used variable / formula:
Aborted_clients / Uptime

Are the open connections supposed to be open after the query is completed? I am trying to figure out the issue.

Mysql connections are closed after each request (page request). Not after every query.

What is your current aborted rate per hour?   Obviously 40 per hour when it is supposed to be less than 1 seems like a large issue. 

Issue:
Too many clients are aborted.

Recommendation:
Clients are usually aborted when they did not close their connection to MySQL properly. This can be due to network issues or code not closing a database handler properly. Check your network and code.

Justification:
Aborted client rate is at 40.08 per hour, this value should be less than 1 per hour

Used variable / formula:
Aborted_clients / Uptime

Test:
value * 60 * 60 > 1

Here is show status like '%onn%' against my db. 


Variable_name
Value
Aborted_connects
5257957
Connections
87119605
Max_used_connections
451
Ssl_client_connects
0
Ssl_connect_renegotiates
0
Ssl_finished_connects
0
Threads_connected
12

Have there been any major changes to database queries or database handling in 1.2.3?  Hostgator just quarantined my database for the time being saying my queries were taking up significant use on the server.  I was taking up for than 50% server allocation on queries.  They pulled these down in the last hour.    I have asked for specific queries that were causing the load but I have not gotten a response back yet.

Are the open connections supposed to be open after the query is completed? I am trying to figure out the issue.

Running Queries:
*************************** 1. row ***************************

STATE: Copying to tmp table
TIME: 0
COMMAND: Query
INFO: SELECT DISTINCT p.manufacturer_id, m.name
FROM products p
LEFT JOIN manufacturers m ON p.manufacturer_id = m.manufacturer_id
WHERE p.product_id IN (SELECT DISTINCT p2c.product_id
FROM products_to_categories p2c
INNER JOIN products p ON p.product_id = p2c.product_id
WHERE p.status = '1' AND p2c.category_id IN (1, 2, 67))
*************************** 2. row ***************************

STATE: Copying to tmp table
TIME: 0
COMMAND: Query
INFO: SELECT DISTINCT p.manufacturer_id, m.name
FROM products p
LEFT JOIN manufacturers m ON p.manufacturer_id = m.manufacturer_id
WHERE p.product_id IN (SELECT DISTINCT p2c.product_id
FROM products_to_categories p2c
INNER JOIN products p ON p.product_id = p2c.product_id
WHERE p.status = '1' AND p2c.category_id IN (1, 2, 140))
*************************** 3. row ***************************

STATE: Copying to tmp table
TIME: 0
COMMAND: Query
INFO: SELECT DISTINCT p.manufacturer_id, m.name
FROM products p
LEFT JOIN manufacturers m ON p.manufacturer_id = m.manufacturer_id
WHERE p.product_id IN (SELECT DISTINCT p2c.product_id
FROM products_to_categories p2c
INNER JOIN products p ON p.product_id = p2c.product_id
WHERE p.status = '1' AND p2c.category_id IN (1, 105))
*************************** 4. row ***************************

STATE: Copying to tmp table
TIME: 0
COMMAND: Query
INFO: SELECT DISTINCT p.manufacturer_id, m.name
FROM products p
LEFT JOIN manufacturers m ON p.manufacturer_id = m.manufacturer_id
WHERE p.product_id IN (SELECT DISTINCT p2c.product_id
FROM products_to_categories p2c
INNER JOIN products p ON p.product_id = p2c.product_id
WHERE p.status = '1' AND p2c.category_id IN (98, 99))
*************************** 5. row ***************************
USER: darksyde_dbuser
DB: darksyde_localhost
STATE: Sending data
TIME: 0
COMMAND: Query
INFO: SELECT COUNT(DISTINCT p2c.product_id) AS total
FROM products_to_categories p2c
INNER JOIN products p ON p.product_id = p2c.product_id
WHERE p.status = '1' AND p2c.category_id IN (5, 48)
*************************** 6. row ***************************

STATE: Sending data
TIME: 0
COMMAND: Query
INFO: SELECT COUNT(DISTINCT p2c.product_id) AS total
FROM products_to_categories p2c
INNER JOIN products p ON p.product_id = p2c.product_id
WHERE p.status = '1' AND p2c.category_id IN (129, 270)
*************************** 7. row ***************************

STATE: Copying to tmp table
TIME: 0
COMMAND: Query
INFO: SELECT DISTINCT p.manufacturer_id, m.name
FROM products p
LEFT JOIN manufacturers m ON p.manufacturer_id = m.manufacturer_id
WHERE p.product_id IN (SELECT DISTINCT p2c.product_id
FROM products_to_categories p2c
INNER JOIN products p ON p.product_id = p2c.product_id
WHERE p.status = '1' AND p2c.category_id IN (118, 186))
*************************** 8. row ***************************

STATE: Copying to tmp table
TIME: 1
COMMAND: Query
INFO: SELECT DISTINCT p.manufacturer_id, m.name
FROM products p
LEFT JOIN manufacturers m ON p.manufacturer_id = m.manufacturer_id
WHERE p.product_id IN (SELECT DISTINCT p2c.product_id
FROM products_to_categories p2c
INNER JOIN products p ON p.product_id = p2c.product_id
WHERE p.status = '1' AND p2c.category_id IN (118, 186))
*************************** 9. row ***************************

STATE: Sending data
TIME: 0
COMMAND: Query
INFO: SELECT COUNT(DISTINCT p2c.product_id) AS total
FROM products_to_categories p2c
INNER JOIN products p ON p.product_id = p2c.product_id
WHERE p.status = '1' AND p2c.category_id IN (108, 109)
*************************** 10. row ***************************

STATE: Copying to tmp table
TIME: 1
COMMAND: Query
INFO: SELECT DISTINCT p.manufacturer_id, m.name
FROM products p
LEFT JOIN manufacturers m ON p.manufacturer_id = m.manufacturer_id
WHERE p.product_id IN (SELECT DISTINCT p2c.product_id
FROM products_to_categories p2c
INNER JOIN products p ON p.product_id = p2c.product_id
WHERE p.status = '1' AND p2c.category_id IN (230))
*************************** 11. row ***************************

STATE: Copying to tmp table
TIME: 1
COMMAND: Query
INFO: SELECT DISTINCT p.manufacturer_id, m.name
FROM products p
LEFT JOIN manufacturers m ON p.manufacturer_id = m.manufacturer_id
WHERE p.product_id IN (SELECT DISTINCT p2c.product_id
FROM products_to_categories p2c
INNER JOIN products p ON p.product_id = p2c.product_id
WHERE p.status = '1' AND p2c.category_id IN (42, 43))
*************************** 12. row ***************************

STATE: Sending data
TIME: 0
COMMAND: Query
INFO: SELECT COUNT(DISTINCT p2c.product_id) AS total
FROM products_to_categories p2c
INNER JOIN products p ON p.product_id = p2c.product_id
WHERE p.status = '1' AND p2c.category_id IN (189, 190)
*************************** 13. row ***************************

STATE: Copying to tmp table
TIME: 0
COMMAND: Query
INFO: SELECT DISTINCT p.manufacturer_id, m.name
FROM products p
LEFT JOIN manufacturers m ON p.manufacturer_id = m.manufacturer_id
WHERE p.product_id IN (SELECT DISTINCT p2c.product_id
FROM products_to_categories p2c
INNER JOIN products p ON p.product_id = p2c.product_id
WHERE p.status = '1' AND p2c.category_id IN (189))
*************************** 14. row ***************************

STATE: Sending data
TIME: 0
COMMAND: Query
INFO: SELECT COUNT(DISTINCT p2c.product_id) AS total
FROM products_to_categories p2c
INNER JOIN products p ON p.product_id = p2c.product_id
WHERE p.status = '1' AND p2c.category_id IN (70, 274)
*************************** 15. row ***************************

STATE: Copying to tmp table
TIME: 0
COMMAND: Query
INFO: SELECT DISTINCT p.manufacturer_id, m.name
FROM products p
LEFT JOIN manufacturers m ON p.manufacturer_id = m.manufacturer_id
WHERE p.product_id IN (SELECT DISTINCT p2c.product_id
FROM products_to_categories p2c
INNER JOIN products p ON p.product_id = p2c.product_id
WHERE p.status = '1' AND p2c.category_id IN (70, 272))

Open connections:

Recent Site Requests:
157.55.39.101   openblindboxes.com   GET   /le-merde-bangal-price-2011-dunny?keyword=2011%20Series
157.55.39.97   openblindboxes.com   GET   /aaron-meshon-dunny-2tone-series?keyword=Red%20Tail
157.55.39.97   openblindboxes.com   GET   /index.php?rt=product/search&keyword=Rob%20Zombie
157.55.39.97   openblindboxes.com   GET   /index.php?rt=product/search&keyword=Squid%20Kids%20Ink
157.55.39.97   openblindboxes.com   GET   /index.php?rt=product/search&keyword=flame
157.55.39.97   openblindboxes.com   GET   /montana-fatcap-series-1
157.55.39.98   openblindboxes.com   GET   /butters-south-park-kidrobot?keyword=South%20Park
157.55.39.98   openblindboxes.com   GET   /deranged-country-kid?keyword=Open%20Blind%20Boxes
157.55.39.98   openblindboxes.com   GET   /ryu-grey-street-fighter-series-1-kidrobot?keyword=World%20
173.35.126.96   openblindboxes.com   GET   /
173.35.126.96   openblindboxes.com   GET   /dunny-series-3?sort=date_modified-DESC
173.35.126.96   openblindboxes.com   GET   /dunny-series-3?sort=date_modified-DESC
173.35.126.96   openblindboxes.com   GET   /dunny-series-3?sort=date_modified-DESC
173.35.126.96   openblindboxes.com   GET   /dunny-series-3?sort=date_modified-DESC
173.35.126.96   openblindboxes.com   GET   /french?sort=date_modified-DESC
173.35.126.96   openblindboxes.com   GET   /french?sort=date_modified-DESC
173.35.126.96   openblindboxes.com   GET   /index.php?rt=checkout/cart
173.35.126.96   openblindboxes.com   GET   /index.php?rt=checkout/cart
173.35.126.96   openblindboxes.com   GET   /index.php?rt=checkout/cart
180.76.15.138   openblindboxes.com   GET   /marvel-frenzies
207.46.13.126   openblindboxes.com   GET   /index.php?rt=product/search&keyword=Big%20Bottle
207.46.13.34   openblindboxes.com   GET   /bruttino-tokidoki-cactus-friends?keyword=Kitty
207.46.13.34   openblindboxes.com   GET   /game-of-thrones-funko-mystery-minis
207.46.13.34   openblindboxes.com   GET   /mc-boooya-by-mad?keyword=Mad
220.181.108.81   openblindboxes.com   GET   /game-of-thrones-funko-mystery-minis
66.249.75.94   openblindboxes.com   GET   /scribe-bunny-costume-dunny-mardivale
76.28.36.114   openblindboxes.com   GET   /
99.135.189.220   openblindboxes.com   GET   /
99.135.189.220   openblindboxes.com   GET   /