Skip to content

Instantly share code, notes, and snippets.

@uhlhosting

uhlhosting/mysql dump slow query log

Created March 22, 2016 20:28
Show Gist options
  • Save uhlhosting/74b8f1825e08d797e65d to your computer and use it in GitHub Desktop.
Save uhlhosting/74b8f1825e08d797e65d to your computer and use it in GitHub Desktop.
Download ZIP
Raw
mysql dump slow query log
root@panel [~]# pt-query-digest /var/log/mysql/slow.log
/var/log/mysql/slow.log: 33% 00:58 remain
/var/log/mysql/slow.log: 69% 00:26 remain
# 87.9s user time, 890ms system time, 49.85M rss, 247.98M vsz
# Current date: Tue Mar 22 21:26:14 2016
# Hostname: panel.uhlhosting.ch
# Files: /var/log/mysql/slow.log
# Overall: 492.91k total, 509 unique, 1.45 QPS, 0.00x concurrency ________
# Time range: 2016-03-11 15:55:44 to 2016-03-15 14:12:26
# Attribute total min max avg 95% stddev median
# ============ ======= ======= ======= ======= ======= ======= =======
# Exec time 960s 40us 8s 2ms 7ms 16ms 1ms
# Lock time 25s 0 72ms 51us 98us 124us 40us
# Rows sent 103.17M 0 204.97k 219.48 1.69k 894.14 0.99
# Rows examine 1.03G 0 585.03k 2.18k 5.20k 2.96k 2.76k
# Rows affecte 12.77k 0 2.22k 0.03 0 5.23 0
# Query size 93.60M 23 22.77k 199.11 420.77 475.93 92.72
# Profile
# Rank Query ID Response time Calls R/Call V/M Item
# ==== ================== ============== ====== ====== ===== =============
# 1 0x84D6804ACED57960 202.9982 21.1% 13006 0.0156 0.00 SELECT wp_icl_strings wp_icl_string_translations
# 2 0x9D121969B55A0EBB 174.8959 18.2% 137682 0.0013 0.00 SELECT wp_icl_strings
# 3 0x92F3B1B361FB0E5B 116.9274 12.2% 32078 0.0036 0.01 SELECT wp_options
# 4 0x94711EADD25A3CA0 96.8131 10.1% 3240 0.0299 0.00 SELECT wp_posts wp_term_relationships wp_term_taxonomy wp_terms
# 5 0x1E22FBAC45C4204E 72.6592 7.6% 4741 0.0153 0.00 SELECT wp_icl_translations wp_term_taxonomy wp_terms
# 6 0x0F45F1ABEDCB01CF 40.2124 4.2% 40641 0.0010 0.00 SELECT wp_icl_strings
# 7 0x2C1F4793A18B1030 37.7027 3.9% 5079 0.0074 0.00 SELECT wp_icl_strings wp_icl_string_translations
# 8 0xB23176DA0DB093CE 34.7691 3.6% 4744 0.0073 0.00 SELECT wp_icl_strings wp_icl_string_translations
# 9 0x7D18C5C503757896 34.7639 3.6% 10162 0.0034 0.01 SELECT wp_postmeta
# 10 0x67A347A2812914DF 28.6106 3.0% 2627 0.0109 4.02 SELECT wp_postmeta
# 11 0xC63F061B667EFDAB 16.3464 1.7% 12659 0.0013 0.00 SELECT wp_icl_strings
# 12 0xFDC11E967AFEE598 16.1931 1.7% 4777 0.0034 0.00 SELECT wp_icl_string_translations wp_icl_strings
# 13 0xF7A824A8F70D9779 11.0804 1.2% 48725 0.0002 0.00 SELECT tblpricing
# 14 0x3D0B861FEB41209B 8.7831 0.9% 5976 0.0015 0.00 SELECT wp_icl_translation_status
# 15 0x2EF2A0D5B170E10C 5.6891 0.6% 4777 0.0012 0.00 SELECT wp_icl_strings
# 16 0x51ED744BD0A25927 5.6032 0.6% 4777 0.0012 0.00 SELECT wp_icl_strings
# 17 0xA2ADFA30F4D4F23A 5.5270 0.6% 10248 0.0005 0.00 SELECT wp_woocommerce_tax_rates wp_woocommerce_tax_rate_locations
# 18 0x86D7B0EA390C7B81 5.4474 0.6% 4744 0.0011 0.00 SELECT wp_icl_strings
# MISC 0xMISC 44.8428 4.7% 142224 0.0003 0.0 <491 ITEMS>
# Query 1: 0.06 QPS, 0.00x concurrency, ID 0x84D6804ACED57960 at byte 21743706
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: 2016-03-11 15:56:07 to 2016-03-14 03:03:04
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 2 13006
# Exec time 21 203s 390us 75ms 16ms 21ms 7ms 16ms
# Lock time 4 1s 38us 72ms 80us 119us 625us 57us
# Rows sent 41 42.97M 264 3.55k 3.38k 3.52k 735.43 3.52k
# Rows examine 5 53.14M 264 5.55k 4.18k 5.45k 1.21k 3.69k
# Rows affecte 0 0 0 0 0 0 0 0
# Query size 3 3.34M 269 269 269 269 0 269
# String:
# Databases wp_highpas... (12338/94%)... 1 more
# Hosts localhost
# Users wp_highpas... (12338/94%)... 1 more
# Query_time distribution
# 1us
# 10us
# 100us ###
# 1ms #########
# 10ms ################################################################
# 100ms
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `uhlhosti_wp2` LIKE 'wp_icl_strings'\G
# SHOW CREATE TABLE `uhlhosti_wp2`.`wp_icl_strings`\G
# SHOW TABLE STATUS FROM `uhlhosti_wp2` LIKE 'wp_icl_string_translations'\G
# SHOW CREATE TABLE `uhlhosti_wp2`.`wp_icl_string_translations`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT
st.value AS tra,
s.value AS org,
s.domain_name_context_md5 AS ctx
FROM wp_icl_strings s
LEFT JOIN wp_icl_string_translations st
ON s.id=st.string_id
AND st.status=10
AND st.language='en'
AND s.language!='en'\G
# Query 2: 0.65 QPS, 0.00x concurrency, ID 0x9D121969B55A0EBB at byte 161132101
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: 2016-03-11 15:56:08 to 2016-03-14 03:03:04
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 27 137682
# Exec time 18 175s 969us 14ms 1ms 1ms 163us 1ms
# Lock time 25 7s 19us 341us 47us 98us 22us 38us
# Rows sent 0 129.73k 0 1 0.96 0.99 0.18 0.99
# Rows examine 45 477.55M 3.55k 3.55k 3.55k 3.55k 0 3.55k
# Rows affecte 0 0 0 0 0 0 0 0
# Query size 13 12.70M 90 102 96.69 92.72 0.81 92.72
# String:
# Databases wp_highpassion
# Hosts localhost
# Users wp_highpassion
# Query_time distribution
# 1us
# 10us
# 100us #
# 1ms ################################################################
# 10ms #
# 100ms
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `wp_highpassion` LIKE 'wp_icl_strings'\G
# SHOW CREATE TABLE `wp_highpassion`.`wp_icl_strings`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT language FROM wp_icl_strings WHERE context='WordPress' AND name='URL product_cat tax slug'\G
# Query 3: 0.15 QPS, 0.00x concurrency, ID 0x92F3B1B361FB0E5B at byte 96343
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.01
# Time range: 2016-03-11 15:55:49 to 2016-03-14 03:06:38
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 6 32078
# Exec time 12 117s 176us 147ms 4ms 11ms 5ms 2ms
# Lock time 9 2s 24us 8ms 75us 98us 85us 73us
# Rows sent 15 16.32M 86 848 533.31 833.10 268.19 652.75
# Rows examine 7 80.29M 90 12.08k 2.56k 7.68k 3.29k 964.41
# Rows affecte 0 0 0 0 0 0 0 0
# Query size 2 2.17M 71 71 71 71 0 71
# String:
# Databases tabaklae_w... (8803/27%)... 11 more
# Hosts localhost
# Users tabaklae_w... (8803/27%)... 11 more
# Query_time distribution
# 1us
# 10us
# 100us ##############
# 1ms ################################################################
# 10ms ######
# 100ms #
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `tabaklae_wp1` LIKE 'wp_options'\G
# SHOW CREATE TABLE `tabaklae_wp1`.`wp_options`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes'\G
# Query 4: 0.02 QPS, 0.00x concurrency, ID 0x94711EADD25A3CA0 at byte 1479676
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: 2016-03-11 15:55:44 to 2016-03-14 03:06:01
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 3240
# Exec time 10 97s 23ms 76ms 30ms 31ms 3ms 28ms
# Lock time 4 1s 298us 964us 371us 445us 56us 348us
# Rows sent 9 9.63M 3.03k 3.15k 3.04k 3.04k 50.45 2.89k
# Rows examine 5 56.94M 17.91k 18.62k 18.00k 18.47k 276.41 17.59k
# Rows affecte 0 0 0 0 0 0 0 0
# Query size 18 17.20M 5.42k 5.53k 5.44k 5.45k 53.50 5.20k
# String:
# Databases tabaklae_wp1
# Hosts localhost
# Users tabaklae_wp1
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms ################################################################
# 100ms
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `tabaklae_wp1` LIKE 'wp_posts'\G
# SHOW CREATE TABLE `tabaklae_wp1`.`wp_posts`\G
# SHOW TABLE STATUS FROM `tabaklae_wp1` LIKE 'wp_term_relationships'\G
# SHOW CREATE TABLE `tabaklae_wp1`.`wp_term_relationships`\G
# SHOW TABLE STATUS FROM `tabaklae_wp1` LIKE 'wp_term_taxonomy'\G
# SHOW CREATE TABLE `tabaklae_wp1`.`wp_term_taxonomy`\G
# SHOW TABLE STATUS FROM `tabaklae_wp1` LIKE 'wp_terms'\G
# SHOW CREATE TABLE `tabaklae_wp1`.`wp_terms`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT slug, taxonomy FROM wp_posts
INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id)
INNER JOIN wp_term_taxonomy ON (wp_term_relationships.term_taxonomy_id = wp_term_taxonomy.term_taxonomy_id )
INNER JOIN wp_terms ON (wp_term_taxonomy.term_id = wp_terms.term_id )
WHERE wp_posts.ID IN ("3515","3510","3504","3500","3495","3492","3488","3483","3480","3476","3471","3465","3461","3455","3449","3443","3437","3431","3425","3419"/*... omitted 783 items ...*/)
ORDER BY wp_terms.name ASC\G
# Query 5: 0.02 QPS, 0.00x concurrency, ID 0x1E22FBAC45C4204E at byte 60200711
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: 2016-03-11 15:56:08 to 2016-03-14 03:03:05
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 4741
# Exec time 7 73s 239us 38ms 15ms 17ms 5ms 16ms
# Lock time 1 318ms 44us 5ms 67us 89us 86us 60us
# Rows sent 9 9.97M 19 2.40k 2.15k 2.38k 734.24 2.38k
# Rows examine 4 42.31M 82 10.17k 9.14k 9.80k 2.94k 9.80k
# Rows affecte 0 0 0 0 0 0 0 0
# Query size 1 1.60M 353 353 353 353 0 353
# String:
# Databases wp_highpas... (4254/89%)... 1 more
# Hosts localhost
# Users wp_highpas... (4254/89%)... 1 more
# Query_time distribution
# 1us
# 10us
# 100us #######
# 1ms #
# 10ms ################################################################
# 100ms
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `wp_highpassion` LIKE 'wp_icl_translations'\G
# SHOW CREATE TABLE `wp_highpassion`.`wp_icl_translations`\G
# SHOW TABLE STATUS FROM `wp_highpassion` LIKE 'wp_term_taxonomy'\G
# SHOW CREATE TABLE `wp_highpassion`.`wp_term_taxonomy`\G
# SHOW TABLE STATUS FROM `wp_highpassion` LIKE 'wp_terms'\G
# SHOW CREATE TABLE `wp_highpassion`.`wp_terms`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT t.element_id, tax.term_id, tax.taxonomy
FROM wp_icl_translations t
JOIN wp_term_taxonomy tax
ON t.element_id = tax.term_taxonomy_id
AND t.element_type = CONCAT('tax_', tax.taxonomy)
JOIN wp_terms terms
ON terms.term_id = tax.term_id
WHERE tax.term_id != tax.term_taxonomy_id\G
# Query 6: 0.19 QPS, 0.00x concurrency, ID 0x0F45F1ABEDCB01CF at byte 1905455
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: 2016-03-11 15:56:07 to 2016-03-14 03:03:04
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 8 40641
# Exec time 4 40s 774us 3ms 989us 1ms 133us 925us
# Lock time 7 2s 25us 242us 44us 69us 13us 40us
# Rows sent 0 39.69k 1 1 1 1 0 1
# Rows examine 10 110.83M 2.79k 3.55k 2.79k 2.76k 3.87 2.76k
# Rows affecte 0 0 0 0 0 0 0 0
# Query size 5 4.99M 121 139 128.75 136.99 5.99 124.25
# String:
# Databases wp_highpassion
# Hosts localhost
# Users wp_highpassion
# Query_time distribution
# 1us
# 10us
# 100us ################################################################
# 1ms ###############################################
# 10ms
# 100ms
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `wp_highpassion` LIKE 'wp_icl_strings'\G
# SHOW CREATE TABLE `wp_highpassion`.`wp_icl_strings`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT id FROM wp_icl_strings WHERE value='order-pay' AND context='WooCommerce Endpoints' AND name = 'order-pay' LIMIT 1\G
# Query 7: 0.02 QPS, 0.00x concurrency, ID 0x2C1F4793A18B1030 at byte 143341326
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: 2016-03-11 15:56:08 to 2016-03-14 03:03:04
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 1 5079
# Exec time 3 38s 6ms 30ms 7ms 8ms 1ms 7ms
# Lock time 1 360ms 46us 270us 70us 108us 16us 63us
# Rows sent 0 0 0 0 0 0 0 0
# Rows examine 2 25.93M 5.23k 5.23k 5.23k 5.23k 0 5.23k
# Rows affecte 0 0 0 0 0 0 0 0
# Query size 1 1.12M 231 231 231 231 0 231
# String:
# Databases wp_highpassion
# Hosts localhost
# Users wp_highpassion
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms ################################################################
# 10ms #
# 100ms
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `wp_highpassion` LIKE 'wp_icl_strings'\G
# SHOW CREATE TABLE `wp_highpassion`.`wp_icl_strings`\G
# SHOW TABLE STATUS FROM `wp_highpassion` LIKE 'wp_icl_string_translations'\G
# SHOW CREATE TABLE `wp_highpassion`.`wp_icl_string_translations`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT t.value, s.name
FROM wp_icl_strings s
JOIN wp_icl_string_translations t ON t.string_id = s.id
WHERE s.name IN ('URL slug: product')
AND t.status = 10
AND t.value <> ''\G
# Query 8: 0.02 QPS, 0.00x concurrency, ID 0xB23176DA0DB093CE at byte 156908094
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: 2016-03-11 15:56:08 to 2016-03-14 03:03:04
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 4744
# Exec time 3 35s 6ms 20ms 7ms 8ms 833us 7ms
# Lock time 0 229ms 38us 167us 48us 60us 8us 44us
# Rows sent 0 0 0 0 0 0 0 0
# Rows examine 2 24.22M 5.23k 5.23k 5.23k 5.23k 0 5.23k
# Rows affecte 0 0 0 0 0 0 0 0
# Query size 1 1.37M 302 302 302 302 0 302
# String:
# Databases wp_highpassion
# Hosts localhost
# Users wp_highpassion
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms ################################################################
# 10ms #
# 100ms
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `wp_highpassion` LIKE 'wp_icl_strings'\G
# SHOW CREATE TABLE `wp_highpassion`.`wp_icl_strings`\G
# SHOW TABLE STATUS FROM `wp_highpassion` LIKE 'wp_icl_string_translations'\G
# SHOW CREATE TABLE `wp_highpassion`.`wp_icl_string_translations`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT t.value, t.language
FROM wp_icl_strings s
JOIN wp_icl_string_translations t ON t.string_id = s.id
WHERE s.name = 'URL slug: product'
AND (s.context = 'default' OR s.context = 'WordPress')
AND t.status = 10
AND t.value <> ''\G
# Query 9: 0.05 QPS, 0.00x concurrency, ID 0x7D18C5C503757896 at byte 7391574
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.01
# Time range: 2016-03-11 15:56:21 to 2016-03-14 02:54:30
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 2 10162
# Exec time 3 35s 115us 136ms 3ms 4ms 6ms 2ms
# Lock time 2 578ms 27us 2ms 56us 89us 31us 49us
# Rows sent 10 10.72M 5 9.91k 1.08k 1.04k 1.51k 719.66
# Rows examine 3 40.15M 11 23.74k 4.05k 4.07k 3.12k 3.52k
# Rows affecte 0 0 0 0 0 0 0 0
# Query size 3 3.00M 95 2.00k 309.17 363.48 283.64 223.14
# String:
# Databases srisolie_w... (9233/90%)... 7 more
# Hosts localhost
# Users srisolie_w... (9233/90%)... 7 more
# Query_time distribution
# 1us
# 10us
# 100us ##
# 1ms ################################################################
# 10ms ##
# 100ms #
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `chuhlser_wp1` LIKE 'wp_postmeta'\G
# SHOW CREATE TABLE `chuhlser_wp1`.`wp_postmeta`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (6152,6132,6144,6146,6149,6151,6154,6156,6158,6160,6165,6166,6179,6180,6182,6183,5926,5887,6184,6185/*... omitted 370 items ...*/) ORDER BY meta_id ASC\G
# Query 10: 0.01 QPS, 0.00x concurrency, ID 0x67A347A2812914DF at byte 216445833
# This item is included in the report because it matches --limit.
# Scores: V/M = 4.02
# Time range: 2016-03-11 16:17:25 to 2016-03-15 14:12:26
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 2627
# Exec time 2 29s 47us 8s 11ms 17ms 209ms 76us
# Lock time 0 937us 0 35us 0 0 2us 0
# Rows sent 2 2.81M 0 204.97k 1.09k 4.27k 7.05k 4.96
# Rows examine 0 2.81M 0 204.97k 1.09k 4.27k 7.05k 5.75
# Rows affecte 0 0 0 0 0 0 0 0
# Query size 0 155.10k 43 90 60.46 80.10 9.48 56.92
# String:
# Databases tabaklae_w... (276/10%), highacid_w... (258/9%)... 20 more
# Hosts localhost
# Users root (2591/98%), wp_highpas... (36/1%)
# Query_time distribution
# 1us
# 10us ################################################################
# 100us ####################
# 1ms ###############
# 10ms ######
# 100ms #
# 1s #
# 10s+
# Tables
# SHOW TABLE STATUS FROM `wp_highpassion` LIKE 'wp_postmeta'\G
# SHOW CREATE TABLE `wp_highpassion`.`wp_postmeta`\G
SELECT /*!40001 SQL_NO_CACHE */ * FROM `wp_postmeta`\G
# Converted for EXPLAIN
# EXPLAIN /*!50100 PARTITIONS*/
SELECT /*!40001 SQL_NO_CACHE */ * FROM `wp_postmeta`\G
# Query 11: 0.06 QPS, 0.00x concurrency, ID 0xC63F061B667EFDAB at byte 51857467
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: 2016-03-11 15:56:08 to 2016-03-14 03:03:05
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 2 12659
# Exec time 1 16s 197us 5ms 1ms 2ms 247us 1ms
# Lock time 2 512ms 25us 191us 40us 63us 12us 36us
# Rows sent 7 7.92M 0 1.69k 655.80 1.69k 838.71 2.90
# Rows examine 4 43.63M 264 3.55k 3.53k 3.52k 276.90 3.52k
# Rows affecte 0 0 0 0 0 0 0 0
# Query size 0 932.58k 64 101 75.44 97.36 14.95 65.89
# String:
# Databases wp_highpas... (12571/99%)... 1 more
# Hosts localhost
# Users wp_highpas... (12571/99%)... 1 more
# Query_time distribution
# 1us
# 10us
# 100us ###
# 1ms ################################################################
# 10ms
# 100ms
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `wp_highpassion` LIKE 'wp_icl_strings'\G
# SHOW CREATE TABLE `wp_highpassion`.`wp_icl_strings`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT value, name FROM wp_icl_strings WHERE context = 'Widgets'\G
# Query 12: 0.02 QPS, 0.00x concurrency, ID 0xFDC11E967AFEE598 at byte 171072075
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: 2016-03-11 15:56:08 to 2016-03-14 03:03:04
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 4777
# Exec time 1 16s 709us 15ms 3ms 7ms 2ms 2ms
# Lock time 0 243ms 38us 153us 50us 63us 8us 47us
# Rows sent 0 0 0 0 0 0 0 0
# Rows examine 1 16.43M 2.63k 4.61k 3.52k 4.49k 841.73 2.89k
# Rows affecte 0 0 0 0 0 0 0 0
# Query size 0 867.70k 186 186 186 186 0 186
# String:
# Databases wp_highpassion
# Hosts localhost
# Users wp_highpassion
# Query_time distribution
# 1us
# 10us
# 100us ##############
# 1ms ################################################################
# 10ms #
# 100ms
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `wp_highpassion` LIKE 'wp_icl_string_translations'\G
# SHOW CREATE TABLE `wp_highpassion`.`wp_icl_string_translations`\G
# SHOW TABLE STATUS FROM `wp_highpassion` LIKE 'wp_icl_strings'\G
# SHOW CREATE TABLE `wp_highpassion`.`wp_icl_strings`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT t.value
FROM wp_icl_string_translations t
JOIN wp_icl_strings s ON t.string_id = s.id
WHERE t.language = 'de' AND s.name = 'URL slug: product' AND t.status = 10\G
# Query 13: 0.30 QPS, 0.00x concurrency, ID 0xF7A824A8F70D9779 at byte 23334278
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: 2016-03-11 23:50:06 to 2016-03-13 20:27:19
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 9 48725
# Exec time 1 11s 156us 5ms 227us 301us 45us 204us
# Lock time 5 1s 21us 4ms 29us 49us 20us 25us
# Rows sent 0 2.06k 0 1 0.04 0 0.20 0
# Rows examine 0 8.43M 122 250 181.32 246.02 19.69 174.84
# Rows affecte 0 0 0 0 0 0 0 0
# Query size 5 5.19M 105 112 111.66 107.34 0.05 107.34
# String:
# Databases uhlhosti_whmc5
# Hosts localhost
# Users uhlhosti_whmc5
# Query_time distribution
# 1us
# 10us
# 100us ################################################################
# 1ms #
# 10ms
# 100ms
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `uhlhosti_whmc5` LIKE 'tblpricing'\G
# SHOW CREATE TABLE `uhlhosti_whmc5`.`tblpricing`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT * FROM tblpricing WHERE `type`='domainregister' AND `currency`='1' AND `relid`='768' AND `tsetupfee`='0'\G
# Query 14: 0.03 QPS, 0.00x concurrency, ID 0x3D0B861FEB41209B at byte 21743083
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: 2016-03-11 15:56:07 to 2016-03-14 03:03:03
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 1 5976
# Exec time 0 9s 78us 23ms 1ms 2ms 639us 2ms
# Lock time 1 311ms 25us 23ms 51us 69us 286us 44us
# Rows sent 0 5.84k 1 1 1 1 0 1
# Rows examine 0 3.92M 6 795 687.53 793.42 270.18 793.42
# Rows affecte 0 0 0 0 0 0 0 0
# Query size 0 601.10k 103 103 103 103 0 103
# String:
# Databases wp_highpas... (5162/86%)... 1 more
# Hosts localhost
# Users wp_highpas... (5162/86%)... 1 more
# Query_time distribution
# 1us
# 10us ##
# 100us ########
# 1ms ################################################################
# 10ms #
# 100ms
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `uhlhosti_wp2` LIKE 'wp_icl_translation_status'\G
# SHOW CREATE TABLE `uhlhosti_wp2`.`wp_icl_translation_status`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT COUNT(*)
FROM wp_icl_translation_status
WHERE translation_service = 'icanlocalize'\G
# Query 15: 0.02 QPS, 0.00x concurrency, ID 0x2EF2A0D5B170E10C at byte 90051996
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: 2016-03-11 15:56:08 to 2016-03-14 03:03:04
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 4777
# Exec time 0 6s 952us 4ms 1ms 1ms 124us 1ms
# Lock time 0 229ms 31us 154us 47us 69us 11us 44us
# Rows sent 0 14.00k 3 3 3 3 0 3
# Rows examine 1 16.57M 3.55k 3.55k 3.55k 3.55k 0 3.55k
# Rows affecte 0 0 0 0 0 0 0 0
# Query size 0 433.85k 93 93 93 93 0 93
# String:
# Databases wp_highpassion
# Hosts localhost
# Users wp_highpassion
# Query_time distribution
# 1us
# 10us
# 100us #
# 1ms ################################################################
# 10ms
# 100ms
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `wp_highpassion` LIKE 'wp_icl_strings'\G
# SHOW CREATE TABLE `wp_highpassion`.`wp_icl_strings`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT value
FROM wp_icl_strings
WHERE name = 'URL slug: product'\G
# Query 16: 0.02 QPS, 0.00x concurrency, ID 0x51ED744BD0A25927 at byte 72169201
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: 2016-03-11 15:56:08 to 2016-03-14 03:03:04
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 4777
# Exec time 0 6s 946us 2ms 1ms 1ms 127us 1ms
# Lock time 0 170ms 26us 136us 35us 47us 8us 31us
# Rows sent 0 2.68k 0 3 0.58 2.90 1.14 0
# Rows examine 1 16.57M 3.55k 3.55k 3.55k 3.55k 0 3.55k
# Rows affecte 0 0 0 0 0 0 0 0
# Query size 0 452.51k 97 97 97 97 0 97
# String:
# Databases wp_highpassion
# Hosts localhost
# Users wp_highpassion
# Query_time distribution
# 1us
# 10us
# 100us ###
# 1ms ################################################################
# 10ms
# 100ms
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `wp_highpassion` LIKE 'wp_icl_strings'\G
# SHOW CREATE TABLE `wp_highpassion`.`wp_icl_strings`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT value
FROM wp_icl_strings
WHERE language = 'en' AND name = 'URL slug: product'\G
# Query 17: 0.05 QPS, 0.00x concurrency, ID 0xA2ADFA30F4D4F23A at byte 97417
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: 2016-03-11 15:55:49 to 2016-03-14 03:06:01
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 2 10248
# Exec time 0 6s 312us 10ms 539us 657us 243us 515us
# Lock time 4 1s 74us 6ms 110us 131us 123us 98us
# Rows sent 0 10.01k 1 1 1 1 0 1
# Rows examine 0 30.02k 3 3 3 3 0 3
# Rows affecte 0 0 0 0 0 0 0 0
# Query size 12 12.06M 1.21k 1.26k 1.21k 1.20k 0 1.20k
# String:
# Databases srisolie_w... (5883/57%)... 1 more
# Hosts localhost
# Users srisolie_w... (5883/57%)... 1 more
# Query_time distribution
# 1us
# 10us
# 100us ################################################################
# 1ms #
# 10ms #
# 100ms
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `tabaklae_wp1` LIKE 'wp_woocommerce_tax_rates'\G
# SHOW CREATE TABLE `tabaklae_wp1`.`wp_woocommerce_tax_rates`\G
# SHOW TABLE STATUS FROM `tabaklae_wp1` LIKE 'wp_woocommerce_tax_rate_locations'\G
# SHOW CREATE TABLE `tabaklae_wp1`.`wp_woocommerce_tax_rate_locations`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT tax_rates.*
FROM wp_woocommerce_tax_rates as tax_rates
LEFT OUTER JOIN wp_woocommerce_tax_rate_locations as locations ON tax_rates.tax_rate_id = locations.tax_rate_id
LEFT OUTER JOIN wp_woocommerce_tax_rate_locations as locations2 ON tax_rates.tax_rate_id = locations2.tax_rate_id
WHERE tax_rate_country IN ( 'CH', '' )
AND tax_rate_state IN ( '', '' )
AND tax_rate_class = ''
AND (
locations.location_type IS NULL
OR (
locations.location_type = 'postcode'
AND locations.location_code IN ('*','','*')
AND (
locations2.location_type = 'city' AND locations2.location_code = ''
OR 0 = (
SELECT COUNT(*) FROM wp_woocommerce_tax_rate_locations as sublocations
WHERE sublocations.location_type = 'city'
AND sublocations.tax_rate_id = tax_rates.tax_rate_id
)
)
)
OR (
locations.location_type = 'city'
AND locations.location_code = ''
AND 0 = (
SELECT COUNT(*) FROM wp_woocommerce_tax_rate_locations as sublocations
WHERE sublocations.location_type = 'postcode'
AND sublocations.tax_rate_id = tax_rates.tax_rate_id
)
)
)
GROUP BY tax_rate_id
ORDER BY tax_rate_priority, tax_rate_order\G
# Query 18: 0.02 QPS, 0.00x concurrency, ID 0x86D7B0EA390C7B81 at byte 90862203
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: 2016-03-11 15:56:08 to 2016-03-14 03:03:04
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 4744
# Exec time 0 5s 954us 2ms 1ms 1ms 122us 1ms
# Lock time 0 191ms 30us 186us 40us 49us 8us 36us
# Rows sent 0 4.63k 1 1 1 1 0 1
# Rows examine 1 16.45M 3.55k 3.55k 3.55k 3.55k 0 3.55k
# Rows affecte 0 0 0 0 0 0 0 0
# Query size 0 810.74k 175 175 175 175 0 175
# String:
# Databases wp_highpassion
# Hosts localhost
# Users wp_highpassion
# Query_time distribution
# 1us
# 10us
# 100us ###
# 1ms ################################################################
# 10ms
# 100ms
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `wp_highpassion` LIKE 'wp_icl_strings'\G
# SHOW CREATE TABLE `wp_highpassion`.`wp_icl_strings`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT s.value, s.language
FROM wp_icl_strings s
WHERE s.name = 'URL slug: product'
AND (s.context = 'default' OR s.context = 'WordPress')\G
root@panel [~]#
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment