Skip to content

Instantly share code, notes, and snippets.

@dodizzle

dodizzle/gist:5869389

Created June 26, 2013 17:20
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save dodizzle/5869389 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save dodizzle/5869389 to your computer and use it in GitHub Desktop.
Download ZIP
slow query log for db12
Raw
gistfile1.txt
# 5.8s user time, 50ms system time, 29.40M rss, 88.84M vsz
# Current date: Wed Jun 26 17:17:31 2013
# Hostname: db12
# Files: slow.log
# Overall: 16.13k total, 98 unique, 0.11 QPS, 0.50x concurrency __________
# Time range: 2013-06-25 00:02:45 to 2013-06-26 17:11:36
# Attribute total min max avg 95% stddev median
# ============ ======= ======= ======= ======= ======= ======= =======
# Exec time 74513s 1s 340s 5s 5s 14s 3s
# Lock time 7s 26us 227ms 411us 98us 4ms 57us
# Rows sent 3.33M 0 34.44k 216.78 3.89 2.10k 0
# Rows examine 55.07G 0 136.57M 3.50M 5.71M 3.46M 5.44M
# Query size 35.63M 28 343.92k 2.26k 223.14 20.87k 202.40
# Profile
# Rank Query ID Response time Calls R/Call Apdx V/M Item
# ==== ================== ================ ===== ======== ==== ===== =====
# 1 0x80E0D003CC92D8CC 31092.1251 41.7% 9668 3.2160 0.45 0.12 SELECT notifications
# 2 0x5DA665FD05E72446 10070.2934 13.5% 272 37.0231 0.16 42.70 UPDATE users
# 3 0x19E466440A68FB5A 6725.6076 9.0% 2540 2.6479 0.44 1.09 UPDATE notifications
# 4 0x7BBC99382A8F3E03 4634.1334 6.2% 111 41.7489 0.24 77.47 INSERT weheartit_hearts_production.hearts
# 5 0xAAC6427FA26265DF 4572.6322 6.1% 179 25.5454 0.15 26.70 SELECT users
# 6 0x1F5DCEA9AA08EBDD 3845.4415 5.2% 85 45.2405 0.11 40.12 UPDATE entries
# 7 0x9E07F5BC9DD21B6C 2099.0614 2.8% 17 123.4742 0.15 77.86 SELECT entries tagged
# 8 0x44F9BA13BDF7C129 1981.8333 2.7% 38 52.1535 0.21 11... SELECT entries tagged
# 9 0x2B7C79B0AC3D8F57 1727.8942 2.3% 653 2.6461 0.52 24.36 UPDATE users
# 10 0xE15069DCA5045780 1697.4435 2.3% 988 1.7181 0.54 0.31 SELECT weheartit_hearts_production.hearts
# 11 0xC693F5B2EBF21706 993.3003 1.3% 522 1.9029 0.51 1.22 SELECT weheartit_hearts_production.hearts
# 12 0xC339E7F0E58E9D39 458.6435 0.6% 5 91.7287 0.00 8.97 INSERT contacts
# 13 0x33BC6C2FF5612952 448.9542 0.6% 2 224.4771 0.00 0.00 SELECT users contacts
# 14 0xF9535B2CA261D01B 428.0940 0.6% 297 1.4414 0.55 0.37 SELECT weheartit_hearts_production.hearts
# 15 0xF7F50E2AAF03B953 414.8323 0.6% 3 138.2774 0.00 0.48 SELECT users impermium_accounts_infos impermium_connections_infos impermium_feedbacks
# 16 0xA374D38C09705C02 391.3641 0.5% 154 2.5413 0.47 0.55 UPDATE facebook_tokens
# 21 0x8B08D0715046C664 175.5399 0.2% 63 2.7863 0.48 0.33 SELECT weheartit_hearts_production.hearts
# 23 0x8ACF8E33226B0CD0 149.3593 0.2% 124 1.2045 0.56 0.03 SELECT users
# 24 0x15B655A968C6DE21 134.1730 0.2% 25 5.3669 0.42 10.80 SELECT entries
# 25 0x2806342EF563D12F 121.7294 0.2% 11 11.0663 0.27 32.67 UPDATE users
# 27 0x940B56AB6B5653C9 78.8132 0.1% 33 2.3883 0.47 0.48 UPDATE facebook_tokens
# 28 0x1181BD25E74ACF49 69.5550 0.1% 14 4.9682 0.46 8.51 UPDATE entry_sets
# 30 0xBCD06AE646FDB25B 60.6847 0.1% 38 1.5970 0.53 0.44 SELECT contacts
# 31 0x3B234B9598A10102 32.9075 0.0% 27 1.2188 0.61 0.04 SELECT notifications
# 34 0x3C3364D39866E096 22.5281 0.0% 19 1.1857 0.61 0.03 SELECT oauth_access_tokens
# 36 0x700EA47E3B0F9188 17.8797 0.0% 15 1.1920 0.53 0.02 SELECT entries
# 38 0xFA188D3EF40AA8DF 11.6288 0.0% 10 1.1629 0.55 0.01 SELECT entries
# MISC 0xMISC 2056.8048 2.8% 216 9.5222 NS 0.0 <71 ITEMS>
# Query 1: 0.29 QPS, 0.92x concurrency, ID 0x80E0D003CC92D8CC at byte 22700494
# This item is included in the report because it matches --limit.
# Scores: Apdex = 0.45 [1.0], V/M = 0.12
# Query_time sparkline: | ^ |
# Time range: 2013-06-25 23:36:30 to 2013-06-26 08:59:28
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 59 9668
# Exec time 41 31092s 1s 7s 3s 4s 609ms 3s
# Lock time 10 668ms 42us 1ms 69us 93us 46us 60us
# Rows sent 0 16.01k 0 100 1.70 2.90 8.70 0.99
# Rows examine 98 54.21G 1014.49k 5.83M 5.74M 5.71M 252.49k 5.71M
# Query size 5 1.92M 207 208 207.74 202.40 0 202.40
# String:
# Hosts (1433/14%), fe15.whi (831/8%)... 11 more
# Users sidekiq
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms
# 1s ################################################################
# 10s+
# Tables
# SHOW TABLE STATUS LIKE 'notifications'\G
# SHOW CREATE TABLE `notifications`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT `notifications`.* FROM `notifications` WHERE `notifications`.`type_id` IN (2) AND `notifications`.`sent_at` IS NULL AND `notifications`.`user_id` = 3613637 ORDER BY `notifications`.`id` ASC LIMIT 100\G
# Query 2: 0.00 QPS, 0.07x concurrency, ID 0x5DA665FD05E72446 at byte 42438959
# This item is included in the report because it matches --limit.
# Scores: Apdex = 0.16 [1.0], V/M = 42.70
# Query_time sparkline: | _^|
# Time range: 2013-06-25 00:10:03 to 2013-06-26 16:04:26
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 1 272
# Exec time 13 10070s 1s 122s 37s 118s 40s 19s
# Lock time 0 13ms 32us 148us 48us 63us 12us 47us
# Rows sent 0 0 0 0 0 0 0 0
# Rows examine 0 250 0 1 0.92 0.99 0.27 0.99
# Query size 0 25.52k 95 97 96.07 92.72 0 92.72
# String:
# Hosts (50/18%), fe10.whi (27/9%), fe14.whi (26/9%)... 10 more
# Users weheartit_prod
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms
# 1s ####################################
# 10s+ ################################################################
# Tables
# SHOW TABLE STATUS LIKE 'users'\G
# SHOW CREATE TABLE `users`\G
UPDATE `users` SET `hearts_count` = COALESCE(`hearts_count`, 0) + 1 WHERE `users`.`id` = 5812507\G
# Converted for EXPLAIN
# EXPLAIN /*!50100 PARTITIONS*/
select `hearts_count` = COALESCE(`hearts_count`, 0) + 1 from `users` where `users`.`id` = 5812507\G
# Query 3: 0.08 QPS, 0.22x concurrency, ID 0x19E466440A68FB5A at byte 10761419
# This item is included in the report because it matches --limit.
# Scores: Apdex = 0.44 [1.0], V/M = 1.09
# Query_time sparkline: | ^_|
# Time range: 2013-06-25 23:36:49 to 2013-06-26 07:55:15
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 15 2540
# Exec time 9 6726s 1s 21s 3s 5s 2s 2s
# Lock time 2 154ms 35us 1ms 60us 76us 53us 52us
# Rows sent 0 0 0 0 0 0 0 0
# Rows examine 0 2.48k 1 1 1 1 0 1
# Query size 0 334.86k 135 135 135 135 0 135
# String:
# Hosts fe16.whi (522/20%), fe10.whi (417/16%)... 11 more
# Users sidekiq
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms
# 1s ################################################################
# 10s+ #
# Tables
# SHOW TABLE STATUS LIKE 'notifications'\G
# SHOW CREATE TABLE `notifications`\G
UPDATE `notifications` SET `sent_at` = '2013-06-25 23:41:36' WHERE `notifications`.`type_id` IN (2) AND `notifications`.`id` = 44615936\G
# Converted for EXPLAIN
# EXPLAIN /*!50100 PARTITIONS*/
select `sent_at` = '2013-06-25 23:41:36' from `notifications` where `notifications`.`type_id` IN (2) AND `notifications`.`id` = 44615936\G
# Query 4: 0.00 QPS, 0.03x concurrency, ID 0x7BBC99382A8F3E03 at byte 42447242
# This item is included in the report because it matches --limit.
# Scores: Apdex = 0.24 [1.0], V/M = 77.47
# Query_time sparkline: | _^|
# Time range: 2013-06-25 00:10:36 to 2013-06-26 17:03:30
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 111
# Exec time 6 4634s 1s 211s 42s 175s 57s 16s
# Lock time 0 6ms 35us 146us 51us 76us 17us 47us
# Rows sent 0 0 0 0 0 0 0 0
# Rows examine 0 0 0 0 0 0 0 0
# Query size 0 17.42k 158 164 160.72 158.58 1.22 158.58
# String:
# Hosts (18/16%), fe10.whi (13/11%), fe12.whi (10/9%)... 10 more
# Users weheartit_prod
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms
# 1s ################################################
# 10s+ ################################################################
# Tables
# SHOW TABLE STATUS FROM `weheartit_hearts_production` LIKE 'hearts'\G
# SHOW CREATE TABLE `weheartit_hearts_production`.`hearts`\G
INSERT INTO `weheartit_hearts_production`.`hearts` (`created_at`, `entry_id`, `user_id`, `via_user_id`) VALUES ('2013-06-26 13:46:06', 66048423, 5812507, 8416487)\G
# Query 5: 0.00 QPS, 0.04x concurrency, ID 0xAAC6427FA26265DF at byte 20831537
# This item is included in the report because it matches --limit.
# Scores: Apdex = 0.15 [1.0], V/M = 26.70
# Query_time sparkline: | _^|
# Time range: 2013-06-25 00:38:46 to 2013-06-26 08:13:29
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 1 179
# Exec time 6 4573s 1s 113s 26s 80s 26s 15s
# Lock time 83 6s 60us 227ms 31ms 75ms 29ms 24ms
# Rows sent 98 3.28M 1 34.44k 18.79k 31.59k 7.92k 19.40k
# Rows examine 0 3.28M 1 34.44k 18.79k 31.59k 7.92k 19.40k
# Query size 91 32.76M 63 343.92k 187.41k 312.96k 78.75k 192.13k
# String:
# Hosts fe16.whi (24/13%), (23/12%), fe10.whi (21/11%)... 10 more
# Users sidekiq (168/93%), weheartit_... (11/6%)
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms
# 1s ############################################
# 10s+ ################################################################
# Tables
# SHOW TABLE STATUS LIKE 'users'\G
# SHOW CREATE TABLE `users`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT `users`.* FROM `users` WHERE `users`.`id` IN (10233864, 10233887, 10233882, 10233855, 10066093, 10233929, 10233886, 10233835, 10233662, 10233949, 10233650, 10233938, 10233972, 10233975, 10233869, 10233979, 10233922, 10233991, 6266343, 10233942/*... omitted 31748 items ...*/)\G
# Query 6: 0.00 QPS, 0.03x concurrency, ID 0x1F5DCEA9AA08EBDD at byte 42376658
# This item is included in the report because it matches --limit.
# Scores: Apdex = 0.11 [1.0]*, V/M = 40.12
# Query_time sparkline: | _^|
# Time range: 2013-06-25 00:38:49 to 2013-06-26 14:05:42
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 85
# Exec time 5 3845s 1s 122s 45s 118s 43s 35s
# Lock time 0 4ms 34us 97us 47us 63us 10us 44us
# Rows sent 0 0 0 0 0 0 0 0
# Rows examine 0 70 0 1 0.82 0.99 0.38 0.99
# Query size 0 8.38k 101 101 101 101 0 101
# String:
# Hosts (18/21%), fe4.whi (12/14%), fe15.whi (10/11%)... 10 more
# Users weheartit_prod
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms
# 1s ###############################
# 10s+ ################################################################
# Tables
# SHOW TABLE STATUS LIKE 'entries'\G
# SHOW CREATE TABLE `entries`\G
UPDATE `entries` SET `hearts_count` = COALESCE(`hearts_count`, 0) + 1 WHERE `entries`.`id` = 66033751\G
# Converted for EXPLAIN
# EXPLAIN /*!50100 PARTITIONS*/
select `hearts_count` = COALESCE(`hearts_count`, 0) + 1 from `entries` where `entries`.`id` = 66033751\G
# Query 7: 0.00 QPS, 0.29x concurrency, ID 0x9E07F5BC9DD21B6C at byte 21715489
# This item is included in the report because it matches --limit.
# Scores: Apdex = 0.15 [1.0]*, V/M = 77.86
# Query_time sparkline: | _^|
# Time range: 2013-06-25 23:02:40 to 2013-06-26 01:03:01
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 17
# Exec time 2 2099s 1s 230s 123s 223s 98s 193s
# Lock time 0 2ms 73us 135us 99us 113us 15us 98us
# Rows sent 0 1.66k 100 100 100 100 0 100
# Rows examine 0 45.46M 95.90k 5.07M 2.67M 4.93M 2.04M 3.50M
# Query size 0 3.32k 199 200 199.88 192.76 0 192.76
# String:
# Hosts (3/17%), fe11.whi (2/11%), fe15.whi (2/11%)... 8 more
# Users weheartit_prod
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms
# 1s ############################################
# 10s+ ################################################################
# Tables
# SHOW TABLE STATUS LIKE 'entries'\G
# SHOW CREATE TABLE `entries`\G
# SHOW TABLE STATUS LIKE 'tagged'\G
# SHOW CREATE TABLE `tagged`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT `entries`.* FROM `entries` INNER JOIN `tagged` ON `tagged`.`entry_id` = `entries`.`id` WHERE `entries`.`checked` = '0' AND `tagged`.`tag_id` = 12294 ORDER BY entries.id DESC LIMIT 100 OFFSET 0\G
# Query 8: 0.00 QPS, 0.23x concurrency, ID 0x44F9BA13BDF7C129 at byte 21666819
# This item is included in the report because it matches --limit.
# Scores: Apdex = 0.21 [1.0]*, V/M = 110.63
# Query_time sparkline: | ^_|
# Time range: 2013-06-25 22:41:49 to 2013-06-26 01:08:36
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 38
# Exec time 2 1982s 1s 208s 52s 193s 76s 5s
# Lock time 0 3ms 47us 98us 70us 89us 12us 66us
# Rows sent 0 38 1 1 1 1 0 1
# Rows examine 0 32.15M 16.56k 3.50M 866.47k 3.34M 1.26M 67.32k
# Query size 0 5.64k 151 152 151.92 151.03 0.50 151.03
# String:
# Hosts fe11.whi (6/15%), (4/10%), fe15.whi (4/10%)... 10 more
# Users weheartit_prod
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms
# 1s ################################################################
# 10s+ ##############################################
# Tables
# SHOW TABLE STATUS LIKE 'entries'\G
# SHOW CREATE TABLE `entries`\G
# SHOW TABLE STATUS LIKE 'tagged'\G
# SHOW CREATE TABLE `tagged`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT COUNT(*) FROM `entries` INNER JOIN `tagged` ON `tagged`.`entry_id` = `entries`.`id` WHERE `entries`.`checked` = '0' AND `tagged`.`tag_id` = 12294\G
# Query 9: 0.00 QPS, 0.01x concurrency, ID 0x2B7C79B0AC3D8F57 at byte 42282566
# This item is included in the report because it matches --limit.
# Scores: Apdex = 0.52 [1.0], V/M = 24.36
# Query_time sparkline: | ^_|
# Time range: 2013-06-25 00:38:39 to 2013-06-26 15:11:26
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 4 653
# Exec time 2 1728s 1s 120s 3s 3s 8s 2s
# Lock time 0 29ms 27us 299us 43us 57us 14us 40us
# Rows sent 0 0 0 0 0 0 0 0
# Rows examine 0 652 0 1 1.00 0.99 0.04 0.99
# Query size 0 54.05k 84 85 84.76 84.10 0.50 84.10
# String:
# Hosts (102/15%), fe15.whi (56/8%), fe3.whi (53/8%)... 10 more
# Users sidekiq (617/94%), weheartit_... (36/5%)
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms
# 1s ################################################################
# 10s+ #
# Tables
# SHOW TABLE STATUS LIKE 'users'\G
# SHOW CREATE TABLE `users`\G
UPDATE `users` SET `updated_at` = '2013-06-26 10:07:56' WHERE `users`.`id` = 2076473\G
# Converted for EXPLAIN
# EXPLAIN /*!50100 PARTITIONS*/
select `updated_at` = '2013-06-26 10:07:56' from `users` where `users`.`id` = 2076473\G
# Query 10: 0.01 QPS, 0.01x concurrency, ID 0xE15069DCA5045780 at byte 2332256
# This item is included in the report because it matches --limit.
# Scores: Apdex = 0.54 [1.0], V/M = 0.31
# Query_time sparkline: | ^ |
# Time range: 2013-06-25 00:02:45 to 2013-06-26 17:11:36
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 6 988
# Exec time 2 1697s 1s 5s 2s 4s 727ms 1s
# Lock time 1 68ms 41us 2ms 68us 84us 89us 57us
# Rows sent 0 2.89k 3 3 3 3 0 3
# Rows examine 0 11.17M 3 26.54k 11.58k 20.37k 4.42k 10.29k
# Query size 0 222.90k 230 233 231.02 223.14 0 223.14
# String:
# Hosts (127/12%), fe4.whi (82/8%), fe15.whi (80/8%)... 10 more
# Users weheartit_prod
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms
# 1s ################################################################
# 10s+
# Tables
# SHOW TABLE STATUS FROM `weheartit_hearts_production` LIKE 'hearts'\G
# SHOW CREATE TABLE `weheartit_hearts_production`.`hearts`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT `weheartit_hearts_production`.`hearts`.* FROM `weheartit_hearts_production`.`hearts` WHERE `weheartit_hearts_production`.`hearts`.`user_id` = 2127252 AND (created_at < '2012-12-08 21:24:02') ORDER BY created_at desc LIMIT 3\G
# Query 11: 0.00 QPS, 0.01x concurrency, ID 0xC693F5B2EBF21706 at byte 2686081
# This item is included in the report because it matches --limit.
# Scores: Apdex = 0.51 [1.0], V/M = 1.22
# Query_time sparkline: | ^_|
# Time range: 2013-06-25 00:05:28 to 2013-06-26 17:06:14
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 3 522
# Exec time 1 993s 1s 17s 2s 4s 2s 1s
# Lock time 0 33ms 41us 314us 62us 89us 23us 60us
# Rows sent 0 8.75k 0 48 17.16 46.83 22.37 0
# Rows examine 0 6.18M 4 140.65k 12.13k 27.29k 13.75k 8.06k
# Query size 0 111.85k 216 222 219.41 212.52 0 212.52
# String:
# Hosts (83/15%), fe10.whi (47/9%), fe12.whi (43/8%)... 10 more
# Users weheartit_prod
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms
# 1s ################################################################
# 10s+ #
# Tables
# SHOW TABLE STATUS FROM `weheartit_hearts_production` LIKE 'hearts'\G
# SHOW CREATE TABLE `weheartit_hearts_production`.`hearts`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT `weheartit_hearts_production`.`hearts`.* FROM `weheartit_hearts_production`.`hearts` WHERE `weheartit_hearts_production`.`hearts`.`user_id` = 2127252 AND (id < 47961520) ORDER BY hearts.created_at desc LIMIT 48\G
# Query 12: 0.04 QPS, 3.79x concurrency, ID 0xC339E7F0E58E9D39 at byte 42327914
# This item is included in the report because it matches --limit.
# Scores: Apdex = 0.00 [1.0]*, V/M = 8.97
# Query_time sparkline: | ^|
# Time range: 2013-06-26 11:25:23 to 11:27:24
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 5
# Exec time 0 459s 46s 120s 92s 118s 29s 107s
# Lock time 0 260us 33us 73us 52us 69us 13us 54us
# Rows sent 0 0 0 0 0 0 0 0
# Rows examine 0 0 0 0 0 0 0 0
# Query size 0 670 134 134 134 134 0 134
# String:
# Hosts (2/40%), fe11.whi (1/20%), fe14.whi (1/20%)... 1 more
# Users weheartit_prod
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms
# 1s
# 10s+ ################################################################
# Tables
# SHOW TABLE STATUS LIKE 'contacts'\G
# SHOW CREATE TABLE `contacts`\G
INSERT INTO `contacts` (`contact_id`, `created_at`, `facebook_friend`, `user_id`) VALUES (2344865, '2013-06-26 11:23:23', 0, 10284730)\G
# Query 13: 0.00 QPS, 0.01x concurrency, ID 0x33BC6C2FF5612952 at byte 2375381
# This item is included in the report because it matches --limit.
# Scores: Apdex = 0.00 [1.0]*, V/M = 0.00
# Query_time sparkline: | ^|
# Time range: 2013-06-25 05:05:24 to 2013-06-26 05:05:26
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 2
# Exec time 0 449s 224s 225s 224s 225s 419ms 224s
# Lock time 0 333us 162us 171us 166us 171us 6us 166us
# Rows sent 0 67 31 36 33.50 36 3.54 33.50
# Rows examine 0 272.72M 136.15M 136.57M 136.36M 136.57M 309.64k 136.36M
# Query size 0 462 231 231 231 231 0 231
# String:
# Hosts fe2.whi
# Users cron
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms
# 1s
# 10s+ ################################################################
# Tables
# SHOW TABLE STATUS LIKE 'users'\G
# SHOW CREATE TABLE `users`\G
# SHOW TABLE STATUS LIKE 'contacts'\G
# SHOW CREATE TABLE `contacts`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT u.id
FROM users AS u LEFT JOIN (
SELECT c.user_id, count(*) AS actual_count
FROM contacts AS c
GROUP BY c.user_id
) AS f ON u.id = f.user_id
WHERE u.following_count <> f.actual_count\G
# Query 14: 0.00 QPS, 0.00x concurrency, ID 0xF9535B2CA261D01B at byte 2680303
# This item is included in the report because it matches --limit.
# Scores: Apdex = 0.55 [1.0], V/M = 0.37
# Query_time sparkline: | ^ |
# Time range: 2013-06-25 00:38:49 to 2013-06-26 16:58:52
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 1 297
# Exec time 0 428s 1s 7s 1s 2s 730ms 1s
# Lock time 0 19ms 40us 536us 64us 84us 41us 57us
# Rows sent 0 891 3 3 3 3 0 3
# Rows examine 0 2.99M 3 72.46k 10.31k 17.59k 8.26k 7.68k
# Query size 0 66.78k 229 231 230.25 223.14 0 223.14
# String:
# Hosts (49/16%), fe8.whi (28/9%), fe16.whi (27/9%)... 10 more
# Users weheartit_prod
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms
# 1s ################################################################
# 10s+
# Tables
# SHOW TABLE STATUS FROM `weheartit_hearts_production` LIKE 'hearts'\G
# SHOW CREATE TABLE `weheartit_hearts_production`.`hearts`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT `weheartit_hearts_production`.`hearts`.* FROM `weheartit_hearts_production`.`hearts` WHERE `weheartit_hearts_production`.`hearts`.`user_id` = 1273351 AND (created_at > '2012-07-18 11:51:38') ORDER BY created_at asc LIMIT 3\G
# Query 15: 0.01 QPS, 1.07x concurrency, ID 0xF7F50E2AAF03B953 at byte 2818833
# This item is included in the report because it matches --limit.
# Scores: Apdex = 0.00 [1.0]*, V/M = 0.48
# Query_time sparkline: | ^|
# Time range: 2013-06-25 22:47:58 to 22:54:24
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 3
# Exec time 0 415s 129s 146s 138s 144s 8s 137s
# Lock time 0 769us 215us 277us 256us 273us 27us 273us
# Rows sent 0 30 10 10 10 10 0 10
# Rows examine 0 65.99M 22.00M 22.00M 22.00M 21.31M 0 21.31M
# Query size 0 7.00k 2.33k 2.33k 2.33k 2.33k 0 2.33k
# String:
# Hosts staging2.whi
# Users staging
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms
# 1s
# 10s+ ################################################################
# Tables
# SHOW TABLE STATUS LIKE 'users'\G
# SHOW CREATE TABLE `users`\G
# SHOW TABLE STATUS LIKE 'impermium_accounts_infos'\G
# SHOW CREATE TABLE `impermium_accounts_infos`\G
# SHOW TABLE STATUS LIKE 'impermium_connections_infos'\G
# SHOW CREATE TABLE `impermium_connections_infos`\G
# SHOW TABLE STATUS LIKE 'impermium_feedbacks'\G
# SHOW CREATE TABLE `impermium_feedbacks`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT `users`.`id` AS t0_r0, `users`.`username` AS t0_r1, `users`.`name` AS t0_r2, `users`.`email` AS t0_r3, `users`.`bio` AS t0_r4, `users`.`location` AS t0_r5, `users`.`link` AS t0_r6, `users`.`avatar_file_name` AS t0_r7, `users`.`avatar_content_type` AS t0_r8, `users`.`show_unsafe_content` AS t0_r9, `users`.`hearts_count` AS t0_r10, `users`.`created_at` AS t0_r11, `users`.`updated_at` AS t0_r12, `users`.`following_count` AS t0_r13, `users`.`followers_count` AS t0_r14, `users`.`twitter` AS t0_r15, `users`.`facebook_id` AS t0_r16, `users`.`twitter_id` AS t0_r17, `users`.`avatar_timestamp` AS t0_r18, `users`.`sets_count` AS t0_r19, `users`.`entries_count` AS t0_r20, `users`.`gender` AS t0_r21, `users`.`locale` AS t0_r22, `users`.`birth_year` AS t0_r23, `users`.`birth_month` AS t0_r24, `users`.`birth_day` AS t0_r25, `users`.`private_account` AS t0_r26, `users`.`blocked` AS t0_r27, `users`.`verified` AS t0_r28, `users`.`unsafe_hearts_count` AS t0_r29, `impermium_accounts_infos`.`id` AS t1_r0, `impermium_accounts_infos`.`label` AS t1_r1, `impermium_accounts_infos`.`score` AS t1_r2, `impermium_accounts_infos`.`user_id` AS t1_r3, `impermium_accounts_infos`.`created_at` AS t1_r4, `impermium_accounts_infos`.`updated_at` AS t1_r5, `impermium_accounts_infos`.`risk` AS t1_r6, `impermium_connections_infos`.`id` AS t2_r0, `impermium_connections_infos`.`cleared` AS t2_r1, `impermium_connections_infos`.`last_score` AS t2_r2, `impermium_connections_infos`.`total_spam_connections` AS t2_r3, `impermium_connections_infos`.`user_id` AS t2_r4, `impermium_connections_infos`.`created_at` AS t2_r5, `impermium_connections_infos`.`updated_at` AS t2_r6, `impermium_feedbacks`.`id` AS t3_r0, `impermium_feedbacks`.`user_id` AS t3_r1, `impermium_feedbacks`.`spammer` AS t3_r2, `impermium_feedbacks`.`reason` AS t3_r3, `impermium_feedbacks`.`created_at` AS t3_r4, `impermium_feedbacks`.`updated_at` AS t3_r5 FROM `users` LEFT OUTER JOIN `impermium_accounts_infos` ON `impermium_accounts_infos`.`user_id` = `users`.`id` LEFT OUTER JOIN `impermium_connections_infos` ON `impermium_connections_infos`.`user_id` = `users`.`id` LEFT OUTER JOIN `impermium_feedbacks` ON `impermium_feedbacks`.`user_id` = `users`.`id` WHERE (impermium_accounts_infos.score > 0 OR impermium_connections_infos.last_score > 0) AND (impermium_feedbacks.user_id IS NULL) ORDER BY users.created_at DESC LIMIT 10 OFFSET 0\G
# Query 16: 4.05 QPS, 10.30x concurrency, ID 0xA374D38C09705C02 at byte 42164756
# This item is included in the report because it matches --outliers.
# Scores: Apdex = 0.47 [1.0], V/M = 0.55
# Query_time sparkline: | ^ |
# Time range: 2013-06-26 08:14:42 to 08:15:20
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 154
# Exec time 0 391s 1s 5s 3s 4s 1s 2s
# Lock time 0 8ms 38us 231us 54us 80us 20us 49us
# Rows sent 0 0 0 0 0 0 0 0
# Rows examine 0 154 1 1 1 1 0 1
# Query size 0 21.66k 144 144 144 144 0 144
# String:
# Hosts (32/20%), fe15.whi (12/7%), fe8.whi (12/7%)... 10 more
# Users sidekiq
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms
# 1s ################################################################
# 10s+
# Tables
# SHOW TABLE STATUS LIKE 'facebook_tokens'\G
# SHOW CREATE TABLE `facebook_tokens`\G
UPDATE `facebook_tokens` SET `last_failed` = '2013-06-26 08:14:43', `updated_at` = '2013-06-26 08:14:43' WHERE `facebook_tokens`.`id` = 12351509\G
# Converted for EXPLAIN
# EXPLAIN /*!50100 PARTITIONS*/
select `last_failed` = '2013-06-26 08:14:43', `updated_at` = '2013-06-26 08:14:43' from `facebook_tokens` where `facebook_tokens`.`id` = 12351509\G
# Query 21: 0.00 QPS, 0.00x concurrency, ID 0x8B08D0715046C664 at byte 2600522
# This item is included in the report because it matches --outliers.
# Scores: Apdex = 0.48 [1.0]*, V/M = 0.33
# Query_time sparkline: | ^ |
# Time range: 2013-06-25 12:13:42 to 2013-06-26 13:08:24
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 63
# Exec time 0 176s 1s 4s 3s 4s 959ms 3s
# Lock time 0 5ms 53us 220us 83us 138us 32us 76us
# Rows sent 0 2.46k 40 40 40 40 0 40
# Rows examine 0 1.18M 8.34k 22.15k 19.13k 21.38k 3.92k 20.37k
# Query size 0 16.29k 263 265 264.79 258.32 0 258.32
# String:
# Hosts (8/12%), fe7.whi (7/11%), fe11.whi (6/9%)... 10 more
# Users weheartit_prod
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms
# 1s ################################################################
# 10s+
# Tables
# SHOW TABLE STATUS FROM `weheartit_hearts_production` LIKE 'hearts'\G
# SHOW CREATE TABLE `weheartit_hearts_production`.`hearts`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT `weheartit_hearts_production`.`hearts`.* FROM `weheartit_hearts_production`.`hearts` WHERE (user_id = 2127252 AND (created_at < '2012-12-01 15:53:14' OR (created_at = '2012-12-01 15:53:14' AND id < '1691649596'))) ORDER BY created_at DESC, id DESC LIMIT 40\G
# Query 23: 0.00 QPS, 0.00x concurrency, ID 0x8ACF8E33226B0CD0 at byte 2270444
# This item is included in the report because it matches --outliers.
# Scores: Apdex = 0.56 [1.0], V/M = 0.03
# Query_time sparkline: | ^ |
# Time range: 2013-06-25 00:38:43 to 2013-06-26 07:55:11
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 124
# Exec time 0 149s 1s 2s 1s 2s 177ms 1s
# Lock time 0 13ms 38us 489us 102us 194us 57us 84us
# Rows sent 0 124 1 1 1 1 0 1
# Rows examine 0 124 1 1 1 1 0 1
# Query size 0 8.24k 67 69 68.06 65.89 0 65.89
# String:
# Hosts (16/12%), fe10.whi (16/12%), fe9.whi (14/11%)... 10 more
# Users weheartit_... (122/98%), sidekiq (2/1%)
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms
# 1s ################################################################
# 10s+
# Tables
# SHOW TABLE STATUS LIKE 'users'\G
# SHOW CREATE TABLE `users`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT `users`.* FROM `users` WHERE `users`.`id` = 7798634 LIMIT 1\G
# Query 24: 0.00 QPS, 0.00x concurrency, ID 0x15B655A968C6DE21 at byte 22509381
# This item is included in the report because it matches --outliers.
# Scores: Apdex = 0.42 [1.0]*, V/M = 10.80
# Query_time sparkline: | ^_|
# Time range: 2013-06-25 04:17:18 to 2013-06-26 15:55:59
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 25
# Exec time 0 134s 1s 31s 5s 16s 8s 3s
# Lock time 0 2ms 42us 100us 60us 69us 12us 57us
# Rows sent 0 1.02k 4 50 41.60 49.17 14.82 49.17
# Rows examine 0 1.56M 6.87k 195.34k 63.75k 192.13k 61.58k 27.29k
# Query size 0 2.63k 106 110 107.60 107.34 2 102.22
# String:
# Hosts (6/24%), fe15.whi (3/12%), fe9.whi (3/12%)... 9 more
# Users weheartit_prod
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms
# 1s ################################################################
# 10s+ ########
# Tables
# SHOW TABLE STATUS LIKE 'entries'\G
# SHOW CREATE TABLE `entries`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT `entries`.* FROM `entries` WHERE `entries`.`host_id` = 12 ORDER BY id desc LIMIT 50 OFFSET 199980\G
# Query 25: 0.00 QPS, 0.00x concurrency, ID 0x2806342EF563D12F at byte 42328235
# This item is included in the report because it matches --outliers.
# Scores: Apdex = 0.27 [1.0]*, V/M = 32.67
# Query_time sparkline: | ^_|
# Time range: 2013-06-26 00:12:01 to 13:05:02
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 11
# Exec time 0 122s 1s 71s 11s 15s 19s 4s
# Lock time 0 588us 35us 75us 53us 73us 13us 47us
# Rows sent 0 0 0 0 0 0 0 0
# Rows examine 0 11 1 1 1 1 0 1
# Query size 0 1.10k 102 103 102.64 102.22 0.50 102.22
# String:
# Hosts fe10.whi (4/36%), fe14.whi (2/18%)... 4 more
# Users weheartit_prod
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms
# 1s ################################################################
# 10s+ ########################
# Tables
# SHOW TABLE STATUS LIKE 'users'\G
# SHOW CREATE TABLE `users`\G
UPDATE `users` SET `following_count` = COALESCE(`following_count`, 0) + 1 WHERE `users`.`id` = 10284730\G
# Converted for EXPLAIN
# EXPLAIN /*!50100 PARTITIONS*/
select `following_count` = COALESCE(`following_count`, 0) + 1 from `users` where `users`.`id` = 10284730\G
# Query 27: 1.18 QPS, 2.81x concurrency, ID 0x940B56AB6B5653C9 at byte 42210278
# This item is included in the report because it matches --outliers.
# Scores: Apdex = 0.47 [1.0]*, V/M = 0.48
# Query_time sparkline: | ^ |
# Time range: 2013-06-26 08:14:52 to 08:15:20
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 33
# Exec time 0 79s 1s 4s 2s 4s 1s 2s
# Lock time 0 2ms 41us 167us 63us 80us 20us 57us
# Rows sent 0 0 0 0 0 0 0 0
# Rows examine 0 33 1 1 1 1 0 1
# Query size 0 8.49k 247 353 263.58 346.17 35.81 246.02
# String:
# Hosts fe7.whi (6/18%), fe4.whi (5/15%)... 10 more
# Users sidekiq
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms
# 1s ################################################################
# 10s+
# Tables
# SHOW TABLE STATUS LIKE 'facebook_tokens'\G
# SHOW CREATE TABLE `facebook_tokens`\G
UPDATE `facebook_tokens` SET `last_failed` = '2013-06-26 08:15:16', `last_error` = '#<Koala::Facebook::APIError: HTTP 500: Response body: {\"error\":{\"message\":\"An unexpected error has occurred. Please retry your request later.\",\"type\":\"OAuthException\",\"code\":2}}>', `updated_at` = '2013-06-26 08:15:16' WHERE `facebook_tokens`.`id` = 12409942\G
# Converted for EXPLAIN
# EXPLAIN /*!50100 PARTITIONS*/
select `last_failed` = '2013-06-26 08:15:16', `last_error` = '#<Koala::Facebook::APIError: HTTP 500: Response body: {\"error\":{\"message\":\"An unexpected error has occurred. Please retry your request later.\",\"type\":\"OAuthException\",\"code\":2}}>', `updated_at` = '2013-06-26 08:15:16' from `facebook_tokens` where `facebook_tokens`.`id` = 12409942\G
# Query 28: 0.00 QPS, 0.00x concurrency, ID 0x1181BD25E74ACF49 at byte 42403883
# This item is included in the report because it matches --outliers.
# Scores: Apdex = 0.46 [1.0]*, V/M = 8.51
# Query_time sparkline: | ^_|
# Time range: 2013-06-25 19:57:38 to 2013-06-26 12:59:31
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 14
# Exec time 0 70s 1s 23s 5s 19s 7s 2s
# Lock time 0 707us 41us 73us 50us 60us 7us 47us
# Rows sent 0 0 0 0 0 0 0 0
# Rows examine 0 14 1 1 1 1 0 1
# Query size 0 1.48k 108 108 108 108 0 108
# String:
# Hosts fe11.whi (4/28%), (3/21%), fe15.whi (2/14%)... 4 more
# Users weheartit_prod
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms
# 1s ################################################################
# 10s+ ##########
# Tables
# SHOW TABLE STATUS LIKE 'entry_sets'\G
# SHOW CREATE TABLE `entry_sets`\G
UPDATE `entry_sets` SET `setteds_count` = COALESCE(`setteds_count`, 0) + 1 WHERE `entry_sets`.`id` = 7825398\G
# Converted for EXPLAIN
# EXPLAIN /*!50100 PARTITIONS*/
select `setteds_count` = COALESCE(`setteds_count`, 0) + 1 from `entry_sets` where `entry_sets`.`id` = 7825398\G
# Query 30: 0.00 QPS, 0.00x concurrency, ID 0xBCD06AE646FDB25B at byte 2338899
# This item is included in the report because it matches --outliers.
# Scores: Apdex = 0.53 [1.0]*, V/M = 0.44
# Query_time sparkline: | ^ |
# Time range: 2013-06-25 02:23:07 to 2013-06-26 14:39:52
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 38
# Exec time 0 61s 1s 6s 2s 2s 837ms 1s
# Lock time 0 2ms 36us 73us 48us 63us 8us 47us
# Rows sent 0 633 1 20 16.66 19.46 3.42 16.81
# Rows examine 0 439.86k 2.20k 26.75k 11.58k 11.34k 3.96k 11.34k
# Query size 0 4.59k 123 124 123.79 118.34 0.00 118.34
# String:
# Hosts fe8.whi (8/21%), fe12.whi (5/13%), (4/10%)... 10 more
# Users weheartit_prod
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms
# 1s ################################################################
# 10s+
# Tables
# SHOW TABLE STATUS LIKE 'contacts'\G
# SHOW CREATE TABLE `contacts`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT `contacts`.* FROM `contacts` WHERE `contacts`.`contact_id` = 738734 ORDER BY created_at desc LIMIT 20 OFFSET 27380\G
# Query 31: 0.00 QPS, 0.00x concurrency, ID 0x3B234B9598A10102 at byte 22372245
# This item is included in the report because it matches --outliers.
# Scores: Apdex = 0.61 [1.0]*, V/M = 0.04
# Query_time sparkline: | ^ |
# Time range: 2013-06-25 00:38:38 to 2013-06-26 05:04:58
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 27
# Exec time 0 33s 1s 2s 1s 2s 220ms 1s
# Lock time 0 2ms 37us 111us 57us 84us 17us 52us
# Rows sent 0 36 0 2 1.33 1.96 0.53 0.99
# Rows examine 0 754.49k 1 36.77k 27.94k 34.83k 6.57k 27.29k
# Query size 0 4.50k 169 171 170.59 166.51 0 166.51
# String:
# Hosts (6/22%), fe14.whi (4/14%), fe7.whi (3/11%)... 10 more
# Users weheartit_... (26/96%), sidekiq (1/3%)
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms
# 1s ################################################################
# 10s+
# Tables
# SHOW TABLE STATUS LIKE 'notifications'\G
# SHOW CREATE TABLE `notifications`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT `notifications`.* FROM `notifications` WHERE `notifications`.`type_id` IN (2) AND `notifications`.`user_id` = 577031 AND `notifications`.`initiator_id` = 10436458\G
# Query 34: 0.00 QPS, 0.00x concurrency, ID 0x3C3364D39866E096 at byte 2292110
# This item is included in the report because it matches --outliers.
# Scores: Apdex = 0.61 [1.0]*, V/M = 0.03
# Query_time sparkline: | ^ |
# Time range: 2013-06-25 00:38:47 to 2013-06-26 01:30:22
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 19
# Exec time 0 23s 1s 2s 1s 1s 172ms 1s
# Lock time 0 2ms 48us 188us 101us 138us 33us 93us
# Rows sent 0 19 1 1 1 1 0 1
# Rows examine 0 19 1 1 1 1 0 1
# Query size 0 3.19k 172 172 172 172 0 172
# String:
# Hosts fe10.whi (3/15%), fe14.whi (3/15%)... 8 more
# Users weheartit_prod
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms
# 1s ################################################################
# 10s+
# Tables
# SHOW TABLE STATUS LIKE 'oauth_access_tokens'\G
# SHOW CREATE TABLE `oauth_access_tokens`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT `oauth_access_tokens`.* FROM `oauth_access_tokens` WHERE `oauth_access_tokens`.`token` = 'edac05e8de769f18ba91008b253c7536e5401a9b71f3dcf69cba2d8aca2f56b1' LIMIT 1\G
# Query 36: 0.00 QPS, 0.00x concurrency, ID 0x700EA47E3B0F9188 at byte 2271001
# This item is included in the report because it matches --outliers.
# Scores: Apdex = 0.53 [1.0]*, V/M = 0.02
# Query_time sparkline: | ^ |
# Time range: 2013-06-25 00:38:46 to 2013-06-26 01:30:23
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 15
# Exec time 0 18s 1s 2s 1s 1s 151ms 1s
# Lock time 0 2ms 61us 213us 109us 159us 37us 103us
# Rows sent 0 256 3 40 17.07 38.53 13.11 11.95
# Rows examine 0 256 3 40 17.07 38.53 13.11 11.95
# Query size 0 3.36k 89 459 229.67 441.81 130.69 174.84
# String:
# Hosts (2/13%), fe11.whi (2/13%), fe2.whi (2/13%)... 8 more
# Users weheartit_... (14/93%), sidekiq (1/6%)
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms
# 1s ################################################################
# 10s+
# Tables
# SHOW TABLE STATUS LIKE 'entries'\G
# SHOW CREATE TABLE `entries`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT `entries`.* FROM `entries` WHERE `entries`.`id` IN (61433334, 61433324, 61433294)\G
# Query 38: 0.00 QPS, 0.00x concurrency, ID 0xFA188D3EF40AA8DF at byte 2200184
# This item is included in the report because it matches --outliers.
# Scores: Apdex = 0.55 [1.0]*, V/M = 0.01
# Query_time sparkline: | ^ |
# Time range: 2013-06-25 00:38:45 to 2013-06-26 01:30:21
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 10
# Exec time 0 12s 1s 1s 1s 1s 86ms 1s
# Lock time 0 1ms 47us 297us 106us 159us 69us 69us
# Rows sent 0 10 1 1 1 1 0 1
# Rows examine 0 10 1 1 1 1 0 1
# Query size 0 750 75 75 75 75 0 75
# String:
# Hosts (2/20%), fe11.whi (2/20%), fe14.whi (2/20%)... 4 more
# Users weheartit_prod
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms
# 1s ################################################################
# 10s+
# Tables
# SHOW TABLE STATUS LIKE 'entries'\G
# SHOW CREATE TABLE `entries`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT `entries`.* FROM `entries` WHERE `entries`.`id` = 65879718 LIMIT 1\G
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment