Skip to content

Instantly share code, notes, and snippets.

@samm-git

samm-git/gist:ca47575f523455a3658f914e30de5fa6

Created September 15, 2016 14:07
Show Gist options
  • Save samm-git/ca47575f523455a3658f914e30de5fa6 to your computer and use it in GitHub Desktop.
Save samm-git/ca47575f523455a3658f914e30de5fa6 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
# 320ms user time, 30ms system time, 29.00M rss, 2.36G vsz
# Current date: Thu Sep 15 16:07:08 2016
# Hostname: Administrators-MacBook-Pro.local
# Files: /usr/local/var/mysql/Administrators-MacBook-Pro-slow.log
# Overall: 428 total, 37 unique, 0 QPS, 0x concurrency ___________________
# Attribute total min max avg 95% stddev median
# ============ ======= ======= ======= ======= ======= ======= =======
# Exec time 185ms 8us 6ms 432us 972us 418us 316us
# Lock time 43ms 0 807us 100us 194us 63us 84us
# Rows sent 5.22k 0 1.30k 12.49 38.53 64.08 0.99
# Rows examine 32.50k 0 2.61k 77.76 192.76 145.33 0.99
# Query size 147.11k 6 6.97k 351.97 487.09 366.33 346.17
# Profile
# Rank Query ID Response time Calls R/Call V/M Item
# ==== ================== ============= ===== ====== ===== ===============
# 1 0x9EAEE23C9CEB386B 0.0801 43.3% 93 0.0009 0.00 SELECT eav_attribute eav_entity_type eav_entity_attribute catalog_eav_attribute
# 2 0x004EBA1FCB621686 0.0421 22.7% 93 0.0005 0.00 SELECT eav_attribute eav_entity_type eav_entity_attribute catalog_eav_attribute
# 3 0xF7A425D916EE085D 0.0209 11.3% 94 0.0002 0.00 SELECT catalog_category_flat_store_?
# 4 0x2D8C823DE326C77D 0.0178 9.6% 94 0.0002 0.00 SELECT magento_catalogevent_event
# 5 0x35AAC71503957920 0.0059 3.2% 1 0.0059 0.00 FLUSH
# 6 0xCE7E1A111C3749E9 0.0038 2.0% 6 0.0006 0.00 SELECT cms_block cms_block_store
# 7 0x1D76FEEBD39E44BC 0.0028 1.5% 1 0.0028 0.00 SELECT report_viewed_product_index
# 8 0x19BDF00FF30757C6 0.0018 1.0% 1 0.0018 0.00 SELECT catalog_product_entity catalog_category_product
# 9 0x4FF9F7B35BE1338D 0.0012 0.7% 5 0.0002 0.00 SELECT url_rewrite
# MISC 0xMISC 0.0087 4.7% 40 0.0002 0.0 <28 ITEMS>
# Query 1: 0 QPS, 0x concurrency, ID 0x9EAEE23C9CEB386B at byte 148723 ___
# Scores: V/M = 0.00
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 21 93
# Exec time 43 80ms 623us 2ms 860us 1ms 239us 725us
# Lock time 20 9ms 59us 225us 94us 159us 35us 80us
# Rows sent 67 3.54k 39 39 39 39 0 39
# Rows examine 54 17.80k 196 196 196 196 0 196
# Query size 30 44.87k 494 494 494 494 0 494
# String:
# Databases oliver
# Hosts localhost
# Time 2016-09-15... (1/1%), 2016-09-15... (1/1%)... 91 more
# Users root
# Query_time distribution
# 1us
# 10us
# 100us ################################################################
# 1ms #############
# 10ms
# 100ms
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `oliver` LIKE 'eav_attribute'\G
# SHOW CREATE TABLE `oliver`.`eav_attribute`\G
# SHOW TABLE STATUS FROM `oliver` LIKE 'eav_entity_type'\G
# SHOW CREATE TABLE `oliver`.`eav_entity_type`\G
# SHOW TABLE STATUS FROM `oliver` LIKE 'eav_entity_attribute'\G
# SHOW CREATE TABLE `oliver`.`eav_entity_attribute`\G
# SHOW TABLE STATUS FROM `oliver` LIKE 'catalog_eav_attribute'\G
# SHOW CREATE TABLE `oliver`.`catalog_eav_attribute`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT `main_table`.* FROM `eav_attribute` AS `main_table`
INNER JOIN `eav_entity_type` AS `entity_type` ON main_table.entity_type_id = entity_type.entity_type_id
INNER JOIN `eav_entity_attribute` ON main_table.attribute_id = eav_entity_attribute.attribute_id
INNER JOIN `catalog_eav_attribute` AS `additional_table` ON main_table.attribute_id = additional_table.attribute_id WHERE (`entity_type_code` = 'catalog_category') AND (`attribute_set_id` = '3') GROUP BY `main_table`.`attribute_id`\G
# Query 2: 0 QPS, 0x concurrency, ID 0x004EBA1FCB621686 at byte 73189 ____
# Scores: V/M = 0.00
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 21 93
# Exec time 22 42ms 317us 1ms 452us 881us 182us 366us
# Lock time 22 10ms 69us 402us 104us 236us 56us 84us
# Rows sent 1 93 1 1 1 1 0 1
# Rows examine 32 10.72k 118 118 118 118 0 118
# Query size 29 43.78k 482 482 482 482 0 482
# String:
# Databases oliver
# Hosts localhost
# Time 2016-09-15... (1/1%), 2016-09-15... (1/1%)... 91 more
# Users root
# Query_time distribution
# 1us
# 10us
# 100us ################################################################
# 1ms #
# 10ms
# 100ms
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `oliver` LIKE 'eav_attribute'\G
# SHOW CREATE TABLE `oliver`.`eav_attribute`\G
# SHOW TABLE STATUS FROM `oliver` LIKE 'eav_entity_type'\G
# SHOW CREATE TABLE `oliver`.`eav_entity_type`\G
# SHOW TABLE STATUS FROM `oliver` LIKE 'eav_entity_attribute'\G
# SHOW CREATE TABLE `oliver`.`eav_entity_attribute`\G
# SHOW TABLE STATUS FROM `oliver` LIKE 'catalog_eav_attribute'\G
# SHOW CREATE TABLE `oliver`.`catalog_eav_attribute`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT COUNT(DISTINCT main_table.attribute_id) FROM `eav_attribute` AS `main_table`
INNER JOIN `eav_entity_type` AS `entity_type` ON main_table.entity_type_id = entity_type.entity_type_id
INNER JOIN `eav_entity_attribute` ON main_table.attribute_id = eav_entity_attribute.attribute_id
INNER JOIN `catalog_eav_attribute` AS `additional_table` ON main_table.attribute_id = additional_table.attribute_id WHERE (`entity_type_code` = 'catalog_category') AND (`attribute_set_id` = '3')\G
# Query 3: 0 QPS, 0x concurrency, ID 0xF7A425D916EE085D at byte 36284 ____
# Scores: V/M = 0.00
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 21 94
# Exec time 11 21ms 121us 1ms 222us 384us 139us 176us
# Lock time 21 9ms 53us 516us 99us 185us 56us 84us
# Rows sent 1 94 1 1 1 1 0 1
# Rows examine 0 94 1 1 1 1 0 1
# Query size 8 12.15k 132 133 132.36 130.47 0 130.47
# String:
# Databases oliver
# Hosts localhost
# Time 2016-09-15... (1/1%), 2016-09-15... (1/1%)... 92 more
# Users root
# Query_time distribution
# 1us
# 10us
# 100us ################################################################
# 1ms #
# 10ms
# 100ms
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `oliver` LIKE 'catalog_category_flat_store_5'\G
# SHOW CREATE TABLE `oliver`.`catalog_category_flat_store_5`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT `catalog_category_flat_store_5`.* FROM `catalog_category_flat_store_5` WHERE (`catalog_category_flat_store_5`.`entity_id`=31)\G
# Query 4: 0 QPS, 0x concurrency, ID 0x2D8C823DE326C77D at byte 72642 ____
# Scores: V/M = 0.00
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 21 94
# Exec time 9 18ms 119us 795us 189us 316us 90us 152us
# Lock time 22 10ms 65us 496us 101us 176us 52us 84us
# Rows sent 0 0 0 0 0 0 0 0
# Rows examine 0 0 0 0 0 0 0 0
# Query size 21 31.85k 331 352 347 346.17 7.75 346.17
# String:
# Databases oliver
# Hosts localhost
# Time 2016-09-15... (1/1%), 2016-09-15... (1/1%)... 92 more
# Users root
# Query_time distribution
# 1us
# 10us
# 100us ################################################################
# 1ms
# 10ms
# 100ms
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `oliver` LIKE 'magento_catalogevent_event'\G
# SHOW CREATE TABLE `oliver`.`magento_catalogevent_event`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT `main_table`.*, CASE WHEN (date_start <= '2016-09-15 15:05:39' AND date_end >= '2016-09-15 15:05:39') THEN 'open' WHEN (date_start > '2016-09-15 15:05:39' AND date_end > '2016-09-15 15:05:39') THEN 'upcoming' ELSE 'closed' END AS `status` FROM `magento_catalogevent_event` AS `main_table` WHERE (`category_id` IN('1', '2', '19', '26', '48'))\G
# Query 5: 0 QPS, 0x concurrency, ID 0x35AAC71503957920 at byte 0 ________
# Scores: V/M = 0.00
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 1
# Exec time 3 6ms 6ms 6ms 6ms 6ms 0 6ms
# Lock time 0 0 0 0 0 0 0 0
# Rows sent 0 0 0 0 0 0 0 0
# Rows examine 0 0 0 0 0 0 0 0
# Query size 0 10 10 10 10 10 0 10
# String:
# Hosts localhost
# Time 2016-09-15T14:05:30.316147Z
# Users root
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms ################################################################
# 10ms
# 100ms
# 1s
# 10s+
flush logs\G
# Query 6: 0 QPS, 0x concurrency, ID 0xCE7E1A111C3749E9 at byte 233555 ___
# Scores: V/M = 0.00
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 1 6
# Exec time 2 4ms 460us 908us 627us 881us 157us 675us
# Lock time 2 1ms 108us 357us 170us 348us 86us 161us
# Rows sent 0 6 1 1 1 1 0 1
# Rows examine 1 624 104 104 104 104 0 104
# Query size 1 1.56k 261 273 266.67 271.23 6 258.32
# String:
# Databases oliver
# Hosts localhost
# Time 2016-09-15... (1/16%), 2016-09-15... (1/16%)... 4 more
# Users root
# Query_time distribution
# 1us
# 10us
# 100us ################################################################
# 1ms
# 10ms
# 100ms
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `oliver` LIKE 'cms_block'\G
# SHOW CREATE TABLE `oliver`.`cms_block`\G
# SHOW TABLE STATUS FROM `oliver` LIKE 'cms_block_store'\G
# SHOW CREATE TABLE `oliver`.`cms_block_store`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT `cms_block`.*, `cbs`.`store_id` FROM `cms_block`
INNER JOIN `cms_block_store` AS `cbs` ON cms_block.block_id = cbs.block_id WHERE (`cms_block`.`identifier`='header_delivery_messages') AND (is_active = 1) AND (cbs.store_id in (5, 0)) ORDER BY `store_id` DESC LIMIT 1\G
# Query 7: 0 QPS, 0x concurrency, ID 0x1D76FEEBD39E44BC at byte 5370 _____
# Scores: V/M = 0.00
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 1
# Exec time 1 3ms 3ms 3ms 3ms 3ms 0 3ms
# Lock time 1 807us 807us 807us 807us 807us 0 807us
# Rows sent 0 0 0 0 0 0 0 0
# Rows examine 0 46 46 46 46 46 0 46
# Query size 4 6.97k 6.97k 6.97k 6.97k 6.97k 0 6.97k
# String:
# Databases oliver
# Hosts localhost
# Time 2016-09-15T14:05:39.488677Z
# Users root
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms ################################################################
# 10ms
# 100ms
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `oliver` LIKE 'report_viewed_product_index'\G
# SHOW CREATE TABLE `oliver`.`report_viewed_product_index`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT 1 FROM `report_viewed_product_index` AS `item` WHERE (item.visitor_id = '33910') AND (item.store_id IN ('5')) AND (item.product_id IN (162,163,164,165,166,167,168,169,170,171,172,173,174,175,176,177,178,179,180,181/*... omitted 1316 items ...*/)) LIMIT 1\G
# Query 8: 0 QPS, 0x concurrency, ID 0x19BDF00FF30757C6 at byte 4975 _____
# Scores: V/M = 0.00
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 1
# Exec time 0 2ms 2ms 2ms 2ms 2ms 0 2ms
# Lock time 0 108us 108us 108us 108us 108us 0 108us
# Rows sent 25 1.30k 1.30k 1.30k 1.30k 1.30k 0 1.30k
# Rows examine 8 2.61k 2.61k 2.61k 2.61k 2.61k 0 2.61k
# Query size 0 191 191 191 191 191 0 191
# String:
# Databases oliver
# Hosts localhost
# Time 2016-09-15T14:05:39.485122Z
# Users root
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms ################################################################
# 10ms
# 100ms
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `oliver` LIKE 'catalog_product_entity'\G
# SHOW CREATE TABLE `oliver`.`catalog_product_entity`\G
# SHOW TABLE STATUS FROM `oliver` LIKE 'catalog_category_product'\G
# SHOW CREATE TABLE `oliver`.`catalog_category_product`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT `main`.`entity_id` FROM `catalog_product_entity` AS `main` WHERE (main.entity_id IN (SELECT `cat`.`product_id` FROM `catalog_category_product` AS `cat` WHERE (cat.category_id = '19')))\G
# Query 9: 0 QPS, 0x concurrency, ID 0x4FF9F7B35BE1338D at byte 15931 ____
# Scores: V/M = 0.00
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 1 5
# Exec time 0 1ms 205us 363us 249us 348us 53us 224us
# Lock time 1 489us 84us 114us 97us 113us 12us 98us
# Rows sent 0 0 0 0 0 0 0 0
# Rows examine 0 0 0 0 0 0 0 0
# Query size 0 485 97 97 97 97 0 97
# String:
# Databases oliver
# Hosts localhost
# Time 2016-09-15... (1/20%), 2016-09-15... (1/20%)... 3 more
# Users root
# Query_time distribution
# 1us
# 10us
# 100us ################################################################
# 1ms
# 10ms
# 100ms
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `oliver` LIKE 'url_rewrite'\G
# SHOW CREATE TABLE `oliver`.`url_rewrite`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT `url_rewrite`.* FROM `url_rewrite` WHERE (`target_path` IN ('')) AND (`store_id` IN ('4'))\G
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment