Home > 


# 2.8s user time, 30ms system time, 25.35M rss, 89.96M vsz
# Current date: Fri Aug 22 17:58:07 2014
# Hostname: grey1k.beget.ru
# Files: /var/log/mysql/slow.log, /var/log/mysql/slow.log.1, /var/log/mysql/slow.log.2
# Overall: 7 total, 3 unique, 0.00 QPS, 0.00x concurrency ________________
# Time range: 2014-08-20 11:23:55 to 2014-08-22 08:02:16
# Attribute total min max avg 95% stddev median
# ============ ======= ======= ======= ======= ======= ======= =======
# Exec time 121s 12s 20s 17s 19s 2s 17s
# Lock time 51ms 155us 50ms 7ms 48ms 17ms 194us
# Rows sent 9 1 3 1.29 2.90 0.67 0.99
# Rows examine 15.39k 67 2.94k 2.20k 2.89k 1011.79 2.89k
# Rows affecte 0 0 0 0 0 0 0
# Bytes sent 6.21k 60 5.85k 908.14 5.73k 1.98k 59.77
# Query size 2.88k 303 462 421.29 441.81 50.33 441.81

# Profile
# Rank Query ID Response time Calls R/Call V/M Item
# ==== ================== ============= ===== ======= ===== ==============
# 1 0x2B7932AFEE815737 66.1885 54.9% 4 16.5471 0.44 SELECT oc_category_path oc_product_to_category oc_product oc_product_description oc_product_to_store
# 2 0x02AD268D76F672AF 36.7131 30.5% 2 18.3566 0.20 SELECT oc_product_to_category oc_product oc_product_description oc_product_to_store
# 3 0x270EA830AC8D7EE7 17.6531 14.6% 1 17.6531 0.00 SELECT oc_category oc_category_description oc_category_to_store

# Query 1: 0.00 QPS, 0.00x concurrency, ID 0x2B7932AFEE815737 at byte 10176675
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.44
# Time range: 2014-08-20 15:35:29 to 2014-08-22 08:02:16
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 57 4
# Exec time 54 66s 12s 20s 17s 19s 3s 17s
# Lock time 1 809us 179us 217us 202us 214us 15us 214us
# Rows sent 44 4 1 1 1 1 0 1
# Rows examine 75 11.66k 2.90k 2.94k 2.91k 2.89k 0 2.89k
# Rows affecte 0 0 0 0 0 0 0 0
# Bytes sent 3 242 60 61 60.50 59.77 0 59.77
# Query size 62 1.80k 462 462 462 462 0 462
# String:
# Databases marinaeu_parket
# Hosts localhost
# Last errno 0
# Users marinaeu_parket
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms
# 1s
# 10s+ ################################################################
# Tables
# SHOW TABLE STATUS FROM `marinaeu_parket` LIKE 'oc_category_path'\G
# SHOW CREATE TABLE `marinaeu_parket`.`oc_category_path`\G
# SHOW TABLE STATUS FROM `marinaeu_parket` LIKE 'oc_product_to_category'\G
# SHOW CREATE TABLE `marinaeu_parket`.`oc_product_to_category`\G
# SHOW TABLE STATUS FROM `marinaeu_parket` LIKE 'oc_product'\G
# SHOW CREATE TABLE `marinaeu_parket`.`oc_product`\G
# SHOW TABLE STATUS FROM `marinaeu_parket` LIKE 'oc_product_description'\G
# SHOW CREATE TABLE `marinaeu_parket`.`oc_product_description`\G
# SHOW TABLE STATUS FROM `marinaeu_parket` LIKE 'oc_product_to_store'\G
# SHOW CREATE TABLE `marinaeu_parket`.`oc_product_to_store`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_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 = '85'\G

# Query 2: 0.00 QPS, 0.00x concurrency, ID 0x02AD268D76F672AF at byte 160227
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.20
# Time range: 2014-08-20 20:37:12 to 2014-08-21 07:12:34
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 28 2
# Exec time 30 37s 17s 20s 18s 20s 2s 18s
# Lock time 0 323us 155us 168us 161us 168us 9us 161us
# Rows sent 22 2 1 1 1 1 0 1
# Rows examine 23 3.67k 1.82k 1.86k 1.84k 1.86k 26.87 1.84k
# Rows affecte 0 0 0 0 0 0 0 0
# Bytes sent 1 122 61 61 61 61 0 61
# Query size 27 798 399 399 399 399 0 399
# String:
# Databases marinaeu_parket
# Hosts localhost
# Last errno 0
# Users marinaeu_parket
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms
# 1s
# 10s+ ################################################################
# Tables
# SHOW TABLE STATUS FROM `marinaeu_parket` LIKE 'oc_product_to_category'\G
# SHOW CREATE TABLE `marinaeu_parket`.`oc_product_to_category`\G
# SHOW TABLE STATUS FROM `marinaeu_parket` LIKE 'oc_product'\G
# SHOW CREATE TABLE `marinaeu_parket`.`oc_product`\G
# SHOW TABLE STATUS FROM `marinaeu_parket` LIKE 'oc_product_description'\G
# SHOW CREATE TABLE `marinaeu_parket`.`oc_product_description`\G
# SHOW TABLE STATUS FROM `marinaeu_parket` LIKE 'oc_product_to_store'\G
# SHOW CREATE TABLE `marinaeu_parket`.`oc_product_to_store`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_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 p2c.category_id = '73'\G

# Query 3: 0 QPS, 0x concurrency, ID 0x270EA830AC8D7EE7 at byte 669413 ___
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: all events occurred at 2014-08-20 11:23:55
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 14 1
# Exec time 14 18s 18s 18s 18s 18s 0 18s
# Lock time 97 50ms 50ms 50ms 50ms 50ms 0 50ms
# Rows sent 33 3 3 3 3 3 0 3
# Rows examine 0 67 67 67 67 67 0 67
# Rows affecte 0 0 0 0 0 0 0 0
# Bytes sent 94 5.85k 5.85k 5.85k 5.85k 5.85k 0 5.85k
# Query size 10 303 303 303 303 303 0 303
# String:
# Databases marinaeu_parket
# Hosts localhost
# Last errno 0
# Users marinaeu_parket
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms
# 1s
# 10s+ ################################################################
# Tables
# SHOW TABLE STATUS FROM `marinaeu_parket` LIKE 'oc_category'\G
# SHOW CREATE TABLE `marinaeu_parket`.`oc_category`\G
# SHOW TABLE STATUS FROM `marinaeu_parket` LIKE 'oc_category_description'\G
# SHOW CREATE TABLE `marinaeu_parket`.`oc_category_description`\G
# SHOW TABLE STATUS FROM `marinaeu_parket` LIKE 'oc_category_to_store'\G
# SHOW CREATE TABLE `marinaeu_parket`.`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 = '79' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)\G
Search more related documents:
Download Document:

Set Home | Add to Favorites

All Rights Reserved Powered by Free Document Search and Download

Copyright © 2011
This site does not host pdf,doc,ppt,xls,rtf,txt files all document are the property of their respective owners. complaint#downhi.com
TOP