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
Quote from: thedarksyde on August 03, 2015, 11:40:59 AM
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.
Before we proceed further. Do you have any other applications running on your server?
Did you install any third party extensions into Abantecart? Did you set up some croned processes?
Are you sure that your server was not hacked?
The reason I ask this, AbanteCart DOES NOT create temporary tables. Storefront is optimized with caching technology that will not cause heavy load on the database.
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.
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 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.
Quote from: thedarksyde on August 04, 2015, 09:51:40 AM
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.
Suggestion:
Try to disable third-party addons. For example you have google merchant feed, Google sitemap - in case Google robot visit your site too often this can overload your hosting server depending on products quantity, google time visit etc.
If Google is crawling your site too often, and slowing down your server, you can change the crawl ratehttps://support.google.com/webmasters/answer/48620?hl=en
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.
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>
I see only 1 error with SQL. Are you sure all tables are present in your database and nothing got deleted?
I tried this query on my Mysql and it works without any errors.
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.
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
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>