Перейти к содержанию
artsmart

Причины медленной загрузки сайта по Slow запросам

Рекомендуемые сообщения

Привет всем,

 

поставил сайт на хостинг

но грузится очень долго каждая страница

 

помогите снизить/оптимизировать запросы,

вот лог за прошлый день Сайт1 стоит на OpenCarte


# 13.6s user time, 120ms system time, 32.81M rss, 106.81M vsz
# Current date: Wed Apr 1 22:15:41 2015
# Hostname: kondr.beget.ru
# Files: STDIN
# Overall: 36 total, 7 unique, 0.00 QPS, 0.00x concurrency _______________
# Time range: 2015-03-31 15:37:18 to 18:57:27
# Attribute total min max avg 95% stddev median
# ============ ======= ======= ======= ======= ======= ======= =======
# Exec time 48s 1s 2s 1s 2s 273ms 1s
# Lock time 1s 80us 58ms 28ms 48ms 21ms 31ms
# Rows sent 39 0 16 1.08 5.75 3.04 0
# Rows examine 14.66k 0 6.46k 417.03 621.67 1.44k 4.96
# Rows affecte 0 0 0 0 0 0 0
# Bytes sent 94.67k 60 65.37k 2.63k 2.89k 10.42k 271.23
# Query size 5.28k 61 587 150.31 463.90 154.36 62.76

# Profile
# Rank Query ID Response time Calls R/Call V/M Item
# ==== ================== ============= ===== ====== ===== ===============
# 1 0x90C186BB9D7C2816 25.4030 52.6% 19 1.3370 0.02 SELECT oc_site1url_alias
# 2 0x9474BEF71EF43158 9.9509 20.6% 8 1.2439 0.01 SELECT oc_site1url_alias_blog
# 3 0x29910F5BF9FA73BC 4.4891 9.3% 2 2.2446 0.02 SELECT oc_site1category_path oc_site1product_to_category oc_site1product oc_site1product_description oc_site1product_to_store
# 4 0xCC71A6FFBD9263A6 2.4865 5.1% 2 1.2432 0.01 SELECT oc_site1category oc_site1category_description oc_site1category_to_store
# 5 0xB0E0489C9B0B10CA 2.4162 5.0% 2 1.2081 0.00 SELECT oc_site1tax_rule oc_site1tax_rate oc_site1tax_rate_to_customer_group oc_site1zone_to_geo_zone oc_site1geo_zone
# 6 0x54CAEAE1125C27C3 2.3824 4.9% 2 1.1912 0.00 SELECT oc_?category oc_?category_description oc_?category_to_store
# MISC 0xMISC 1.1887 2.5% 1 1.1887 0.0 <1 ITEMS>

# Query 1: 0.00 QPS, 0.00x concurrency, ID 0x90C186BB9D7C2816 at byte 11497373
# Scores: V/M = 0.02
# Time range: 2015-03-31 15:45:13 to 18:53:05
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 52 19
# Exec time 52 25s 1s 2s 1s 2s 181ms 1s
# Lock time 53 537ms 86us 58ms 28ms 48ms 21ms 41ms
# Rows sent 2 1 0 1 0.05 0 0.22 0
# Rows examine 0 95 5 5 5 5 0 5
# Rows affecte 0 0 0 0 0 0 0 0
# Bytes sent 5 5.13k 275 304 276.53 271.23 6.21 271.23
# Query size 22 1.17k 63 64 63.05 62.76 0 62.76
# String:
# Databases login_site1
# Hosts localhost
# Last errno 0
# Users login_site1
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms
# 1s ################################################################
# 10s+
# Tables
# SHOW TABLE STATUS FROM `login_site1` LIKE 'oc_site1url_alias'\G
# SHOW CREATE TABLE `login_site1`.`oc_site1url_alias`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT * FROM oc_site1url_alias WHERE `query` = 'category_id=530'\G

# Query 2: 0.00 QPS, 0.00x concurrency, ID 0x9474BEF71EF43158 at byte 28497034
# Scores: V/M = 0.01
# Time range: 2015-03-31 17:42:26 to 18:54:56
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 22 8
# Exec time 20 10s 1s 2s 1s 2s 124ms 1s
# Lock time 26 272ms 80us 50ms 34ms 48ms 19ms 48ms
# Rows sent 0 0 0 0 0 0 0 0
# Rows examine 1 288 36 36 36 36 0 36
# Rows affecte 0 0 0 0 0 0 0 0
# Bytes sent 2 2.38k 305 305 305 305 0 305
# Query size 9 534 61 78 66.75 76.28 5.71 62.76
# String:
# Databases login_site1
# Hosts localhost
# Last errno 0
# Users login_site1
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms
# 1s ################################################################
# 10s+
# Tables
# SHOW TABLE STATUS FROM `login_site1` LIKE 'oc_site1url_alias_blog'\G
# SHOW CREATE TABLE `login_site1`.`oc_site1url_alias_blog`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT * FROM oc_site1url_alias_blog WHERE `query` = 'path=370_464'\G

