プロファイリングスレ
motemen opened this issue · 8 comments
motemen commented
プロファイリングスレ
motemen commented
isucon@ip-192-168-0-13:~$ sudo pt-query-digest /tmp/mysql-slow.log
# 24.4s user time, 50ms system time, 34.27M rss, 41.61M vsz
# Current date: Sat Aug 21 11:36:42 2021
# Hostname: ip-192-168-0-13
# Files: /tmp/mysql-slow.log
# Overall: 313.81k total, 65 unique, 4.36k QPS, 13.06x concurrency _______
# Time range: 2021-08-21 11:34:35 to 11:35:47
# Attribute total min max avg 95% stddev median
# ============ ======= ======= ======= ======= ======= ======= =======
# Exec time 940s 0 931ms 3ms 2ms 30ms 33us
# Lock time 2s 0 36ms 7us 17us 160us 0
# Rows sent 973.75k 0 1.65k 3.18 0.99 44.83 0
# Rows examine 145.18M 0 76.32k 485.11 0 4.43k 0
# Rows affecte 74.77k 0 618 0.24 0.99 1.14 0
# Bytes sent 314.72M 0 289.76k 1.03k 621.67 9.55k 12.54
# Query size 29.22M 6 790.36k 97.64 271.23 1.43k 31.70
# Boolean:
# QC hit 4% yes, 95% no
# Profile
# Rank Query ID Response time Calls R/Call V/M Ite
# ==== ============================ ============== ====== ====== ===== ===
# 1 0x8155B89FFD74A9D523D19AC... 493.0358 52.4% 2243 0.2198 0.20 SELECT isu_condition
# 2 0x931A992E852C61FC6D46141... 265.6927 28.3% 3898 0.0682 0.12 SELECT isu_condition
# 3 0x9C6C682008AE0D08F3E2A00... 94.1320 10.0% 604 0.1558 0.13 SELECT isu_condition
# 4 0xFFFCA4D67EA0A788813031B... 35.3428 3.8% 8196 0.0043 0.01 COMMIT
# 5 0x5F580A12ADA1633C9634298... 18.6697 2.0% 158 0.1182 0.07 SELECT isu_condition
# MISC 0xMISC 33.4498 3.6% 298715 0.0001 0.0 <60 ITEMS>
# Query 1: 35.60 QPS, 7.83x concurrency, ID 0x8155B89FFD74A9D523D19AC409FD97AF at byte 103945682
# Scores: V/M = 0.20
# Time range: 2021-08-21 11:34:42 to 11:35:45
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 2243
# Exec time 52 493s 236us 931ms 220ms 672ms 208ms 155ms
# Lock time 9 219ms 7us 25ms 97us 57us 935us 12us
# Rows sent 0 2.13k 0 1 0.97 0.99 0.17 0.99
# Rows examine 49 72.57M 718 74.56k 33.13k 68.96k 23.32k 30.09k
# Rows affecte 0 0 0 0 0 0 0 0
# Bytes sent 0 1.59M 589 789 742.34 755.64 31.67 719.66
# Query size 0 273.80k 125 125 125 125 0 125
# String:
# Databases isucondition
# Hosts isuconditi... (844/37%)... 2 more
# Users isucon
# Query_time distribution
# 1us
# 10us
# 100us ###
# 1ms #######
# 10ms ########################
# 100ms ################################################################
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `isucondition` LIKE 'isu_condition'\G
# SHOW CREATE TABLE `isucondition`.`isu_condition`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT * FROM `isu_condition` WHERE `jia_isu_uuid` = 'af9bdff8-7261-4847-b373-b7a7e7b7f4dc' ORDER BY `timestamp` DESC LIMIT 1\G
# Query 2: 59.06 QPS, 4.03x concurrency, ID 0x931A992E852C61FC6D46141A39DEF4FE at byte 103497289
# Scores: V/M = 0.12
# Time range: 2021-08-21 11:34:41 to 11:35:47
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 1 3898
# Exec time 28 266s 6us 872ms 68ms 208ms 92ms 38ms
# Lock time 9 232ms 0 20ms 59us 44us 659us 12us
# Rows sent 68 668.08k 0 1.65k 175.50 685.39 295.33 69.19
# Rows examine 33 48.14M 0 76.32k 12.65k 54.03k 15.91k 6.31k
# Rows affecte 0 0 0 0 0 0 0 0
# Bytes sent 32 103.02M 589 289.76k 27.06k 106.99k 45.68k 9.80k
# Query size 1 437.76k 115 115 115 115 0 115
# Boolean:
# QC hit 4% yes, 95% no
# String:
# Databases isucondition
# Hosts isuconditi... (1922/49%)... 2 more
# Users isucon
# Query_time distribution
# 1us #
# 10us ####
# 100us #####
# 1ms ##########################
# 10ms ################################################################
# 100ms ################################
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `isucondition` LIKE 'isu_condition'\G
# SHOW CREATE TABLE `isucondition`.`isu_condition`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT * FROM `isu_condition` WHERE `jia_isu_uuid` = 'd152466b-aae7-48a7-a12e-55942bfc70ec' ORDER BY timestamp DESC\G
# Query 3: 10.79 QPS, 1.68x concurrency, ID 0x9C6C682008AE0D08F3E2A0049B030C70 at byte 104092460
# Scores: V/M = 0.13
# Time range: 2021-08-21 11:34:42 to 11:35:38
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 604
# Exec time 10 94s 323us 919ms 156ms 477ms 144ms 116ms
# Lock time 0 13ms 8us 2ms 22us 33us 76us 12us
# Rows sent 20 199.94k 0 1.12k 338.98 833.10 285.04 246.02
# Rows examine 13 19.56M 748 70.07k 33.17k 59.57k 20.49k 40.32k
# Rows affecte 0 0 0 0 0 0 0 0
# Bytes sent 9 30.78M 589 179.32k 52.18k 130.04k 43.88k 36.57k
# Query size 0 92.61k 157 157 157 157 0 157
# String:
# Databases isucondition
# Hosts isuconditi... (216/35%)... 2 more
# Users isucon
# Query_time distribution
# 1us
# 10us
# 100us #
# 1ms #########
# 10ms ####################################
# 100ms ################################################################
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `isucondition` LIKE 'isu_condition'\G
# SHOW CREATE TABLE `isucondition`.`isu_condition`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT * FROM `isu_condition` WHERE `jia_isu_uuid` = 'a9caa4f5-4fd2-4df4-bd9c-e18691fc5d19' AND `timestamp` < '2021-08-15 02:05:26' ORDER BY `timestamp` DESC\G
# Query 4: 128.06 QPS, 0.55x concurrency, ID 0xFFFCA4D67EA0A788813031B8BBC3B329 at byte 109660468
# Scores: V/M = 0.01
# Time range: 2021-08-21 11:34:41 to 11:35:45
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 2 8196
# Exec time 3 35s 5us 213ms 4ms 13ms 6ms 2ms
# 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
# Rows affecte 0 0 0 0 0 0 0 0
# Bytes sent 0 88.04k 11 11 11 11 0 11
# Query size 0 48.02k 6 6 6 6 0 6
# String:
# Databases isucondition
# Hosts isuconditi... (2788/34%)... 2 more
# Users isucon
# Query_time distribution
# 1us #
# 10us ##
# 100us ##
# 1ms ################################################################
# 10ms #####
# 100ms #
# 1s
# 10s+
COMMIT\G
# Query 5: 3.67 QPS, 0.43x concurrency, ID 0x5F580A12ADA1633C9634298BE5BD9422 at byte 60634657
# Scores: V/M = 0.07
# Time range: 2021-08-21 11:34:42 to 11:35:25
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 158
# Exec time 1 19s 528us 370ms 118ms 279ms 92ms 95ms
# Lock time 0 3ms 8us 698us 19us 26us 56us 11us
# Rows sent 8 82.29k 10 1.13k 533.30 1.09k 366.45 563.87
# Rows examine 2 4.35M 868 55.79k 28.16k 51.46k 18.87k 35.70k
# Rows affecte 0 0 0 0 0 0 0 0
# Bytes sent 4 12.68M 1.94k 161.07k 82.16k 150.54k 56.25k 92.42k
# Query size 0 17.90k 116 116 116 116 0 116
# String:
# Databases isucondition
# Hosts isuconditi... (54/34%), isuconditi... (52/32%)... 1 more
# Users isucon
# Query_time distribution
# 1us
# 10us
# 100us ###
# 1ms #############
# 10ms ##########################################
# 100ms ################################################################
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `isucondition` LIKE 'isu_condition'\G
# SHOW CREATE TABLE `isucondition`.`isu_condition`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT * FROM `isu_condition` WHERE `jia_isu_uuid` = 'bd271df4-deb9-4edb-bd67-cd45e5cd3262' ORDER BY `timestamp` ASC\G
motemen commented
ssh isu03 sudo pt-query-digest /tmp/mysql-slow.log
# 44.4s user time, 80ms system time, 31.72M rss, 38.76M vsz
# Current date: Sat Aug 21 12:27:07 2021
# Hostname: ip-192-168-0-13
# Files: /tmp/mysql-slow.log
# Overall: 585.69k total, 27 unique, 9.60k QPS, 5.00x concurrency ________
# Time range: 2021-08-21 12:21:54 to 12:22:55
# Attribute total min max avg 95% stddev median
# ============ ======= ======= ======= ======= ======= ======= =======
# Exec time 305s 0 209ms 520us 1ms 4ms 36us
# Lock time 11s 0 47ms 18us 17us 348us 0
# Rows sent 4.19M 0 1.65k 7.50 0.99 78.11 0
# Rows examine 4.05M 0 1.65k 7.24 0.99 78.02 0
# Rows affecte 76.76k 0 10 0.13 0 1.13 0
# Bytes sent 2.58G 0 255.81k 4.61k 22.45k 19.96k 92.72
# Query size 41.85M 6 146.57k 74.93 124.25 374.47 31.70
# Boolean:
# QC hit 16% yes, 83% no
# Profile
# Rank Query ID Response time Calls R/Call V/M Item
# ==== ============================ ============= ====== ====== ===== ====
# 1 0x9C6C682008AE0D08F3E2A00... 96.9326 31.8% 4826 0.0201 0.04 SELECT isu_condition
# 2 0xAC9E2250E1642BFE9823A9B... 50.0805 16.4% 58891 0.0009 0.01 SELECT isu_condition
# 3 0xFFFCA4D67EA0A788813031B... 49.0599 16.1% 12179 0.0040 0.01 COMMIT
# 4 0xDA556F9115773A1A99AA016... 34.0175 11.2% 181664 0.0002 0.01 ADMIN PREPARE
# 5 0x5F580A12ADA1633C9634298... 25.8144 8.5% 1644 0.0157 0.04 SELECT isu_condition
# 6 0xB8B32624C3268C0925657C3... 13.8685 4.5% 7855 0.0018 0.01 INSERT isu_condition
# 7 0x8155B89FFD74A9D523D19AC... 11.3783 3.7% 15730 0.0007 0.01 SELECT isu_condition
# 8 0x8C2BC651CBBBF3DB41D1CAD... 5.9823 2.0% 18525 0.0003 0.01 SELECT isu
# 9 0xADCA4F127A769A45A2D1B74... 5.7188 1.9% 33044 0.0002 0.01 SELECT user
# MISC 0xMISC 12.0111 3.9% 251329 0.0000 0.0 <18 ITEMS>
# Query 1: 79.11 QPS, 1.59x concurrency, ID 0x9C6C682008AE0D08F3E2A0049B030C70 at byte 184033317
# Scores: V/M = 0.04
# Time range: 2021-08-21 12:21:54 to 12:22:55
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 4826
# Exec time 31 97s 93us 209ms 20ms 87ms 29ms 7ms
# Lock time 4 473ms 7us 24ms 98us 119us 741us 13us
# Rows sent 71 3.00M 0 1.64k 650.87 1.26k 402.88 592.07
# Rows examine 74 3.00M 0 1.64k 650.87 1.26k 402.88 592.07
# Rows affecte 0 0 0 0 0 0 0 0
# Bytes sent 16 445.63M 589 248.04k 94.56k 192.13k 58.36k 88.02k
# Query size 1 739.92k 148 157 157.00 151.03 0.10 151.03
# String:
# Databases isucondition
# Hosts isuconditi... (1685/34%)... 2 more
# Users isucon
# Query_time distribution
# 1us
# 10us #
# 100us ################
# 1ms ################################################################
# 10ms #######################################################
# 100ms #####
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `isucondition` LIKE 'isu_condition'\G
# SHOW CREATE TABLE `isucondition`.`isu_condition`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT * FROM `isu_condition` WHERE `jia_isu_uuid` = 'ce8929b7-fa15-4295-8ca2-64e009becc63' AND `timestamp` < '2021-08-26 12:54:37' ORDER BY `timestamp` DESC\G
# Query 2: 965.43 QPS, 0.82x concurrency, ID 0xAC9E2250E1642BFE9823A9B9ECA1A419 at byte 122873462
# Scores: V/M = 0.01
# Time range: 2021-08-21 12:21:54 to 12:22:55
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 10 58891
# Exec time 16 50s 8us 76ms 850us 4ms 3ms 125us
# Lock time 62 7s 0 47ms 112us 119us 894us 11us
# Rows sent 1 56.99k 0 1 0.99 0.99 0.09 0.99
# Rows examine 1 53.22k 0 1 0.93 0.99 0.26 0.99
# Rows affecte 0 0 0 0 0 0 0 0
# Bytes sent 1 41.34M 589 789 736.08 755.64 18.12 719.66
# Query size 16 6.91M 123 123 123 123 0 123
# Boolean:
# QC hit 6% yes, 93% no
# String:
# Databases isucondition
# Hosts isuconditi... (21854/37%)... 2 more
# Users isucon
# Query_time distribution
# 1us #
# 10us ################
# 100us ################################################################
# 1ms ##########
# 10ms #
# 100ms
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `isucondition` LIKE 'isu_condition'\G
# SHOW CREATE TABLE `isucondition`.`isu_condition`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT * FROM `isu_condition` WHERE `jia_isu_uuid` = '8469e6f6-0d29-4052-87cf-dd9bfde45014' ORDER BY timestamp DESC LIMIT 1\G
# Query 3: 199.66 QPS, 0.80x concurrency, ID 0xFFFCA4D67EA0A788813031B8BBC3B329 at byte 175030419
# Scores: V/M = 0.01
# Time range: 2021-08-21 12:21:54 to 12:22:55
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 2 12179
# Exec time 16 49s 3us 72ms 4ms 15ms 6ms 2ms
# 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
# Rows affecte 0 0 0 0 0 0 0 0
# Bytes sent 0 130.83k 11 11 11 11 0 11
# Query size 0 71.36k 6 6 6 6 0 6
# String:
# Databases isucondition
# Hosts isuconditi... (4072/33%)... 2 more
# Users isucon
# Query_time distribution
# 1us ##############
# 10us #####################
# 100us ###
# 1ms ################################################################
# 10ms ###########
# 100ms
# 1s
# 10s+
COMMIT\G
# Query 4: 2.98k QPS, 0.56x concurrency, ID 0xDA556F9115773A1A99AA0165670CE848 at byte 171139150
# Scores: V/M = 0.01
# Time range: 2021-08-21 12:21:54 to 12:22:55
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 31 181664
# Exec time 11 34s 18us 68ms 187us 424us 1ms 54us
# 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
# Rows affecte 0 0 0 0 0 0 0 0
# Bytes sent 2 79.07M 52 1.34k 456.42 652.75 306.54 563.87
# Query size 12 5.20M 30 30 30 30 0 30
# String:
# Databases isucondition
# Hosts isuconditi... (63395/34%)... 2 more
# Users isucon
# Query_time distribution
# 1us
# 10us ################################################################
# 100us ###########
# 1ms #
# 10ms #
# 100ms
# 1s
# 10s+
administrator command: Prepare\G
# Query 5: 26.95 QPS, 0.42x concurrency, ID 0x5F580A12ADA1633C9634298BE5BD9422 at byte 197709227
# Scores: V/M = 0.04
# Time range: 2021-08-21 12:21:54 to 12:22:55
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 1644
# Exec time 8 26s 12us 174ms 16ms 68ms 24ms 5ms
# Lock time 1 152ms 0 26ms 92us 103us 837us 12us
# Rows sent 23 989.57k 6 1.65k 616.38 1.33k 414.26 511.45
# Rows examine 23 968.50k 0 1.65k 603.25 1.33k 423.68 511.45
# Rows affecte 0 0 0 0 0 0 0 0
# Bytes sent 5 144.42M 1.50k 255.81k 89.95k 201.74k 60.40k 76.03k
# Query size 0 186.23k 116 116 116 116 0 116
# Boolean:
# QC hit 3% yes, 96% no
# String:
# Databases isucondition
# Hosts isuconditi... (571/34%)... 2 more
# Users isucon
# Query_time distribution
# 1us
# 10us ####
# 100us #################
# 1ms ################################################################
# 10ms #############################################
# 100ms ###
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `isucondition` LIKE 'isu_condition'\G
# SHOW CREATE TABLE `isucondition`.`isu_condition`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT * FROM `isu_condition` WHERE `jia_isu_uuid` = 'edbe335d-06db-4860-88ad-668014b2a44e' ORDER BY `timestamp` ASC\G
# Query 6: 130.92 QPS, 0.23x concurrency, ID 0xB8B32624C3268C0925657C305C0ED778 at byte 190394033
# Scores: V/M = 0.01
# Time range: 2021-08-21 12:21:54 to 12:22:54
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 1 7855
# Exec time 4 14s 89us 74ms 2ms 9ms 5ms 260us
# Lock time 10 1s 15us 19ms 143us 316us 611us 54us
# Rows sent 0 0 0 0 0 0 0 0
# Rows examine 0 0 0 0 0 0 0 0
# Rows affecte 99 76.65k 1 10 9.99 9.83 0.22 9.83
# Bytes sent 0 407.79k 13 54 53.16 51.63 0.61 51.63
# Query size 27 11.64M 235 2.01k 1.52k 1.69k 101.07 1.46k
# String:
# Databases isucondition
# Hosts isuconditi... (2637/33%)... 2 more
# Users isucon
# Query_time distribution
# 1us
# 10us #
# 100us ################################################################
# 1ms ##############
# 10ms ###
# 100ms
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `isucondition` LIKE 'isu_condition'\G
# SHOW CREATE TABLE `isucondition`.`isu_condition`\G
INSERT INTO `isu_condition` (`jia_isu_uuid`, `timestamp`, `is_sitting`, `condition`, `message`) VALUES ('f4c59d7c-9d9d-40ec-9c76-9573e5e1443b','2021-08-29 09:47:11',0,'is_dirty=false,is_overweight=false,is_broken=true','い、痛くないから！'),('f4c59d7c-9d9d-40ec-9c76-9573e5e1443b','2021-08-29 09:48:12',0,'is_dirty=false,is_overweight=false,is_broken=true','い、痛くないから！'),('f4c59d7c-9d9d-40ec-9c76-9573e5e1443b','2021-08-29 09:49:09',0,'is_dirty=false,is_overweight=false,is_broken=true','い、痛くないから！'),('f4c59d7c-9d9d-40ec-9c76-9573e5e1443b','2021-08-29 09:50:14',0,'is_dirty=false,is_overweight=false,is_broken=true','い、痛くないから！'),('f4c59d7c-9d9d-40ec-9c76-9573e5e1443b','2021-08-29 09:51:10',1,'is_dirty=false,is_overweight=false,is_broken=true','い、痛くないから！'),('f4c59d7c-9d9d-40ec-9c76-9573e5e1443b','2021-08-29 09:52:11',1,'is_dirty=false,is_overweight=false,is_broken=true','い、痛くないから！'),('f4c59d7c-9d9d-40ec-9c76-9573e5e1443b','2021-08-29 09:53:18',1,'is_dirty=false,is_overweight=false,is_broken=true','い、痛くないから！'),('f4c59d7c-9d9d-40ec-9c76-9573e5e1443b','2021-08-29 09:54:18',1,'is_dirty=false,is_overweight=false,is_broken=true','い、痛くないから！'),('f4c59d7c-9d9d-40ec-9c76-9573e5e1443b','2021-08-29 09:55:12',1,'is_dirty=false,is_overweight=false,is_broken=true','い、痛くないから！'),('f4c59d7c-9d9d-40ec-9c76-9573e5e1443b','2021-08-29 09:56:18',1,'is_dirty=false,is_overweight=false,is_broken=true','い、痛くないから！')\G
# Query 7: 262.17 QPS, 0.19x concurrency, ID 0x8155B89FFD74A9D523D19AC409FD97AF at byte 117777303
# Scores: V/M = 0.01
# Time range: 2021-08-21 12:21:54 to 12:22:54
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 2 15730
# Exec time 3 11s 13us 52ms 723us 4ms 2ms 119us
# Lock time 18 2s 0 46ms 123us 138us 975us 12us
# Rows sent 0 15.21k 0 1 0.99 0.99 0.10 0.99
# Rows examine 0 15.20k 0 1 0.99 0.99 0.10 0.99
# Rows affecte 0 0 0 0 0 0 0 0
# Bytes sent 0 11.04M 589 789 735.77 719.66 16.98 719.66
# Query size 4 1.88M 125 125 125 125 0 125
# Boolean:
# QC hit 0% yes, 99% no
# String:
# Databases isucondition
# Hosts isuconditi... (5318/33%)... 2 more
# Users isucon
# Query_time distribution
# 1us
# 10us ####################
# 100us ################################################################
# 1ms ########
# 10ms #
# 100ms
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `isucondition` LIKE 'isu_condition'\G
# SHOW CREATE TABLE `isucondition`.`isu_condition`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT * FROM `isu_condition` WHERE `jia_isu_uuid` = '61b452e6-8314-460e-b2ca-fd07dd415b7c' ORDER BY `timestamp` DESC LIMIT 1\G
# Query 8: 303.69 QPS, 0.10x concurrency, ID 0x8C2BC651CBBBF3DB41D1CAD61AA0BD68 at byte 133724469
# Scores: V/M = 0.01
# Time range: 2021-08-21 12:21:54 to 12:22:55
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 3 18525
# Exec time 1 6s 9us 62ms 322us 925us 2ms 52us
# Lock time 0 42ms 0 8ms 2us 0 79us 0
# Rows sent 1 57.51k 1 7 3.18 5.75 1.42 2.90
# Rows examine 0 29.45k 0 82 1.63 0 10.14 0
# Rows affecte 0 0 0 0 0 0 0 0
# Bytes sent 47 1.21G 5.44k 181.45k 68.57k 165.97k 41.57k 62.55k
# Query size 2 983.42k 51 57 54.36 56.92 2.95 51.63
# Boolean:
# QC hit 97% yes, 2% no
# String:
# Databases isucondition
# Hosts isuconditi... (6850/36%)... 2 more
# Users isucon
# Query_time distribution
# 1us #
# 10us ################################################################
# 100us ###############
# 1ms ###
# 10ms #
# 100ms
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `isucondition` LIKE 'isu'\G
# SHOW CREATE TABLE `isucondition`.`isu`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT * FROM `isu` WHERE `character` = 'おっとり'\G
# Query 9: 550.73 QPS, 0.10x concurrency, ID 0xADCA4F127A769A45A2D1B74705103105 at byte 170231536
# Scores: V/M = 0.01
# Time range: 2021-08-21 12:21:54 to 12:22:54
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 5 33044
# Exec time 1 6s 5us 78ms 173us 384us 1ms 16us
# Lock time 0 13ms 0 5ms 0 0 33us 0
# Rows sent 0 32.27k 1 1 1 1 0 1
# Rows examine 0 42 0 1 0.00 0 0.04 0
# Rows affecte 0 0 0 0 0 0 0 0
# Bytes sent 0 2.24M 71 71 71 71 0 71
# Query size 4 2.07M 58 74 65.62 72.65 4.57 65.89
# Boolean:
# QC hit 99% yes, 0% no
# String:
# Databases isucondition
# Hosts isuconditi... (11055/33%)... 2 more
# Users isucon
# Query_time distribution
# 1us #
# 10us ################################################################
# 100us ####
# 1ms #
# 10ms #
# 100ms
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `isucondition` LIKE 'user'\G
# SHOW CREATE TABLE `isucondition`.`user`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT COUNT(*) FROM `user` WHERE `jia_user_id` = 'zen_elion'\G
motemen commented
motemen commented
toricls commented
motemen commented
motemen commented
いつのかわかんねえけどけど最新 間違ってそう
