Skip to content

Instantly share code, notes, and snippets.

@uhlhosting

uhlhosting/Slow-query-analyzed

Created March 4, 2016 11:18
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save uhlhosting/7cf31c0d873fe53ed77a to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save uhlhosting/7cf31c0d873fe53ed77a to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Slow-query-analyzed
root@panel [~]# pt-query-digest /var/log/mariadb/slow_query.log
/var/log/mariadb/slow_query.log: 17% 02:19 remain
/var/log/mariadb/slow_query.log: 36% 01:42 remain
/var/log/mariadb/slow_query.log: 55% 01:12 remain
/var/log/mariadb/slow_query.log: 74% 00:40 remain
/var/log/mariadb/slow_query.log: 92% 00:11 remain
# 162.4s user time, 1s system time, 93.74M rss, 291.91M vsz
# Current date: Fri Mar 4 12:17:24 2016
# Hostname: panel.uhlhosting.ch
# Files: /var/log/mariadb/slow_query.log
# Overall: 834.33k total, 1.37k unique, 0.28 QPS, 0.00x concurrency ______
# Time range: 2016-01-30 03:38:32 to 2016-03-04 12:15:25
# Attribute total min max avg 95% stddev median
# ============ ======= ======= ======= ======= ======= ======= =======
# Exec time 7371s 30us 5s 9ms 20ms 52ms 761us
# Lock time 45s 0 251ms 53us 98us 418us 40us
# Rows sent 282.16M 0 518.29k 354.62 2.38k 2.82k 0.99
# Rows examine 9.98G 0 518.36k 12.54k 14.47k 68.87k 487.09
# Rows affecte 59.19k 0 5.72k 0.07 0 8.26 0
# Query size 220.36M 11 54.59k 276.94 537.02 591.28 124.25
# Profile
# Rank Query ID Response time Calls R/Call V/M Item
# ==== ================== =============== ====== ====== ===== ============
# 1 0x92F3B1B361FB0E5B 5463.1718 74.1% 100388 0.0544 0.29 SELECT wp_options
# 2 0x84D6804ACED57960 474.6630 6.4% 30735 0.0154 0.00 SELECT wp_icl_strings wp_icl_string_translations
# 3 0x94711EADD25A3CA0 262.7480 3.6% 10646 0.0247 0.00 SELECT wp_posts wp_term_relationships wp_term_taxonomy wp_terms
# 4 0xBCC450DA508E00F7 201.0988 2.7% 9894 0.0203 0.01 SELECT tables
# 5 0x1E22FBAC45C4204E 159.8582 2.2% 9712 0.0165 0.00 SELECT wp_icl_translations wp_term_taxonomy wp_terms
# 6 0x67A347A2812914DF 122.7381 1.7% 12850 0.0096 2.68 SELECT wp_options
# 7 0x2C1F4793A18B1030 82.3864 1.1% 10473 0.0079 0.00 SELECT wp_icl_strings wp_icl_string_translations
# 8 0xB23176DA0DB093CE 79.3583 1.1% 9988 0.0079 0.00 SELECT wp_icl_strings wp_icl_string_translations
# 9 0x7D18C5C503757896 72.6790 1.0% 23133 0.0031 0.05 SELECT wp_postmeta
# 10 0x0F45F1ABEDCB01CF 69.1207 0.9% 84030 0.0008 0.00 SELECT wp_icl_strings
# 11 0x9D121969B55A0EBB 46.6701 0.6% 42495 0.0011 0.00 SELECT wp_icl_strings
# 14 0x04248D594D4723A6 21.0486 0.3% 21 1.0023 0.77 SELECT information_schema.TABLES
# 34 0xAE017F4188882B31 2.6939 0.0% 10 0.2694 0.88 SELECT information_schema.TABLES
# MISC 0xMISC 313.0623 4.2% 489952 0.0006 0.0 <1356 ITEMS>
# Query 1: 0.03 QPS, 0.00x concurrency, ID 0x92F3B1B361FB0E5B at byte 408871644
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.29
# Time range: 2016-01-30 03:38:33 to 2016-03-04 12:11:34
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 12 100388
# Exec time 74 5463s 232us 4s 54ms 279ms 126ms 7ms
# Lock time 16 7s 23us 222ms 73us 84us 849us 63us
# Rows sent 20 57.67M 104 857 602.38 833.10 157.79 563.87
# Rows examine 87 8.72G 108 518.36k 91.12k 509.78k 180.46k 11.34k
# Rows affecte 0 0 0 0 0 0 0 0
# Query size 3 6.80M 71 71 71 71 0 71
# String:
# Databases tabaklae_w... (31011/30%)... 12 more
# Hosts localhost
# Users tabaklae_w... (31011/30%)... 12 more
# Query_time distribution
# 1us
# 10us
# 100us ###
# 1ms ################################################################
# 10ms ################
# 100ms ################
# 1s #
# 10s+
# Tables
# SHOW TABLE STATUS FROM `srisolie_wp1` LIKE 'wp_options'\G
# SHOW CREATE TABLE `srisolie_wp1`.`wp_options`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes'\G
# Query 2: 0.01 QPS, 0.00x concurrency, ID 0x84D6804ACED57960 at byte 34726806
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: 2016-01-30 03:39:02 to 2016-02-26 01:19:23
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 3 30735
# Exec time 6 475s 405us 124ms 15ms 22ms 7ms 16ms
# Lock time 4 2s 33us 9ms 67us 98us 111us 60us
# Rows sent 36 102.96M 264 3.55k 3.43k 3.52k 618.16 3.52k
# Rows examine 1 125.98M 264 5.55k 4.20k 5.45k 1.11k 3.69k
# Rows affecte 0 0 0 0 0 0 0 0
# Query size 3 7.88M 269 269 269 269 0 269
# String:
# Databases wp_highpas... (29645/96%)... 1 more
# Hosts localhost
# Users wp_highpas... (29645/96%)... 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
# 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
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='de'
AND s.language!='de'\G
# Query 3: 0.00 QPS, 0.00x concurrency, ID 0x94711EADD25A3CA0 at byte 62052410
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: 2016-01-30 03:43:44 to 2016-03-04 10:54:43
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 1 10646
# Exec time 3 263s 19ms 56ms 25ms 26ms 2ms 24ms
# Lock time 7 3s 255us 816us 306us 332us 30us 287us
# Rows sent 9 25.77M 2.35k 2.54k 2.48k 2.38k 16.09 2.38k
# Rows examine 1 153.11M 14.18k 15.21k 14.73k 14.47k 29.51 14.47k
# Rows affecte 0 0 0 0 0 0 0 0
# Query size 22 50.66M 4.32k 4.97k 4.87k 4.71k 28.49 4.71k
# 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 ("3015","3010","3006","3002","2998","2994","2990","2986","2982","2978","2974","2970","2966","2962","2958","2954","2950","2945","2934","2921"/*... omitted 704 items ...*/)
ORDER BY wp_terms.name ASC\G
# Query 4: 0.00 QPS, 0.00x concurrency, ID 0xBCC450DA508E00F7 at byte 316287314
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.01
# Time range: 2016-01-30 03:40:04 to 2016-03-04 12:15:04
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 1 9894
# Exec time 2 201s 10ms 1s 20ms 26ms 12ms 19ms
# Lock time 1 720ms 42us 381us 72us 84us 11us 69us
# Rows sent 0 9.66k 1 1 1 1 0 1
# Rows examine 0 388.51k 40 47 40.21 38.53 1.41 38.53
# Rows affecte 0 0 0 0 0 0 0 0
# Query size 0 618.38k 64 64 64 64 0 64
# String:
# Databases information_schema
# Hosts localhost
# Users root
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms ################################################################
# 100ms #
# 1s #
# 10s+
# Tables
# SHOW TABLE STATUS FROM `information_schema` LIKE 'tables'\G
# SHOW CREATE TABLE `information_schema`.`tables`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT table_comment FROM tables WHERE ENGINE = 'InnoDB' LIMIT 1\G
# Query 5: 0.00 QPS, 0.00x concurrency, ID 0x1E22FBAC45C4204E at byte 170457920
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: 2016-01-30 03:39:03 to 2016-02-26 01:19:25
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 1 9712
# Exec time 2 160s 242us 38ms 16ms 17ms 4ms 16ms
# Lock time 1 600ms 40us 5ms 61us 84us 95us 54us
# Rows sent 7 21.45M 19 2.40k 2.26k 2.38k 560.43 2.38k
# Rows examine 0 91.02M 82 10.17k 9.60k 9.80k 2.25k 9.80k
# Rows affecte 0 0 0 0 0 0 0 0
# Query size 1 3.27M 353 353 353 353 0 353
# String:
# Databases wp_highpas... (9159/94%)... 1 more
# Hosts localhost
# Users wp_highpas... (9159/94%)... 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.00 QPS, 0.00x concurrency, ID 0x67A347A2812914DF at byte 357254195
# This item is included in the report because it matches --limit.
# Scores: V/M = 2.68
# Time range: 2016-01-30 08:00:11 to 2016-03-03 02:02:01
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 1 12850
# Exec time 1 123s 40us 5s 10ms 9ms 160ms 66us
# Lock time 0 0 0 0 0 0 0 0
# Rows sent 8 22.82M 0 518.29k 1.82k 2.89k 21.78k 3.89
# Rows examine 0 22.82M 0 518.29k 1.82k 2.89k 21.78k 3.89
# Rows affecte 0 0 0 0 0 0 0 0
# Query size 0 741.09k 46 90 59.06 72.65 7.59 56.92
# String:
# Databases uhlhosti_w... (2540/19%)... 20 more
# Hosts localhost
# Users root
# Query_time distribution
# 1us
# 10us ################################################################
# 100us ###################
# 1ms ########
# 10ms ###
# 100ms #
# 1s #
# 10s+
# Tables
# SHOW TABLE STATUS FROM `srisolie_wp1` LIKE 'wp_options'\G
# SHOW CREATE TABLE `srisolie_wp1`.`wp_options`\G
SELECT /*!40001 SQL_NO_CACHE */ * FROM `wp_options`\G
# Converted for EXPLAIN
# EXPLAIN /*!50100 PARTITIONS*/
SELECT /*!40001 SQL_NO_CACHE */ * FROM `wp_options`\G
# Query 7: 0.00 QPS, 0.00x concurrency, ID 0x2C1F4793A18B1030 at byte 193600661
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: 2016-01-30 03:39:03 to 2016-02-26 00:55:39
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 1 10473
# Exec time 1 82s 7ms 20ms 8ms 8ms 928us 8ms
# Lock time 1 552ms 35us 222us 52us 89us 15us 44us
# Rows sent 0 0 0 0 0 0 0 0
# Rows examine 0 53.46M 5.23k 5.23k 5.23k 5.23k 0 5.23k
# Rows affecte 0 0 0 0 0 0 0 0
# Query size 1 2.31M 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.00 QPS, 0.00x concurrency, ID 0xB23176DA0DB093CE at byte 170457046
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: 2016-01-30 03:39:03 to 2016-02-26 00:55:39
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 1 9988
# Exec time 1 79s 7ms 20ms 8ms 8ms 1ms 8ms
# Lock time 0 396ms 34us 182us 39us 49us 6us 36us
# Rows sent 0 0 0 0 0 0 0 0
# Rows examine 0 50.99M 5.23k 5.23k 5.23k 5.23k 0 5.23k
# Rows affecte 0 0 0 0 0 0 0 0
# Query size 1 2.88M 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.01 QPS, 0.00x concurrency, ID 0x7D18C5C503757896 at byte 259659846
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.05
# Time range: 2016-01-30 03:38:41 to 2016-03-04 10:42:52
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 2 23133
# Exec time 0 73s 101us 2s 3ms 3ms 13ms 3ms
# Lock time 2 1s 24us 378us 47us 76us 24us 38us
# Rows sent 8 22.62M 3 22.87k 1.00k 1.04k 1.10k 719.66
# Rows examine 0 87.73M 6 39.69k 3.88k 3.69k 2.33k 3.69k
# Rows affecte 0 0 0 0 0 0 0 0
# Query size 3 6.85M 95 3.21k 310.64 329.68 263.81 223.14
# String:
# Databases srisolie_w... (21397/92%)... 6 more
# Hosts localhost
# Users srisolie_w... (21397/92%)... 6 more
# Query_time distribution
# 1us
# 10us
# 100us ###
# 1ms ################################################################
# 10ms #
# 100ms #
# 1s #
# 10s+
# Tables
# SHOW TABLE STATUS FROM `tabaklae_wp1` LIKE 'wp_postmeta'\G
# SHOW CREATE TABLE `tabaklae_wp1`.`wp_postmeta`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (908) ORDER BY meta_id ASC\G
# Query 10: 0.03 QPS, 0.00x concurrency, ID 0x0F45F1ABEDCB01CF at byte 309463171
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: 2016-01-30 03:39:03 to 2016-03-01 21:27:35
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 10 84030
# Exec time 0 69s 760us 3ms 822us 972us 90us 761us
# Lock time 5 3s 13us 220us 31us 60us 12us 26us
# Rows sent 0 82.06k 1 1 1 1 0 1
# Rows examine 2 229.16M 2.79k 3.55k 2.79k 2.76k 8.68 2.76k
# Rows affecte 0 0 0 0 0 0 0 0
# Query size 4 10.32M 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='add-payment-method' AND context='WooCommerce Endpoints' AND name = 'add-payment-method' LIMIT 1\G
# Query 11: 0.02 QPS, 0.00x concurrency, ID 0x9D121969B55A0EBB at byte 339005458
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: 2016-01-30 03:39:03 to 2016-03-02 09:18:37
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 5 42495
# Exec time 0 47s 941us 2ms 1ms 1ms 106us 1ms
# Lock time 2 1s 17us 139us 29us 42us 7us 26us
# Rows sent 0 31.26k 0 1 0.75 0.99 0.43 0.99
# Rows examine 1 147.19M 3.55k 3.55k 3.55k 3.52k 0 3.52k
# Rows affecte 0 0 0 0 0 0 0 0
# Query size 1 3.84M 90 102 94.84 92.72 1.91 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 14: 0.00 QPS, 0.00x concurrency, ID 0x04248D594D4723A6 at byte 7281
# This item is included in the report because it matches --outliers.
# Scores: V/M = 0.77
# Time range: 2016-01-30 03:38:41 to 2016-02-10 16:30:43
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 21
# Exec time 0 21s 21ms 3s 1s 2s 881ms 1s
# Lock time 0 2ms 58us 136us 82us 93us 17us 80us
# Rows sent 0 21 1 1 1 1 0 1
# Rows examine 0 19.98k 833 1.19k 974.48 1.14k 140.95 1012.63
# Rows affecte 0 0 0 0 0 0 0 0
# Query size 0 2.03k 99 99 99 99 0 99
# String:
# Databases tabaklae_w... (9/42%), mysql (5/23%)... 5 more
# Hosts localhost
# Users root
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms ################################################
# 100ms
# 1s ################################################################
# 10s+
# Tables
# SHOW TABLE STATUS FROM `information_schema` LIKE 'TABLES'\G
# SHOW CREATE TABLE `information_schema`.`TABLES`\G
/*!50000 SELECT IFNULL(SUM(INDEX_LENGTH),0) from information_schema.TABLES where ENGINE='MyISAM' */\G
# Converted for EXPLAIN
# EXPLAIN /*!50100 PARTITIONS*/
SELECT IFNULL(SUM(INDEX_LENGTH),0) from information_schema.TABLES where ENGINE='MyISAM' */\G
# Query 34: 0.00 QPS, 0.00x concurrency, ID 0xAE017F4188882B31 at byte 38679209
# This item is included in the report because it matches --outliers.
# Scores: V/M = 0.88
# Time range: 2016-01-31 03:40:19 to 2016-02-10 16:32:20
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 10
# Exec time 0 3s 16ms 1s 269ms 1s 488ms 16ms
# Lock time 0 848us 70us 112us 84us 93us 12us 89us
# Rows sent 0 20 2 2 2 2 0 2
# Rows examine 0 7.33k 673 1.03k 750.20 1012.63 143.95 652.75
# Rows affecte 0 0 0 0 0 0 0 0
# Query size 0 2.56k 262 262 262 262 0 262
# String:
# Databases highacid_w... (3/30%), mysql (3/30%)... 2 more
# Hosts localhost
# Users root
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms ################################################################
# 100ms
# 1s ################
# 10s+
# Tables
# SHOW TABLE STATUS FROM `information_schema` LIKE 'TABLES'\G
# SHOW CREATE TABLE `information_schema`.`TABLES`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT ENGINE,SUM(DATA_LENGTH+INDEX_LENGTH),COUNT(ENGINE),SUM(DATA_LENGTH),SUM(INDEX_LENGTH) FROM information_schema.TABLES WHERE TABLE_SCHEMA NOT IN ('information_schema', 'performance_schema', 'mysql') AND ENGINE IS NOT NULL GROUP BY ENGINE ORDER BY ENGINE ASC\G
root@panel [~]#
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment