Author Topic: Database recommendations from myphpadmin Hostgator took down site. (Read 18270 times)

thedarksyde · « **on:** August 03, 2015, 11:40:59 AM »

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

abantecart · « **Reply #1 on:** August 03, 2015, 02:30:49 PM »

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.

thedarksyde · « **Reply #2 on:** August 03, 2015, 02:36:53 PM »

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.

thedarksyde · « **Reply #3 on:** August 03, 2015, 02:41:03 PM »

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   /

thedarksyde · « **Reply #4 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.

Basara · « **Reply #5 on:** August 05, 2015, 01:45:16 AM »

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.

Code: [Select]

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

thedarksyde · « **Reply #6 on:** August 05, 2015, 03:01:10 PM »

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.

thedarksyde · « **Reply #7 on:** August 05, 2015, 03:06:26 PM »

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 /home1/darksyde/public_html/core/database/amysqli.php on line 105

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

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 /home1/darksyde/public_html/core/lib/cache.php on line 78

eCommerce Core · « **Reply #8 on:** August 06, 2015, 10:35:11 AM »

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.

thedarksyde · « **Reply #9 on:** August 06, 2015, 01:16:10 PM »

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.

thedarksyde · « **Reply #10 on:** August 06, 2015, 01:36:19 PM »

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

thedarksyde · « **Reply #11 on:** August 06, 2015, 02:18:08 PM »

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 /home1/darksyde/public_html/core/database/amysqli.php on line 105

News:

Author Topic: Database recommendations from myphpadmin Hostgator took down site. (Read 18270 times)

thedarksyde

Database recommendations from myphpadmin Hostgator took down site.

abantecart

Re: Database recommendations from myphpadmin Hostgator took down site.

thedarksyde

Re: Database recommendations from myphpadmin Hostgator took down site.

thedarksyde

Re: Database recommendations from myphpadmin Hostgator took down site.

thedarksyde

Re: Database recommendations from myphpadmin Hostgator took down site.

Basara

Re: Database recommendations from myphpadmin Hostgator took down site.

thedarksyde

Re: Database recommendations from myphpadmin Hostgator took down site.

thedarksyde

Re: Database recommendations from myphpadmin Hostgator took down site.

eCommerce Core

Re: Database recommendations from myphpadmin Hostgator took down site.

thedarksyde

Re: Database recommendations from myphpadmin Hostgator took down site.

thedarksyde

Re: Database recommendations from myphpadmin Hostgator took down site.

thedarksyde

Re: Database recommendations from myphpadmin Hostgator took down site.