# Query 3: 0.00 QPS, 0.00x concurrency, ID 0x29910F5BF9FA73BC at byte 10745250
# Scores: V/M = 0.02
# Time range: 2015-03-31 15:37:18 to 18:57:27
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 5 2
# Exec time 9 4s 2s 2s 2s 2s 221ms 2s
# Lock time 0 575us 246us 329us 287us 329us 58us 287us
# Rows sent 5 2 1 1 1 1 0 1
# Rows examine 88 12.91k 6.45k 6.46k 6.45k 6.46k 5.66 6.45k
# Rows affecte 0 0 0 0 0 0 0 0
# Bytes sent 0 120 60 60 60 60 0 60
# Query size 17 956 478 478 478 478 0 478
# String:
# Databases login_site1
# Hosts localhost
# Last errno 0
# Users login_site1
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms
# 1s ################################################################
# 10s+
# Tables
# SHOW TABLE STATUS FROM `login_site1` LIKE 'oc_site1category_path'\G
# SHOW CREATE TABLE `login_site1`.`oc_site1category_path`\G
# SHOW TABLE STATUS FROM `login_site1` LIKE 'oc_site1product_to_category'\G
# SHOW CREATE TABLE `login_site1`.`oc_site1product_to_category`\G
# SHOW TABLE STATUS FROM `login_site1` LIKE 'oc_site1product'\G
# SHOW CREATE TABLE `login_site1`.`oc_site1product`\G
# SHOW TABLE STATUS FROM `login_site1` LIKE 'oc_site1product_description'\G
# SHOW CREATE TABLE `login_site1`.`oc_site1product_description`\G
# SHOW TABLE STATUS FROM `login_site1` LIKE 'oc_site1product_to_store'\G
# SHOW CREATE TABLE `login_site1`.`oc_site1product_to_store`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_site1category_path cp LEFT JOIN oc_site1product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_site1product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_site1product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_site1product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '364'\G

# Query 4: 0.00 QPS, 0.00x concurrency, ID 0xCC71A6FFBD9263A6 at byte 20201755
# Scores: V/M = 0.01
# Time range: 2015-03-31 16:03:16 to 17:28:06
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 5 2
# Exec time 5 2s 1s 1s 1s 1s 117ms 1s
# Lock time 7 79ms 29ms 50ms 40ms 50ms 15ms 40ms
# Rows sent 56 22 6 16 11 16 7.07 11
# Rows examine 8 1.21k 602 632 617 632 21.21 617
# Rows affecte 0 0 0 0 0 0 0 0
# Bytes sent 5 4.82k 1.87k 2.95k 2.41k 2.95k 782.77 2.41k
# Query size 11 624 311 313 312 313 1.41 312
# String:
# Databases login_site1
# Hosts localhost
# Last errno 0
# Users login_site1
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms
# 1s ################################################################
# 10s+
# Tables
# SHOW TABLE STATUS FROM `login_site1` LIKE 'oc_site1category'\G
# SHOW CREATE TABLE `login_site1`.`oc_site1category`\G
# SHOW TABLE STATUS FROM `login_site1` LIKE 'oc_site1category_description'\G
# SHOW CREATE TABLE `login_site1`.`oc_site1category_description`\G
# SHOW TABLE STATUS FROM `login_site1` LIKE 'oc_site1category_to_store'\G
# SHOW CREATE TABLE `login_site1`.`oc_site1category_to_store`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT * FROM oc_site1category c LEFT JOIN oc_site1category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_site1category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '0' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)\G

# Query 5: 0.00 QPS, 0.00x concurrency, ID 0xB0E0489C9B0B10CA at byte 25468964
# Scores: V/M = 0.00
# Time range: 2015-03-31 15:49:53 to 18:34:38
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 5 2
# Exec time 5 2s 1s 1s 1s 1s 29ms 1s
# Lock time 6 62ms 29ms 32ms 31ms 32ms 2ms 31ms
# Rows sent 0 0 0 0 0 0 0 0
# Rows examine 0 0 0 0 0 0 0 0
# Rows affecte 0 0 0 0 0 0 0 0
# Bytes sent 0 720 360 360 360 360 0 360
# Query size 21 1.15k 587 587 587 587 0 587
# String:
# Databases login_site1
# Hosts localhost
# Last errno 0
# Users login_site1
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms
# 1s ################################################################
# 10s+
# Tables
# SHOW TABLE STATUS FROM `login_site1` LIKE 'oc_site1tax_rule'\G
# SHOW CREATE TABLE `login_site1`.`oc_site1tax_rule`\G
# SHOW TABLE STATUS FROM `login_site1` LIKE 'oc_site1tax_rate'\G
# SHOW CREATE TABLE `login_site1`.`oc_site1tax_rate`\G
# SHOW TABLE STATUS FROM `login_site1` LIKE 'oc_site1tax_rate_to_customer_group'\G
# SHOW CREATE TABLE `login_site1`.`oc_site1tax_rate_to_customer_group`\G
# SHOW TABLE STATUS FROM `login_site1` LIKE 'oc_site1zone_to_geo_zone'\G
# SHOW CREATE TABLE `login_site1`.`oc_site1zone_to_geo_zone`\G
# SHOW TABLE STATUS FROM `login_site1` LIKE 'oc_site1geo_zone'\G
# SHOW CREATE TABLE `login_site1`.`oc_site1geo_zone`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority FROM oc_site1tax_rule tr1 LEFT JOIN oc_site1tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id) INNER JOIN oc_site1tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id) LEFT JOIN oc_site1zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id) LEFT JOIN oc_site1geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id) WHERE tr1.tax_class_id = '9' AND tr1.based = 'shipping' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '176' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '2761') ORDER BY tr1.priority ASC\G

# Query 6: 0.00 QPS, 0.00x concurrency, ID 0x54CAEAE1125C27C3 at byte 17482483
# Scores: V/M = 0.00
# Time range: 2015-03-31 17:03:44 to 17:35:00
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 5 2
# Exec time 4 2s 1s 1s 1s 1s 57ms 1s
# Lock time 5 51ms 352us 50ms 25ms 50ms 35ms 25ms
# Rows sent 23 9 0 9 4.50 9 6.36 4.50
# Rows examine 1 155 64 91 77.50 91 19.09 77.50
# Rows affecte 0 0 0 0 0 0 0 0
# Bytes sent 70 66.79k 1.43k 65.37k 33.40k 65.37k 45.21k 33.40k
# Query size 11 611 305 306 305.50 306 0.71 305.50
# String:
# Databases login_site2
# Hosts localhost
# Last errno 0
# Users login_site2
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms
# 1s ################################################################
# 10s+
# Tables
# SHOW TABLE STATUS FROM `login_site2` LIKE 'oc_category'\G
# SHOW CREATE TABLE `login_site2`.`oc_category`\G
# SHOW TABLE STATUS FROM `login_site2` LIKE 'oc_category_description'\G
# SHOW CREATE TABLE `login_site2`.`oc_category_description`\G
# SHOW TABLE STATUS FROM `login_site2` LIKE 'oc_category_to_store'\G
# SHOW CREATE TABLE `login_site2`.`oc_category_to_store`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '81' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)\G

Поделиться сообщением


Ссылка на сообщение
Поделиться на другие сайты

вырубай подсчет товаров и заодно пойди поговори с автором используемого блога.

Поделиться сообщением


Ссылка на сообщение
Поделиться на другие сайты

Для публикации сообщений создайте учётную запись или авторизуйтесь

Вы должны быть пользователем, чтобы оставить комментарий

Создать учетную запись

Зарегистрируйте новую учётную запись в нашем сообществе. Это очень просто!

Регистрация нового пользователя

Войти

Уже есть аккаунт? Войти в систему.

Войти

  • Последние посетители   0 пользователей онлайн

    Ни одного зарегистрированного пользователя не просматривает данную страницу

×

Важная информация

На нашем сайте используются файлы cookie и происходит обработка некоторых персональных данных пользователей, чтобы улучшить пользовательский интерфейс. Чтобы узнать для чего и какие персональные данные мы обрабатываем перейдите по ссылке. Если Вы нажмете «Я даю согласие», это означает, что Вы понимаете и принимаете все условия, указанные в этом Уведомлении о Конфиденциальности.