txxxxc
commented
3 months ago Open txxxxc opened 3 months ago
txxxxc
commented
3 months ago txxxxc
commented
3 months ago # 24.2s user time, 130ms system time, 35.12M rss, 42.33M vsz
# Current date: Sat May 25 23:52:30 2024
# Hostname: ip-10-0-1-227
# Files: /var/log/mysql/slow-query.log
# Overall: 170.78k total, 98 unique, 424.82 QPS, 0.59x concurrency _______
# Time range: 2024-05-25 23:38:51 to 23:45:33
# Attribute total min max avg 95% stddev median
# ============ ======= ======= ======= ======= ======= ======= =======
# Exec time 237s 1us 569ms 1ms 4ms 14ms 42us
# Lock time 4s 0 53ms 21us 18us 336us 0
# Rows sent 78.39k 0 1.16k 0.47 0 19.21 0
# Rows examine 21.78M 0 46.91k 133.72 0 2.15k 0
# Rows affecte 45.90k 0 618 0.28 0.99 1.50 0
# Bytes sent 46.07M 0 233.94k 282.87 158.58 4.61k 12.54
# Query size 22.62M 6 790.36k 138.91 258.32 2.22k 31.70
# Boolean:
# QC hit 3% yes, 96% no
# Profile
# Rank Query ID Response time Calls R/Call V/M Ite
# ==== ============================= ============== ===== ====== ===== ===
# 1 0x8155B89FFD74A9D523D19AC4... 114.6834 48.3% 606 0.1892 0.07 SELECT isu_condition
# 2 0xDA556F9115773A1A99AA0165... 41.2035 17.4% 53510 0.0008 0.00 ADMIN PREPARE
# 3 0xFFFCA4D67EA0A788813031B8... 31.1264 13.1% 4814 0.0065 0.01 COMMIT
# 4 0xB8B32624C3268C0925657C30... 27.4380 11.6% 46227 0.0006 0.01 INSERT isu_condition
# 5 0x931A992E852C61FC6D46141A... 14.2199 6.0% 383 0.0371 0.15 SELECT isu_condition
# MISC 0xMISC 8.6637 3.7% 65236 0.0001 0.0 <93 ITEMS>
# Query 1: 8.66 QPS, 1.64x concurrency, ID 0x8155B89FFD74A9D523D19AC409FD97AF at byte 49586069
# Scores: V/M = 0.07
# Time range: 2024-05-25 23:44:23 to 23:45:33
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 606
# Exec time 48 115s 301us 569ms 189ms 374ms 113ms 180ms
# Lock time 1 48ms 9us 21ms 78us 31us 890us 13us
# Rows sent 0 606 1 1 1 1 0 1
# Rows examine 85 18.51M 619 45.75k 31.28k 44.45k 12.25k 34.83k
# Rows affecte 0 0 0 0 0 0 0 0
# Bytes sent 0 438.90k 720 763 741.64 719.66 3.25 719.66
# Query size 0 73.97k 125 125 125 125 0 125
# String:
# Databases isucondition
# Hosts localhost
# 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` = '3fece690-93e2-42cc-b190-91816228a83e' ORDER BY `timestamp` DESC LIMIT 1\G
# Query 2: 723.11 QPS, 0.56x concurrency, ID 0xDA556F9115773A1A99AA0165670CE848 at byte 29684118
# Scores: V/M = 0.00
# Time range: 2024-05-25 23:44:19 to 23:45:33
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 31 53510
# Exec time 17 41s 25us 53ms 770us 4ms 2ms 76us
# 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 18 8.46M 52 681 165.75 158.58 76.55 158.58
# Query size 6 1.53M 30 30 30 30 0 30
# String:
# Databases isucondition
# Hosts localhost
# Users isucon
# Query_time distribution
# 1us
# 10us ################################################################
# 100us ##################################
# 1ms ########################
# 10ms #
# 100ms
# 1s
# 10s+
administrator command: Prepare\G
# Query 3: 69.77 QPS, 0.45x concurrency, ID 0xFFFCA4D67EA0A788813031B8BBC3B329 at byte 27763568
# Scores: V/M = 0.01
# Time range: 2024-05-25 23:44:24 to 23:45:33
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 2 4814
# Exec time 13 31s 9us 119ms 6ms 15ms 6ms 5ms
# 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 51.71k 11 11 11 11 0 11
# Query size 0 28.21k 6 6 6 6 0 6
# String:
# Databases isucondition
# Hosts localhost
# Users isucon
# Query_time distribution
# 1us #
# 10us #
# 100us #
# 1ms ################################################################
# 10ms ############
# 100ms #
# 1s
# 10s+
COMMIT\G
# Query 4: 679.81 QPS, 0.40x concurrency, ID 0xB8B32624C3268C0925657C305C0ED778 at byte 52998785
# Scores: V/M = 0.01
# Time range: 2024-05-25 23:44:24 to 23:45:32
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 27 46227
# Exec time 11 27s 32us 62ms 593us 4ms 2ms 49us
# Lock time 74 3s 7us 27ms 59us 36us 392us 14us
# Rows sent 0 0 0 0 0 0 0 0
# Rows examine 0 0 0 0 0 0 0 0
# Rows affecte 98 45.14k 1 1 1 1 0 1
# Bytes sent 1 586.87k 13 13 13 13 0 13
# Query size 50 11.34M 233 302 257.11 271.23 13.68 246.02
# String:
# Databases isucondition
# Hosts localhost
# 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 ('f2e3d11d-81de-451f-84dc-181563d643fa', '2021-08-29 07:23:16', 1, 'is_dirty=true,is_overweight=true,is_broken=true', 'いっしょにいたくないの...')\G
# Query 5: 5.55 QPS, 0.21x concurrency, ID 0x931A992E852C61FC6D46141A39DEF4FE at byte 40426401
# Scores: V/M = 0.15
# Time range: 2024-05-25 23:44:24 to 23:45:33
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 383
# Exec time 5 14s 14us 489ms 37ms 189ms 74ms 3ms
# Lock time 0 8ms 0 2ms 21us 26us 119us 13us
# Rows sent 89 70.07k 0 1.16k 187.35 1012.63 361.73 11.95
# Rows examine 14 3.24M 0 46.91k 8.67k 46.68k 16.42k 685.39
# Rows affecte 0 0 0 0 0 0 0 0
# Bytes sent 23 10.86M 589 184.73k 29.05k 158.07k 55.42k 2.27k
# Query size 0 43.01k 115 115 115 115 0 115
# Boolean:
# QC hit 26% yes, 73% no
# String:
# Databases isucondition
# Hosts localhost
# 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` = '4e17de87-3c96-4508-8a84-31d7c40bd962' ORDER BY timestamp DESC\G# 25.4s user time, 150ms system time, 35.05M rss, 42.09M vsz
# Current date: Mon May 27 21:14:12 2024
# Hostname: ip-10-0-1-227
# Files: /var/log/mysql/slow-query.log
# Overall: 180.21k total, 99 unique, 650.56 QPS, 0.40x concurrency _______
# Time range: 2024-05-27 21:06:40 to 21:11:17
# Attribute total min max avg 95% stddev median
# ============ ======= ======= ======= ======= ======= ======= =======
# Exec time 110s 0 150ms 607us 3ms 3ms 42us
# Lock time 3s 0 27ms 14us 18us 220us 0
# Rows sent 75.65k 0 1.23k 0.43 0 18.83 0
# Rows examine 788.78k 0 2.47k 4.48 0 64.67 0
# Rows affecte 48.17k 0 618 0.27 0.99 1.46 0
# Bytes sent 61.93M 0 646.20k 360.36 158.58 5.90k 12.54
# Query size 19.98M 6 790.36k 116.28 271.23 2.01k 31.70
# Boolean:
# QC hit 3% yes, 96% no
# Profile
# Rank Query ID Response time Calls R/Call V/M Item
# ==== ============================= ============= ===== ====== ===== ====
# 1 0xFFFCA4D67EA0A788813031B8... 30.8256 28.1% 5103 0.0060 0.00 COMMIT
# 2 0xDA556F9115773A1A99AA0165... 29.0070 26.5% 56564 0.0005 0.00 ADMIN PREPARE
# 3 0xB8B32624C3268C0925657C30... 22.6585 20.7% 48552 0.0005 0.00 INSERT isu_condition
# 4 0x8155B89FFD74A9D523D19AC4... 18.3684 16.8% 974 0.0189 0.03 SELECT isu_condition
# 5 0x931A992E852C61FC6D46141A... 3.0735 2.8% 387 0.0079 0.04 SELECT isu_condition
# 6 0x1E561CE87F050ED58A7E1A7F... 1.8423 1.7% 4861 0.0004 0.00 SELECT isu
# MISC 0xMISC 3.7757 3.4% 63764 0.0001 0.0 <93 ITEMS>
# Query 1: 76.16 QPS, 0.46x concurrency, ID 0xFFFCA4D67EA0A788813031B8BBC3B329 at byte 62443117
# Scores: V/M = 0.00
# Time range: 2024-05-27 21:09:49 to 21:10:56
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 2 5103
# Exec time 28 31s 8us 74ms 6ms 14ms 5ms 4ms
# 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 54.82k 11 11 11 11 0 11
# Query size 0 29.90k 6 6 6 6 0 6
# String:
# Databases isucondition
# Hosts localhost
# Users isucon
# Query_time distribution
# 1us #
# 10us #
# 100us #
# 1ms ################################################################
# 10ms ###########
# 100ms
# 1s
# 10s+
COMMIT\G
# Query 2: 796.68 QPS, 0.41x concurrency, ID 0xDA556F9115773A1A99AA0165670CE848 at byte 42384727
# Scores: V/M = 0.00
# Time range: 2024-05-27 21:09:45 to 21:10:56
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 31 56564
# Exec time 26 29s 25us 33ms 512us 3ms 1ms 49us
# 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 14 9.15M 52 681 169.55 158.58 86.35 158.58
# Query size 8 1.62M 30 30 30 30 0 30
# String:
# Databases isucondition
# Hosts localhost
# Users isucon
# Query_time distribution
# 1us
# 10us ################################################################
# 100us #################
# 1ms #############
# 10ms #
# 100ms
# 1s
# 10s+
administrator command: Prepare\G
# Query 3: 735.64 QPS, 0.34x concurrency, ID 0xB8B32624C3268C0925657C305C0ED778 at byte 2059705
# Scores: V/M = 0.00
# Time range: 2024-05-27 21:09:50 to 21:10:56
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 26 48552
# Exec time 20 23s 37us 61ms 466us 3ms 1ms 54us
# Lock time 84 2s 8us 27ms 45us 31us 339us 14us
# Rows sent 0 0 0 0 0 0 0 0
# Rows examine 0 0 0 0 0 0 0 0
# Rows affecte 98 47.41k 1 1 1 1 0 1
# Bytes sent 0 616.38k 13 13 13 13 0 13
# Query size 60 12.00M 233 302 259.09 271.23 12.92 258.32
# String:
# Databases isucondition
# Hosts localhost
# 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 ('75b7a0cb-6ba9-4756-9ad4-336c15533bf4', '2021-08-10 04:29:16', 1, 'is_dirty=true,is_overweight=false,is_broken=false', '汚れちゃいました〜')\G
# Query 4: 14.54 QPS, 0.27x concurrency, ID 0x8155B89FFD74A9D523D19AC409FD97AF at byte 40467361
# Scores: V/M = 0.03
# Time range: 2024-05-27 21:09:49 to 21:10:56
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 974
# Exec time 16 18s 123us 150ms 19ms 56ms 22ms 11ms
# Lock time 2 62ms 9us 21ms 63us 33us 703us 12us
# Rows sent 1 973 0 1 1.00 0.99 0.03 0.99
# Rows examine 86 683.15k 0 1.21k 718.22 1.09k 321.92 755.64
# Rows affecte 0 0 0 0 0 0 0 0
# Bytes sent 1 707.60k 589 765 743.93 755.64 10.49 719.66
# Query size 0 118.90k 125 125 125 125 0 125
# String:
# Databases isucondition
# Hosts localhost
# 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` = '5dfef607-00c0-4d80-ba47-ab31e77e46d8' ORDER BY `timestamp` DESC LIMIT 1\G
# Query 5: 5.86 QPS, 0.05x concurrency, ID 0x931A992E852C61FC6D46141A39DEF4FE at byte 52048711
# Scores: V/M = 0.04
# Time range: 2024-05-27 21:09:50 to 21:10:56
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 387
# Exec time 2 3s 16us 129ms 8ms 59ms 19ms 316us
# Lock time 0 14ms 0 6ms 37us 27us 309us 13us
# Rows sent 87 66.02k 0 1.23k 174.70 1.09k 368.93 11.95
# Rows examine 11 94.54k 0 2.47k 250.17 2.06k 630.31 23.65
# Rows affecte 0 0 0 0 0 0 0 0
# Bytes sent 16 10.34M 589 196.40k 27.35k 182.98k 57.18k 2.27k
# Query size 0 43.46k 115 115 115 115 0 115
# Boolean:
# QC hit 18% yes, 81% no
# String:
# Databases isucondition
# Hosts localhost
# 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` = '51e2e72b-efef-4bb5-bbf6-c439a3bfe0dd' ORDER BY timestamp DESC\G
# Query 6: 73.65 QPS, 0.03x concurrency, ID 0x1E561CE87F050ED58A7E1A7FBB6C2285 at byte 2077257
# Scores: V/M = 0.00
# Time range: 2024-05-27 21:09:50 to 21:10:56
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 2 4861
# Exec time 1 2s 16us 52ms 379us 2ms 1ms 33us
# Lock time 0 13ms 0 2ms 2us 13us 41us 0
# Rows sent 6 4.75k 1 1 1 1 0 1
# Rows examine 0 340 0 1 0.07 0.99 0.25 0
# Rows affecte 0 0 0 0 0 0 0 0
# Bytes sent 0 337.04k 71 71 71 71 0 71
# Query size 2 417.74k 88 88 88 88 0 88
# Boolean:
# QC hit 92% yes, 7% no
# String:
# Databases isucondition
# Hosts localhost
# 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 COUNT(*) FROM `isu` WHERE `jia_isu_uuid` = '2b619de0-ad9f-461c-a013-77a76cd54f51'\G
ファイルディスクリプタ・コネクションの増やした後
# 42.2s user time, 290ms system time, 36.11M rss, 43.17M vsz
# Current date: Sat Jun 1 12:46:59 2024
# Hostname: ip-10-0-1-227
# Files: /var/log/mysql/slow-query.log
# Overall: 302.79k total, 96 unique, 581.17 QPS, 74.71x concurrency ______
# Time range: 2024-06-01 12:25:03 to 12:33:44
# Attribute total min max avg 95% stddev median
# ============ ======= ======= ======= ======= ======= ======= =======
# Exec time 38922s 0 62s 129ms 580ms 429ms 6ms
# Lock time 1550s 0 3s 5ms 9ms 33ms 0
# Rows sent 37.33k 0 2.28k 0.13 0 10.04 0
# Rows examine 44.98k 0 2.28k 0.15 0 10.09 0
# Rows affecte 83.83k 0 618 0.28 0.99 1.17 0
# Bytes sent 29.17M 0 367.50k 101.03 158.58 2.07k 12.54
# Query size 39.94M 6 790.36k 138.32 258.32 2.60k 31.70
# Profile
# Rank Query ID Response time Calls R/Call V/M I
# ==== ============================ ================ ====== ====== ===== =
# 1 0xB8B32624C3268C0925657C3... 28667.3962 73.7% 85062 0.3370 1.19 INSERT isu_condition
# 2 0xDA556F9115773A1A99AA016... 4184.6138 10.8% 95077 0.0440 1.39 ADMIN PREPARE
# 3 0x1E561CE87F050ED58A7E1A7... 3658.9387 9.4% 8578 0.4265 1.00 SELECT isu
# 4 0xFFFCA4D67EA0A788813031B... 1792.0155 4.6% 8398 0.2134 0.82 COMMIT
# 6 0x27AA5037BCA3145593C643E... 100.0010 0.3% 165 0.6061 0.84 INSERT isu
# 7 0xADCA4F127A769A45A2D1B74... 88.6057 0.2% 373 0.2375 1.36 SELECT user
# MISC 0xMISC 430.1373 1.1% 105139 0.0041 0.0 <90 ITEMS>
# Query 1: 183.32 QPS, 61.78x concurrency, ID 0xB8B32624C3268C0925657C305C0ED778 at byte 115843854
# Scores: V/M = 1.19
# Time range: 2024-06-01 12:25:58 to 12:33:42
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 28 85062
# Exec time 73 28667s 35us 60s 337ms 1s 634ms 171ms
# Lock time 89 1389s 7us 2s 16ms 122ms 49ms 15us
# Rows sent 0 0 0 0 0 0 0 0
# Rows examine 0 0 0 0 0 0 0 0
# Rows affecte 99 83.07k 1 1 1 1 0 1
# Bytes sent 3 1.07M 13 14 13.24 13.83 0.50 12.54
# Query size 52 20.78M 233 302 256.13 271.23 16.24 246.02
# String:
# Databases isucondition
# Hosts localhost
# 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 ('d8f30b6c-ab51-46df-b55f-ad9af13b3883', '2021-08-15 01:50:52', 1, 'is_dirty=true,is_overweight=true,is_broken=true', '考えうる限り最悪の状態です')\G
# Query 2: 218.57 QPS, 9.62x concurrency, ID 0xDA556F9115773A1A99AA0165670CE848 at byte 115842499
# Scores: V/M = 1.39
# Time range: 2024-06-01 12:25:53 to 12:33:08
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 31 95077
# Exec time 10 4185s 26us 26s 44ms 219ms 247ms 8ms
# 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 48 14.20M 52 681 156.56 158.58 40.02 158.58
# Query size 6 2.72M 30 30 30 30 0 30
# String:
# Databases isucondition
# Hosts localhost
# Users isucon
# Query_time distribution
# 1us
# 10us ############
# 100us #############
# 1ms ################################################################
# 10ms ###########################################################
# 100ms #####################
# 1s #
# 10s+ #
administrator command: Prepare\G
# Query 3: 24.72 QPS, 10.54x concurrency, ID 0x1E561CE87F050ED58A7E1A7FBB6C2285 at byte 44863957
# Scores: V/M = 1.00
# Time range: 2024-06-01 12:25:58 to 12:31:45
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 2 8578
# Exec time 9 3659s 48us 4s 427ms 2s 652ms 116ms
# Lock time 6 107s 6us 2s 12ms 68ms 73ms 13us
# Rows sent 22 8.38k 1 1 1 1 0 1
# Rows examine 18 8.35k 0 1 1.00 0.99 0.06 0.99
# Rows affecte 0 0 0 0 0 0 0 0
# Bytes sent 1 594.76k 71 71 71 71 0 71
# Query size 1 737.17k 88 88 88 88 0 88
# String:
# Databases isucondition
# Hosts localhost
# 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 COUNT(*) FROM `isu` WHERE `jia_isu_uuid` = '6896be47-11d7-4fc5-adbe-d5e22a85643c'\G
# Query 4: 20.63 QPS, 4.40x concurrency, ID 0xFFFCA4D67EA0A788813031B8BBC3B329 at byte 43110712
# Scores: V/M = 0.82
# Time range: 2024-06-01 12:25:58 to 12:32:45
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 2 8398
# Exec time 4 1792s 10us 3s 213ms 1s 418ms 78ms
# 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 90.21k 11 11 11 11 0 11
# Query size 0 49.21k 6 6 6 6 0 6
# String:
# Databases isucondition
# Hosts localhost
# Users isucon
# Query_time distribution
# 1us
# 10us #
# 100us #
# 1ms #########
# 10ms ################################################################
# 100ms #####################################################
# 1s #######
# 10s+
COMMIT\G
# Query 6: 0.57 QPS, 0.35x concurrency, ID 0x27AA5037BCA3145593C643E21671646B at byte 44149112
# Scores: V/M = 0.84
# Time range: 2024-06-01 12:25:58 to 12:30:46
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 165
# Exec time 0 100s 206us 3s 606ms 2s 712ms 248ms
# Lock time 3 51s 158us 3s 309ms 1s 528ms 20ms
# Rows sent 0 0 0 0 0 0 0 0
# Rows examine 0 0 0 0 0 0 0 0
# Rows affecte 0 35 0 1 0.21 0.99 0.41 0
# Bytes sent 0 11.80k 11 90 73.24 88.31 31.67 88.31
# Query size 28 11.55M 7.12k 201.52k 71.69k 192.13k 63.29k 38.40k
# String:
# Databases isucondition
# Hosts localhost
# 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
INSERT INTO `isu` (`jia_isu_uuid`, `name`, `image`, `jia_user_id`) VALUES ('2e85d92f-f822-4e1c-b124-5c37470356b1', )
# Query 7: 1.30 QPS, 0.31x concurrency, ID 0xADCA4F127A769A45A2D1B74705103105 at byte 44688203
# Scores: V/M = 1.36
# Time range: 2024-06-01 12:25:58 to 12:30:44
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 373
# Exec time 0 89s 46us 4s 238ms 1s 569ms 2ms
# Lock time 0 2s 7us 417ms 6ms 12ms 39ms 13us
# Rows sent 0 373 1 1 1 1 0 1
# Rows examine 0 373 1 1 1 1 0 1
# Rows affecte 0 0 0 0 0 0 0 0
# Bytes sent 0 25.86k 71 71 71 71 0 71
# Query size 0 23.38k 58 75 64.17 72.65 4.89 62.76
# String:
# Databases isucondition
# Hosts localhost
# 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` = 'intelligent_stonebraker'\G
# Attribute total min max avg 95% stddev median
# ============ ======= ======= ======= ======= ======= ======= =======
# Exec time 59s 0 283ms 799us 4ms 3ms 57us
# Lock time 2s 0 283ms 22us 42us 1ms 0
# Rows sent 1.10M 0 1.00k 15.71 11.95 84.24 0
# Rows examine 1.19M 0 1.00k 17.00 76.28 84.59 0
# Rows affecte 41.90k 0 618 0.59 9.83 3.17 0
# Bytes sent 314.75M 0 286.66k 4.40k 24.75k 19.37k 51.63
# Query size 12.37M 6 790.36k 177.25 1.46k 3.15k 31.70
# Profile
# Rank Query ID Response time Calls R/Call V/M Item
# ==== ============================= ============= ===== ====== ===== ====
# 1 0xFFFCA4D67EA0A788813031B8... 24.4137 41.7% 4714 0.0052 0.01 COMMIT
# 2 0x931A992E852C61FC6D46141A... 12.1435 20.7% 3395 0.0036 0.01 SELECT isu_condition
# 3 0xDA556F9115773A1A99AA0165... 4.5253 7.7% 19677 0.0002 0.02 ADMIN PREPARE
# 4 0xB8B32624C3268C0925657C30... 4.0159 6.9% 4222 0.0010 0.01 INSERT isu_condition
# 5 0x8C2BC651CBBBF3DB41D1CAD6... 3.3348 5.7% 1175 0.0028 0.01 SELECT isu
# 6 0x9C6C682008AE0D08F3E2A004... 2.2320 3.8% 633 0.0035 0.01 SELECT isu_condition
# 7 0xADCA4F127A769A45A2D1B747... 2.2222 3.8% 2407 0.0009 0.02 SELECT user
# 8 0x5F580A12ADA1633C9634298B... 0.9244 1.6% 306 0.0030 0.01 SELECT isu_condition
# 9 0x27AA5037BCA3145593C643E2... 0.8586 1.5% 54 0.0159 0.12 INSERT isu
# 10 0xB5F4855605637317357023AD... 0.8310 1.4% 872 0.0010 0.01 SELECT isu
# 11 0x1E561CE87F050ED58A7E1A7F... 0.7643 1.3% 4226 0.0002 0.01 SELECT isu
# MISC 0xMISC 2.2634 3.9% 31490 0.0001 0.0 <84 ITEMS>
# Query 1: 78.57 QPS, 0.41x concurrency, ID 0xFFFCA4D67EA0A788813031B8BBC3B329 at byte 8888209
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.01
# Time range: 2024-06-10 01:03:36 to 01:04:36
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 6 4714
# Exec time 41 24s 8us 50ms 5ms 15ms 5ms 3ms
# 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 50.64k 11 11 11 11 0 11
# Query size 0 27.62k 6 6 6 6 0 6
# String:
# Databases isucondition
# Hosts localhost
# Users isucon
# Query_time distribution
# 1us #
# 10us ####
# 100us ###
# 1ms ################################################################
# 10ms #########
# 100ms
# 1s
# 10s+
COMMIT\G
# Query 2: 55.66 QPS, 0.20x concurrency, ID 0x931A992E852C61FC6D46141A39DEF4FE at byte 17824591
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.01
# Time range: 2024-06-10 01:03:36 to 01:04:37
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 4 3395
# Exec time 20 12s 84us 74ms 4ms 16ms 6ms 1ms
# Lock time 8 142ms 10us 32ms 41us 28us 650us 13us
# Rows sent 70 791.67k 0 1.00k 238.78 685.39 239.17 158.58
# Rows examine 65 791.67k 0 1.00k 238.78 685.39 239.17 158.58
# Rows affecte 0 0 0 0 0 0 0 0
# Bytes sent 39 124.02M 589 168.14k 37.41k 106.99k 37.49k 23.58k
# Query size 3 381.27k 115 115 115 115 0 115
# String:
# Databases isucondition
# Hosts localhost
# 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` = '8414926e-18f2-4828-acef-ce8656a0134c' ORDER BY timestamp DESC\G
# Query 3: 298.14 QPS, 0.07x concurrency, ID 0xDA556F9115773A1A99AA0165670CE848 at byte 1838262
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.02
# Time range: 2024-06-10 01:03:31 to 01:04:37
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 26 19677
# Exec time 7 5s 28us 168ms 229us 403us 2ms 66us
# 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 3 10.29M 52 1.34k 548.60 1.33k 479.70 537.02
# Query size 4 576.47k 30 30 30 30 0 30
# String:
# Databases isucondition
# Hosts localhost
# Users isucon
# Query_time distribution
# 1us
# 10us ################################################################
# 100us ########
# 1ms ##
# 10ms #
# 100ms #
# 1s
# 10s+
administrator command: Prepare\G
# Query 4: 71.56 QPS, 0.07x concurrency, ID 0xB8B32624C3268C0925657C305C0ED778 at byte 8315881
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.01
# Time range: 2024-06-10 01:03:37 to 01:04:36
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 5 4222
# Exec time 6 4s 80us 39ms 951us 4ms 3ms 224us
# Lock time 23 384ms 22us 13ms 90us 84us 372us 47us
# Rows sent 0 0 0 0 0 0 0 0
# Rows examine 0 0 0 0 0 0 0 0
# Rows affecte 98 41.13k 1 10 9.98 9.83 0.37 9.83
# Bytes sent 0 218.46k 13 53 52.99 51.63 0.60 51.63
# Query size 55 6.83M 254 2.05k 1.66k 1.86k 149.90 1.61k
# String:
# Databases isucondition
# Hosts localhost
# 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 ('59738687-f042-4bc5-aa6c-3df947341dac', '2021-08-13 13:14:41', 0, 'is_dirty=false,is_overweight=false,is_broken=true', 'あれ、壊れてる！？'),('59738687-f042-4bc5-aa6c-3df947341dac', '2021-08-13 13:15:32', 0, 'is_dirty=false,is_overweight=false,is_broken=true', 'あれ、壊れてる！？'),('59738687-f042-4bc5-aa6c-3df947341dac', '2021-08-13 13:16:33', 0, 'is_dirty=false,is_overweight=false,is_broken=true', 'あれ、壊れてる！？'),('59738687-f042-4bc5-aa6c-3df947341dac', '2021-08-13 13:17:41', 0, 'is_dirty=false,is_overweight=false,is_broken=true', 'あれ、壊れてる！？'),('59738687-f042-4bc5-aa6c-3df947341dac', '2021-08-13 13:18:32', 0, 'is_dirty=false,is_overweight=false,is_broken=true', 'あれ、壊れてる！？'),('59738687-f042-4bc5-aa6c-3df947341dac', '2021-08-13 13:19:35', 1, 'is_dirty=false,is_overweight=false,is_broken=true', 'あれ、壊れてる！？'),('59738687-f042-4bc5-aa6c-3df947341dac', '2021-08-13 13:20:41', 1, 'is_dirty=false,is_overweight=false,is_broken=true', 'あれ、壊れてる！？'),('59738687-f042-4bc5-aa6c-3df947341dac', '2021-08-13 13:21:42', 1, 'is_dirty=false,is_overweight=false,is_broken=true', 'あれ、壊れてる！？'),('59738687-f042-4bc5-aa6c-3df947341dac', '2021-08-13 13:22:36', 1, 'is_dirty=false,is_overweight=false,is_broken=true', 'あれ、壊れてる！？'),('59738687-f042-4bc5-aa6c-3df947341dac', '2021-08-13 13:23:32', 1, 'is_dirty=false,is_overweight=false,is_broken=true', 'あれ、壊れてる！？')\G
# Query 5: 19.26 QPS, 0.05x concurrency, ID 0x8C2BC651CBBBF3DB41D1CAD61AA0BD68 at byte 13666406
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.01
# Time range: 2024-06-10 01:03:36 to 01:04:37
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 1 1175
# Exec time 5 3s 153us 58ms 3ms 14ms 6ms 626us
# Lock time 1 24ms 7us 3ms 20us 22us 96us 13us
# Rows sent 0 3.32k 1 9 2.89 6.98 1.92 1.96
# Rows examine 6 82.35k 28 79 71.77 76.28 15.10 76.28
# Rows affecte 0 0 0 0 0 0 0 0
# Bytes sent 26 84.77M 5.44k 237.71k 73.88k 222.42k 62.65k 54.03k
# Query size 0 62.38k 51 57 54.36 56.92 2.95 51.63
# String:
# Databases isucondition
# Hosts localhost
# 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 6: 10.55 QPS, 0.04x concurrency, ID 0x9C6C682008AE0D08F3E2A0049B030C70 at byte 30789108
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.01
# Time range: 2024-06-10 01:03:36 to 01:04:36
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 633
# Exec time 3 2s 134us 53ms 4ms 16ms 6ms 1ms
# Lock time 1 18ms 11us 3ms 29us 28us 153us 14us
# Rows sent 14 157.66k 0 1.00k 255.04 592.07 187.24 212.52
# Rows examine 12 157.66k 0 1.00k 255.04 592.07 187.24 212.52
# Rows affecte 0 0 0 0 0 0 0 0
# Bytes sent 7 24.74M 589 166.95k 40.02k 97.04k 30.21k 31.59k
# Query size 0 97.05k 157 157 157 157 0 157
# String:
# Databases isucondition
# Hosts localhost
# 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` = '7c4d051b-8b8d-4ff0-b0d4-d83465f7eca4' AND `timestamp` < '2021-08-30 19:28:55' ORDER BY `timestamp` DESC\G
# Query 7: 40.12 QPS, 0.04x concurrency, ID 0xADCA4F127A769A45A2D1B74705103105 at byte 8319242
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.02
# Time range: 2024-06-10 01:03:36 to 01:04:36
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 3 2407
# Exec time 3 2s 47us 39ms 923us 4ms 4ms 76us
# Lock time 5 98ms 9us 7ms 40us 31us 296us 15us
# Rows sent 0 2.35k 1 1 1 1 0 1
# Rows examine 0 2.35k 1 1 1 1 0 1
# Rows affecte 0 0 0 0 0 0 0 0
# Bytes sent 0 166.89k 71 71 71 71 0 71
# Query size 1 155.32k 58 72 66.08 69.19 4.05 65.89
# String:
# Databases isucondition
# Hosts localhost
# 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` = 'isucon'\G
# Query 8: 5.10 QPS, 0.02x concurrency, ID 0x5F580A12ADA1633C9634298BE5BD9422 at byte 22910972
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.01
# Time range: 2024-06-10 01:03:36 to 01:04:36
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 306
# Exec time 1 924ms 107us 32ms 3ms 13ms 5ms 2ms
# Lock time 0 5ms 10us 300us 15us 23us 16us 13us
# Rows sent 14 158.61k 6 900 530.77 874.75 215.74 563.87
# Rows examine 13 158.61k 6 900 530.77 874.75 215.74 563.87
# Rows affecte 0 0 0 0 0 0 0 0
# Bytes sent 7 24.70M 1.48k 152.86k 82.66k 143.37k 35.52k 83.83k
# Query size 0 34.66k 116 116 116 116 0 116
# String:
# Databases isucondition
# Hosts localhost
# 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` = '16030f58-f560-4586-83be-be92df376918' ORDER BY `timestamp` ASC\G
# Query 9: 10.80 QPS, 0.17x concurrency, ID 0x27AA5037BCA3145593C643E21671646B at byte 2906068
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.12
# Time range: 2024-06-10 01:03:36 to 01:03:41
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 54
# Exec time 1 859ms 137us 283ms 16ms 40ms 44ms 725us
# Lock time 45 758ms 86us 283ms 14ms 38ms 45ms 568us
# Rows sent 0 0 0 0 0 0 0 0
# Rows examine 0 0 0 0 0 0 0 0
# Rows affecte 0 52 0 1 0.96 0.99 0.19 0.99
# Bytes sent 0 752 11 90 13.93 10.84 14.63 10.84
# Query size 14 1.81M 7.13k 201.52k 34.37k 117.95k 37.81k 23.58k
# String:
# Databases isucondition
# Hosts localhost
# 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
INSERT INTO `isu` (`jia_isu_uuid`, `name`, `image`, `jia_user_id`) VALUES ....
# Query 10: 14.53 QPS, 0.01x concurrency, ID 0xB5F4855605637317357023AD70B91455 at byte 23948603
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.01
# Time range: 2024-06-10 01:03:36 to 01:04:36
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 1 872
# Exec time 1 831ms 60us 38ms 952us 4ms 4ms 119us
# Lock time 1 25ms 9us 3ms 28us 31us 145us 14us
# Rows sent 0 846 0 1 0.97 0.99 0.17 0.99
# Rows examine 0 846 0 1 0.97 0.99 0.17 0.99
# Rows affecte 0 0 0 0 0 0 0 0
# Bytes sent 6 20.82M 77 132.17k 24.45k 88.02k 25.69k 17.59k
# Query size 0 105.71k 116 130 124.14 124.25 4.26 124.25
# String:
# Databases isucondition
# Hosts localhost
# 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 `image` FROM `isu` WHERE `jia_user_id` = 'cranky_brown' AND `jia_isu_uuid` = 'd6d59d93-68bc-4970-99ea-7d0feceb9385'\G
# Query 11: 70.43 QPS, 0.01x concurrency, ID 0x1E561CE87F050ED58A7E1A7FBB6C2285 at byte 13658154
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.01
# Time range: 2024-06-10 01:03:36 to 01:04:36
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 5 4226
# Exec time 1 764ms 45us 29ms 180us 214us 976us 66us
# Lock time 7 121ms 9us 10ms 28us 28us 203us 14us
# Rows sent 0 4.13k 1 1 1 1 0 1
# Rows examine 0 4.12k 0 1 1.00 0.99 0.03 0.99
# Rows affecte 0 0 0 0 0 0 0 0
# Bytes sent 0 293.01k 71 71 71 71 0 71
# Query size 2 363.17k 88 88 88 88 0 88
# String:
# Databases isucondition
# Hosts localhost
# 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 COUNT(*) FROM `isu` WHERE `jia_isu_uuid` = 'c28358d6-2bf4-4077-976b-778ad1653e95'\G
# 10s user time, 80ms system time, 34.51M rss, 41.70M vsz
# Current date: Sun Jun 23 17:52:44 2024
# Hostname: ip-10-0-1-227
# Files: /var/log/mysql/slow-query.log
# Overall: 73.45k total, 95 unique, 874.39 QPS, 0.76x concurrency ________
# Time range: 2024-06-23 17:47:11 to 17:48:35
# Attribute total min max avg 95% stddev median
# ============ ======= ======= ======= ======= ======= ======= =======
# Exec time 64s 0 150ms 866us 4ms 3ms 57us
# Lock time 881ms 0 13ms 11us 40us 168us 0
# Rows sent 1.17M 0 948 16.75 24.84 84.23 0
# Rows examine 1.28M 0 948 18.29 76.28 84.63 0
# Rows affecte 41.56k 0 618 0.58 9.83 3.15 0
# Bytes sent 237.21M 0 148.18k 3.31k 19.40k 14.03k 51.63
# Query size 10.40M 6 790.36k 148.48 1.46k 2.83k 31.70
# Profile
# Rank Query ID Response time Calls R/Call V/M Item
# ==== ============================= ============= ===== ====== ===== ====
# 1 0xFFFCA4D67EA0A788813031B8... 29.2418 45.9% 4731 0.0062 0.01 COMMIT
# 2 0x931A992E852C61FC6D46141A... 13.7453 21.6% 3987 0.0034 0.01 SELECT isu_condition
# 3 0xB8B32624C3268C0925657C30... 5.0513 7.9% 4184 0.0012 0.01 INSERT isu_condition
# 4 0xDA556F9115773A1A99AA0165... 4.0726 6.4% 19871 0.0002 0.01 ADMIN PREPARE
# 5 0x8C2BC651CBBBF3DB41D1CAD6... 2.7814 4.4% 1375 0.0020 0.02 SELECT isu
# 6 0x9C6C682008AE0D08F3E2A004... 2.2434 3.5% 729 0.0031 0.01 SELECT isu_condition
# 7 0xADCA4F127A769A45A2D1B747... 2.0235 3.2% 1997 0.0010 0.02 SELECT user
# 8 0x1E561CE87F050ED58A7E1A7F... 1.0626 1.7% 4195 0.0003 0.02 SELECT isu
# 9 0x5F580A12ADA1633C9634298B... 0.8875 1.4% 335 0.0026 0.01 SELECT isu_condition
# MISC 0xMISC 2.5685 4.0% 32045 0.0001 0.0 <86 ITEMS>
# Query 1: 77.56 QPS, 0.48x concurrency, ID 0xFFFCA4D67EA0A788813031B8BBC3B329 at byte 12827720
# Scores: V/M = 0.01
# Time range: 2024-06-23 17:47:34 to 17:48:35
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 6 4731
# Exec time 45 29s 8us 90ms 6ms 18ms 7ms 4ms
# 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 50.82k 11 11 11 11 0 11
# Query size 0 27.72k 6 6 6 6 0 6
# String:
# Databases isucondition
# Hosts localhost
# Users isucon
# Query_time distribution
# 1us #
# 10us #####
# 100us ###
# 1ms ################################################################
# 10ms ##############
# 100ms
# 1s
# 10s+
COMMIT\G
# Query 2: 66.45 QPS, 0.23x concurrency, ID 0x931A992E852C61FC6D46141A39DEF4FE at byte 12824310
# Scores: V/M = 0.01
# Time range: 2024-06-23 17:47:34 to 17:48:34
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 5 3987
# Exec time 21 14s 91us 79ms 3ms 16ms 7ms 925us
# Lock time 11 103ms 10us 9ms 25us 26us 217us 13us
# Rows sent 70 847.26k 0 948 217.61 685.39 223.59 136.99
# Rows examine 64 847.26k 0 948 217.61 685.39 223.59 136.99
# Rows affecte 0 0 0 0 0 0 0 0
# Bytes sent 54 130.28M 589 148.18k 33.46k 106.99k 34.22k 20.37k
# Query size 4 447.76k 115 115 115 115 0 115
# String:
# Databases isucondition
# Hosts localhost
# 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` = '7cfb224d-4995-49ad-a784-b42739742fcb' ORDER BY timestamp DESC\G
# Query 3: 68.59 QPS, 0.08x concurrency, ID 0xB8B32624C3268C0925657C305C0ED778 at byte 12814964
# Scores: V/M = 0.01
# Time range: 2024-06-23 17:47:34 to 17:48:35
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 5 4184
# Exec time 7 5s 108us 53ms 1ms 8ms 4ms 224us
# Lock time 45 400ms 23us 13ms 95us 80us 478us 44us
# Rows sent 0 0 0 0 0 0 0 0
# Rows examine 0 0 0 0 0 0 0 0
# Rows affecte 98 40.79k 3 10 9.98 9.83 0.30 9.83
# Bytes sent 0 216.54k 52 53 53.00 51.63 0 51.63
# Query size 63 6.63M 513 2.05k 1.62k 1.78k 129.68 1.61k
# String:
# Databases isucondition
# Hosts localhost
# 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 ('c13e398f-9d32-4798-be12-1ee53f3b3349', '2021-08-17 22:29:54', 1, 'is_dirty=true,is_overweight=true,is_broken=false', '汚れてるし疲れました〜'),('c13e398f-9d32-4798-be12-1ee53f3b3349', '2021-08-17 22:30:48', 1, 'is_dirty=true,is_overweight=true,is_broken=false', '汚れてるし疲れました〜'),('c13e398f-9d32-4798-be12-1ee53f3b3349', '2021-08-17 22:31:48', 1, 'is_dirty=true,is_overweight=true,is_broken=false', '汚れてるし疲れました〜'),('c13e398f-9d32-4798-be12-1ee53f3b3349', '2021-08-17 22:32:52', 1, 'is_dirty=true,is_overweight=true,is_broken=false', '汚れてるし疲れました〜'),('c13e398f-9d32-4798-be12-1ee53f3b3349', '2021-08-17 22:33:54', 1, 'is_dirty=true,is_overweight=true,is_broken=false', '汚れてるし疲れました〜'),('c13e398f-9d32-4798-be12-1ee53f3b3349', '2021-08-17 22:34:48', 1, 'is_dirty=true,is_overweight=true,is_broken=false', '汚れてるし疲れました〜'),('c13e398f-9d32-4798-be12-1ee53f3b3349', '2021-08-17 22:35:56', 1, 'is_dirty=true,is_overweight=true,is_broken=false', '汚れてるし疲れました〜'),('c13e398f-9d32-4798-be12-1ee53f3b3349', '2021-08-17 22:36:50', 1, 'is_dirty=true,is_overweight=true,is_broken=false', '汚れてるし疲れました〜'),('c13e398f-9d32-4798-be12-1ee53f3b3349', '2021-08-17 22:37:46', 1, 'is_dirty=true,is_overweight=true,is_broken=false', '汚れてるし疲れました〜'),('c13e398f-9d32-4798-be12-1ee53f3b3349', '2021-08-17 22:38:53', 1, 'is_dirty=true,is_overweight=true,is_broken=false', '汚れてるし疲れました〜')\G
# Query 4: 301.08 QPS, 0.06x concurrency, ID 0xDA556F9115773A1A99AA0165670CE848 at byte 1586002
# Scores: V/M = 0.01
# Time range: 2024-06-23 17:47:29 to 17:48:35
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 27 19871
# Exec time 6 4s 34us 150ms 204us 247us 1ms 63us
# 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 4 10.81M 52 1.34k 570.37 1.33k 467.25 621.67
# Query size 5 582.16k 30 30 30 30 0 30
# String:
# Databases isucondition
# Hosts localhost
# Users isucon
# Query_time distribution
# 1us
# 10us ################################################################
# 100us ########
# 1ms #
# 10ms #
# 100ms #
# 1s
# 10s+
administrator command: Prepare\G
# Query 5: 22.92 QPS, 0.05x concurrency, ID 0x8C2BC651CBBBF3DB41D1CAD61AA0BD68 at byte 1971700
# Scores: V/M = 0.02
# Time range: 2024-06-23 17:47:34 to 17:48:34
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 1 1375
# Exec time 4 3s 188us 67ms 2ms 11ms 6ms 348us
# Lock time 4 41ms 10us 6ms 29us 26us 210us 13us
# Rows sent 0 3.89k 1 8 2.90 4.96 1.48 2.90
# Rows examine 7 98.06k 28 79 73.03 76.28 13.80 76.28
# Rows affecte 0 0 0 0 0 0 0 0
# Bytes sent 17 41.76M 5.44k 133.04k 31.10k 88.02k 29.07k 21.38k
# Query size 0 72.99k 51 57 54.36 56.92 2.95 51.63
# String:
# Databases isucondition
# Hosts localhost
# 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 6: 12.15 QPS, 0.04x concurrency, ID 0x9C6C682008AE0D08F3E2A0049B030C70 at byte 14835972
# Scores: V/M = 0.01
# Time range: 2024-06-23 17:47:34 to 17:48:34
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 729
# Exec time 3 2s 117us 59ms 3ms 14ms 6ms 1ms
# Lock time 1 12ms 11us 94us 16us 28us 6us 14us
# Rows sent 15 181.86k 0 848 255.46 621.67 197.83 202.40
# Rows examine 13 181.86k 0 848 255.46 621.67 197.83 202.40
# Rows affecte 0 0 0 0 0 0 0 0
# Bytes sent 11 28.14M 589 132.46k 39.53k 97.04k 30.61k 31.59k
# Query size 1 111.77k 157 157 157 157 0 157
# String:
# Databases isucondition
# Hosts localhost
# 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` = 'd048cfcb-e5cf-4e1b-ae8a-d14582f37505' AND `timestamp` < '2021-08-13 19:47:43' ORDER BY `timestamp` DESC\G
# Query 7: 32.74 QPS, 0.03x concurrency, ID 0xADCA4F127A769A45A2D1B74705103105 at byte 1962843
# Scores: V/M = 0.02
# Time range: 2024-06-23 17:47:34 to 17:48:35
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 2 1997
# Exec time 3 2s 48us 59ms 1ms 6ms 4ms 76us
# Lock time 6 53ms 9us 10ms 26us 28us 223us 15us
# Rows sent 0 1.95k 1 1 1 1 0 1
# Rows examine 0 1.95k 1 1 1 1 0 1
# Rows affecte 0 0 0 0 0 0 0 0
# Bytes sent 0 138.46k 71 71 71 71 0 71
# Query size 1 127.61k 58 70 65.43 69.19 3.88 65.89
# String:
# Databases isucondition
# Hosts localhost
# 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` = 'confident_chatelet'\G
# Query 8: 68.77 QPS, 0.02x concurrency, ID 0x1E561CE87F050ED58A7E1A7FBB6C2285 at byte 12826106
# Scores: V/M = 0.02
# Time range: 2024-06-23 17:47:34 to 17:48:35
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 5 4195
# Exec time 1 1s 46us 76ms 253us 159us 2ms 66us
# Lock time 16 149ms 9us 11ms 35us 30us 324us 14us
# Rows sent 0 4.10k 1 1 1 1 0 1
# Rows examine 0 4.09k 0 1 1.00 0.99 0.05 0.99
# Rows affecte 0 0 0 0 0 0 0 0
# Bytes sent 0 290.86k 71 71 71 71 0 71
# Query size 3 360.51k 88 88 88 88 0 88
# String:
# Databases isucondition
# Hosts localhost
# 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 COUNT(*) FROM `isu` WHERE `jia_isu_uuid` = 'e1eb3b30-eed6-49a7-9b41-2ebf57a7fe96'\G
# Query 9: 5.49 QPS, 0.01x concurrency, ID 0x5F580A12ADA1633C9634298BE5BD9422 at byte 21417781
# Scores: V/M = 0.01
# Time range: 2024-06-23 17:47:34 to 17:48:35
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 335
# Exec time 1 888ms 131us 33ms 3ms 10ms 4ms 1ms
# Lock time 0 8ms 10us 1ms 23us 28us 82us 13us
# Rows sent 13 157.38k 6 846 481.07 793.42 207.84 487.09
# Rows examine 11 157.38k 6 846 481.07 793.42 207.84 487.09
# Rows affecte 0 0 0 0 0 0 0 0
# Bytes sent 10 24.13M 1.48k 134.64k 73.77k 123.85k 32.42k 68.96k
# Query size 0 37.95k 116 116 116 116 0 116
# String:
# Databases isucondition
# Hosts localhost
# 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` = '27878b2d-d56f-491a-8c18-adc09e9f61e6' ORDER BY `timestamp` ASC\G
# 16.4s user time, 90ms system time, 41.50M rss, 392.03G vsz
# Current date: Sun Jul 14 01:27:15 2024
# Hostname: tt.local
# Files: logs/mysql/slow-query.log
# Overall: 281.91k total, 93 unique, 1.88k QPS, 0.28x concurrency ________
# Time range: 2024-07-14 01:22:55 to 01:25:25
# Attribute total min max avg 95% stddev median
# ============ ======= ======= ======= ======= ======= ======= =======
# Exec time 43s 0 80ms 151us 972us 516us 28us
# Lock time 935ms 0 3ms 3us 17us 13us 0
# Rows sent 12.65M 0 1.60k 47.05 329.68 196.76 0
# Rows examine 12.57M 0 1.60k 46.77 329.68 196.66 0
# Rows affecte 337.75k 0 121.38k 1.23 0.99 228.33 0
# Bytes sent 2.14G 0 646.20k 7.95k 59.57k 29.68k 69.19
# Query size 29.46M 6 790.36k 109.59 151.03 1.47k 31.70
# Boolean:
# QC hit 12% yes, 87% no
# Profile
# Rank Query ID Response time Calls R/Call V/M
# ==== =================================== ============= ====== ====== ===
# 1 0x931A992E852C61FC6D46141A39DEF4FE 19.1690 44.9% 23309 0.0008 0.00 SELECT isu_condition
# 2 0xFFFCA4D67EA0A788813031B8BBC3B329 9.6771 22.7% 9818 0.0010 0.00 COMMIT
# 3 0x9C6C682008AE0D08F3E2A0049B030C70 4.4217 10.4% 3831 0.0012 0.00 SELECT isu_condition
# 4 0xDA556F9115773A1A99AA0165670CE848 3.9269 9.2% 81821 0.0000 0.00 ADMIN PREPARE
# 5 0x5F580A12ADA1633C9634298BE5BD9422 1.2080 2.8% 1051 0.0011 0.00 SELECT isu_condition
# 6 0xB8B32624C3268C0925657C305C0ED778 1.1867 2.8% 7340 0.0002 0.00 INSERT isu_condition
# 7 0x8155B89FFD74A9D523D19AC409FD97AF 0.7893 1.8% 8470 0.0001 0.00 SELECT isu_condition
# 8 0x8C2BC651CBBBF3DB41D1CAD61AA0BD68 0.3740 0.9% 7500 0.0000 0.00 SELECT isu
# MISC 0xMISC 1.9386 4.5% 138769 0.0000 0.0 <85 ITEMS>
# Query 1: 382.11 QPS, 0.31x concurrency, ID 0x931A992E852C61FC6D46141A39DEF4FE at byte 90534076
# Scores: V/M = 0.00
# Time range: 2024-07-14 01:24:24 to 01:25:25
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 8 23309
# Exec time 44 19s 12us 20ms 822us 2ms 855us 467us
# Lock time 33 312ms 0 3ms 13us 23us 24us 10us
# Rows sent 74 9.48M 0 1.60k 426.46 1.26k 448.48 223.14
# Rows examine 75 9.43M 0 1.60k 424.20 1.26k 449.51 212.52
# Rows affecte 0 0 0 0 0 0 0 0
# Bytes sent 65 1.41G 589 250.66k 63.30k 192.13k 66.17k 33.17k
# Query size 8 2.56M 115 115 115 115 0 115
# Boolean:
# QC hit 2% yes, 97% no
# String:
# Databases isucondition
# Hosts 172.25.0.4
# 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` = '1ec3ba00-046e-428f-959d-078a2ee9c38e' ORDER BY timestamp DESC\G
# Query 2: 66.79 QPS, 0.07x concurrency, ID 0xFFFCA4D67EA0A788813031B8BBC3B329 at byte 11075086
# Scores: V/M = 0.00
# Time range: 2024-07-14 01:22:57 to 01:25:24
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 3 9818
# Exec time 22 10s 5us 59ms 985us 2ms 1ms 839us
# 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 105.47k 11 11 11 11 0 11
# Query size 0 57.53k 6 6 6 6 0 6
# String:
# Databases isuconditi... (9817/99%), mysql (1/0%)
# Hosts 172.25.0.4 (9817/99%), localhost (1/0%)
# Users isucon (9817/99%), root (1/0%)
# Query_time distribution
# 1us ###
# 10us ####################################
# 100us #########################################################
# 1ms ################################################################
# 10ms #
# 100ms
# 1s
# 10s+
COMMIT\G
# Query 3: 63.85 QPS, 0.07x concurrency, ID 0x9C6C682008AE0D08F3E2A0049B030C70 at byte 91127365
# Scores: V/M = 0.00
# Time range: 2024-07-14 01:24:24 to 01:25:24
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 1 3831
# Exec time 10 4s 65us 8ms 1ms 2ms 743us 1ms
# Lock time 5 54ms 4us 629us 14us 23us 14us 10us
# Rows sent 18 2.38M 0 1.57k 652.01 1.20k 380.12 621.67
# Rows examine 18 2.38M 0 1.57k 652.01 1.20k 380.12 621.67
# Rows affecte 0 0 0 0 0 0 0 0
# Bytes sent 16 359.98M 589 242.45k 96.22k 182.98k 55.88k 92.42k
# Query size 1 587.37k 157 157 157 157 0 157
# String:
# Databases isucondition
# Hosts 172.25.0.4
# 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` = '93a5e8ac-1ec7-473c-821f-b4f95752a90f' AND `timestamp` < '2021-08-29 03:40:02' ORDER BY `timestamp` DESC\G
# Query 4: 1.24k QPS, 0.06x concurrency, ID 0xDA556F9115773A1A99AA0165670CE848 at byte 74170434
# Scores: V/M = 0.00
# Time range: 2024-07-14 01:24:19 to 01:25:25
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 29 81821
# Exec time 9 4s 13us 3ms 47us 80us 35us 40us
# 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 1 40.03M 52 1.34k 512.98 1.33k 353.07 621.67
# Query size 7 2.34M 30 30 30 30 0 30
# String:
# Databases isucondition
# Hosts 172.25.0.4
# Users isucon
# Query_time distribution
# 1us
# 10us ################################################################
# 100us #
# 1ms #
# 10ms
# 100ms
# 1s
# 10s+
administrator command: Prepare\G
# Query 5: 17.52 QPS, 0.02x concurrency, ID 0x5F580A12ADA1633C9634298BE5BD9422 at byte 91096351
# Scores: V/M = 0.00
# Time range: 2024-07-14 01:24:24 to 01:25:24
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 1051
# Exec time 2 1s 22us 9ms 1ms 2ms 788us 972us
# Lock time 1 13ms 0 156us 12us 23us 8us 10us
# Rows sent 5 732.64k 10 1.57k 713.81 1.26k 406.41 685.39
# Rows examine 5 732.23k 0 1.57k 713.41 1.26k 407.04 685.39
# Rows affecte 0 0 0 0 0 0 0 0
# Bytes sent 4 107.94M 2.09k 243.96k 105.17k 192.13k 59.33k 101.89k
# Query size 0 119.06k 116 116 116 116 0 116
# Boolean:
# QC hit 0% yes, 99% no
# String:
# Databases isucondition
# Hosts 172.25.0.4
# 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` = '23e83d83-33aa-443f-8a5f-3ccbf7bfabbd' ORDER BY `timestamp` ASC\G
# Query 6: 122.33 QPS, 0.02x concurrency, ID 0xB8B32624C3268C0925657C305C0ED778 at byte 9452571
# Scores: V/M = 0.00
# Time range: 2024-07-14 01:24:24 to 01:25:24
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 2 7340
# Exec time 2 1s 53us 12ms 161us 236us 232us 131us
# Lock time 25 236ms 8us 837us 32us 52us 22us 27us
# Rows sent 0 0 0 0 0 0 0 0
# Rows examine 0 0 0 0 0 0 0 0
# Rows affecte 21 71.42k 1 10 9.96 9.83 0.45 9.83
# Bytes sent 0 380.42k 13 54 53.07 51.63 1.12 51.63
# Query size 38 11.26M 242 1.95k 1.57k 1.69k 125.72 1.46k
# String:
# Databases isucondition
# Hosts 172.25.0.4
# 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 ('57526073-6268-4329-a1e2-cfe6d1848cb2', '2021-08-10 05:03:13', 0, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じです！'),('57526073-6268-4329-a1e2-cfe6d1848cb2', '2021-08-10 05:04:18', 0, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じです！'),('57526073-6268-4329-a1e2-cfe6d1848cb2', '2021-08-10 05:05:19', 1, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じです！'),('57526073-6268-4329-a1e2-cfe6d1848cb2', '2021-08-10 05:06:13', 1, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じです！'),('57526073-6268-4329-a1e2-cfe6d1848cb2', '2021-08-10 05:07:14', 1, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じです！'),('57526073-6268-4329-a1e2-cfe6d1848cb2', '2021-08-10 05:08:21', 1, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じです！'),('57526073-6268-4329-a1e2-cfe6d1848cb2', '2021-08-10 05:09:21', 0, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じです！'),('57526073-6268-4329-a1e2-cfe6d1848cb2', '2021-08-10 05:10:12', 0, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じです！'),('57526073-6268-4329-a1e2-cfe6d1848cb2', '2021-08-10 05:11:17', 0, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じです！'),('57526073-6268-4329-a1e2-cfe6d1848cb2', '2021-08-10 05:12:14', 0, 'is_dirty=false,is_overweight=false,is_broken=false', 'いい感じです！')\G
# Query 7: 141.17 QPS, 0.01x concurrency, ID 0x8155B89FFD74A9D523D19AC409FD97AF at byte 11656824
# Scores: V/M = 0.00
# Time range: 2024-07-14 01:24:24 to 01:25:24
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 3 8470
# Exec time 1 789ms 35us 4ms 93us 144us 82us 80us
# Lock time 12 114ms 5us 2ms 13us 22us 33us 10us
# Rows sent 0 8.21k 0 1 0.99 0.99 0.09 0.99
# Rows examine 0 8.21k 0 1 0.99 0.99 0.09 0.99
# Rows affecte 0 0 0 0 0 0 0 0
# Bytes sent 0 5.97M 589 778 738.51 755.64 16.42 719.66
# Query size 3 1.01M 125 125 125 125 0 125
# String:
# Databases isucondition
# Hosts 172.25.0.4
# 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` = 'f7e2afb5-15e8-4200-8938-317a534a8e02' ORDER BY `timestamp` DESC LIMIT 1\G
# Query 8: 122.95 QPS, 0.01x concurrency, ID 0x8C2BC651CBBBF3DB41D1CAD61AA0BD68 at byte 80450133
# Scores: V/M = 0.00
# Time range: 2024-07-14 01:24:24 to 01:25:25
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 2 7500
# Exec time 0 374ms 13us 2ms 49us 159us 64us 31us
# Lock time 0 7ms 0 203us 0 8us 4us 0
# Rows sent 0 22.76k 1 6 3.11 4.96 1.54 2.90
# Rows examine 0 33.47k 0 79 4.57 40.45 16.70 0
# Rows affecte 0 0 0 0 0 0 0 0
# Bytes sent 10 227.89M 5.44k 133.04k 31.11k 88.02k 29.07k 20.37k
# Query size 1 398.14k 51 57 54.36 56.92 2.95 51.63
# Boolean:
# QC hit 92% yes, 7% no
# String:
# Databases isucondition
# Hosts 172.25.0.4
# 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
# 19.8s user time, 130ms system time, 41.20M rss, 391.92G vsz
# Current date: Sun Jul 14 16:42:12 2024
# Hostname: tt.local
# Files: logs/mysql/slow-query.log
# Overall: 342.80k total, 67 unique, 5.19k QPS, 0.37x concurrency ________
# Time range: 2024-07-14 16:39:16 to 16:40:22
# Attribute total min max avg 95% stddev median
# ============ ======= ======= ======= ======= ======= ======= =======
# Exec time 24s 0 54ms 71us 131us 284us 25us
# Lock time 762ms 0 1ms 2us 11us 6us 0
# Rows sent 3.99M 0 1.62k 12.19 0.99 103.42 0
# Rows examine 3.91M 0 1.62k 11.98 0.99 103.44 0
# Rows affecte 73.77k 0 618 0.22 0 1.76 0
# Bytes sent 672.44M 0 646.20k 2.01k 918.49 15.05k 92.72
# Query size 29.44M 6 790.36k 90.05 136.99 1.32k 31.70
# Boolean:
# QC hit 13% yes, 86% no
# Profile
# Rank Query ID Response time Calls R/Call V/M
# ==== =================================== ============= ====== ====== ===
# 1 0xFFFCA4D67EA0A788813031B8BBC3B329 7.4885 30.7% 10637 0.0007 0.00 COMMIT
# 2 0x9C6C682008AE0D08F3E2A0049B030C70 5.0173 20.6% 4401 0.0011 0.00 SELECT isu_condition
# 3 0xDA556F9115773A1A99AA0165670CE848 4.2215 17.3% 104189 0.0000 0.00 ADMIN PREPARE
# 4 0xAC9E2250E1642BFE9823A9B9ECA1A419 2.6585 10.9% 32385 0.0001 0.00 SELECT isu_condition
# 5 0x5F580A12ADA1633C9634298BE5BD9422 1.4041 5.8% 1229 0.0011 0.00 SELECT isu_condition
# 6 0xB8B32624C3268C0925657C305C0ED778 1.0339 4.2% 7484 0.0001 0.00 INSERT isu_condition
# 7 0x8155B89FFD74A9D523D19AC409FD97AF 0.8930 3.7% 11789 0.0001 0.00 SELECT isu_condition
# 8 0xADCA4F127A769A45A2D1B74705103105 0.3066 1.3% 14439 0.0000 0.00 SELECT user
# 9 0x07890000813C4CC7111FD2D3F3B3B4EB 0.2965 1.2% 104189 0.0000 0.00 ADMIN CLOSE STMT
# MISC 0xMISC 1.0741 4.4% 52060 0.0000 0.0 <58 ITEMS>
# Query 1: 177.28 QPS, 0.12x concurrency, ID 0xFFFCA4D67EA0A788813031B8BBC3B329 at byte 4768283
# Scores: V/M = 0.00
# Time range: 2024-07-14 16:39:21 to 16:40:21
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 3 10637
# Exec time 30 7s 4us 54ms 704us 2ms 1ms 690us
# 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 114.26k 11 11 11 11 0 11
# Query size 0 62.33k 6 6 6 6 0 6
# String:
# Databases isucondition
# Hosts 172.27.0.4
# Users isucon
# Query_time distribution
# 1us ###
# 10us ##################################
# 100us ################################################################
# 1ms ###########################
# 10ms #
# 100ms
# 1s
# 10s+
COMMIT\G
# Query 2: 73.35 QPS, 0.08x concurrency, ID 0x9C6C682008AE0D08F3E2A0049B030C70 at byte 85724313
# Scores: V/M = 0.00
# Time range: 2024-07-14 16:39:21 to 16:40:21
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 1 4401
# Exec time 20 5s 61us 9ms 1ms 2ms 651us 1ms
# Lock time 6 49ms 5us 166us 11us 17us 5us 9us
# Rows sent 74 2.97M 0 1.62k 707.34 1.33k 406.26 685.39
# Rows examine 75 2.97M 0 1.62k 707.34 1.33k 406.26 685.39
# Rows affecte 0 0 0 0 0 0 0 0
# Bytes sent 65 442.44M 589 248.75k 102.95k 192.13k 58.91k 101.89k
# Query size 2 674.76k 157 157 157 157 0 157
# String:
# Databases isucondition
# Hosts 172.27.0.4
# 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` = '3219ad61-463f-4c5a-bcca-9fe80f5e34cf' AND `timestamp` < '2021-08-24 14:11:04' ORDER BY `timestamp` DESC\G
# Query 3: 1.58k QPS, 0.06x concurrency, ID 0xDA556F9115773A1A99AA0165670CE848 at byte 37199500
# Scores: V/M = 0.00
# Time range: 2024-07-14 16:39:16 to 16:40:22
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 30 104189
# Exec time 17 4s 13us 3ms 40us 63us 22us 35us
# 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 7 50.22M 52 1.34k 505.44 1.33k 329.74 621.67
# Query size 10 2.98M 30 30 30 30 0 30
# String:
# Databases isucondition
# Hosts 172.27.0.4
# Users isucon
# Query_time distribution
# 1us
# 10us ################################################################
# 100us #
# 1ms #
# 10ms
# 100ms
# 1s
# 10s+
administrator command: Prepare\G
# Query 4: 530.90 QPS, 0.04x concurrency, ID 0xAC9E2250E1642BFE9823A9B9ECA1A419 at byte 4415382
# Scores: V/M = 0.00
# Time range: 2024-07-14 16:39:21 to 16:40:22
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 9 32385
# Exec time 10 3s 11us 4ms 82us 125us 56us 73us
# Lock time 44 336ms 0 946us 10us 16us 8us 8us
# Rows sent 0 31.57k 0 1 1.00 0.99 0.04 0.99
# Rows examine 0 30.36k 0 1 0.96 0.99 0.19 0.99
# Rows affecte 0 0 0 0 0 0 0 0
# Bytes sent 3 22.75M 589 789 736.50 755.64 12.43 719.66
# Query size 12 3.80M 123 123 123 123 0 123
# Boolean:
# QC hit 3% yes, 96% no
# String:
# Databases isucondition
# Hosts 172.27.0.4
# 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` = '2fbbb42f-287a-40f7-8432-ea1d8dd9afd6' ORDER BY timestamp DESC LIMIT 1\G
# Query 5: 20.48 QPS, 0.02x concurrency, ID 0x5F580A12ADA1633C9634298BE5BD9422 at byte 98152822
# Scores: V/M = 0.00
# Time range: 2024-07-14 16:39:21 to 16:40:21
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 1229
# Exec time 5 1s 22us 8ms 1ms 2ms 722us 1ms
# Lock time 1 14ms 0 1ms 11us 16us 29us 8us
# Rows sent 22 910.70k 10 1.62k 758.79 1.39k 424.66 719.66
# Rows examine 22 908.59k 0 1.62k 757.03 1.39k 426.49 719.66
# Rows affecte 0 0 0 0 0 0 0 0
# Bytes sent 19 132.05M 1.91k 250.47k 110.03k 201.74k 61.33k 106.99k
# Query size 0 139.22k 116 116 116 116 0 116
# Boolean:
# QC hit 1% yes, 98% no
# String:
# Databases isucondition
# Hosts 172.27.0.4
# 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` = '8a757d98-f6e8-4c9e-b335-e6b81479526d' ORDER BY `timestamp` ASC\G
# Query 6: 124.73 QPS, 0.02x concurrency, ID 0xB8B32624C3268C0925657C305C0ED778 at byte 4396806
# Scores: V/M = 0.00
# Time range: 2024-07-14 16:39:21 to 16:40:21
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 2 7484
# Exec time 4 1s 63us 5ms 138us 176us 132us 119us
# Lock time 27 209ms 14us 699us 27us 38us 13us 23us
# Rows sent 0 0 0 0 0 0 0 0
# Rows examine 0 0 0 0 0 0 0 0
# Rows affecte 98 73.03k 2 10 9.99 9.83 0.19 9.83
# Bytes sent 0 388.30k 52 54 53.13 51.63 0 51.63
# Query size 38 11.31M 394 2.05k 1.55k 1.69k 113.96 1.46k
# String:
# Databases isucondition
# Hosts 172.27.0.4
# 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 ('f2336975-d769-458e-958a-b11c586b19f9', '2021-08-10 12:42:00', 1, 'is_dirty=false,is_overweight=false,is_broken=false', 'よいです。'),('f2336975-d769-458e-958a-b11c586b19f9', '2021-08-10 12:42:59', 1, 'is_dirty=false,is_overweight=false,is_broken=false', 'よいです。'),('f2336975-d769-458e-958a-b11c586b19f9', '2021-08-10 12:43:57', 1, 'is_dirty=false,is_overweight=false,is_broken=false', 'よいです。'),('f2336975-d769-458e-958a-b11c586b19f9', '2021-08-10 12:44:59', 0, 'is_dirty=false,is_overweight=false,is_broken=false', 'よいです。'),('f2336975-d769-458e-958a-b11c586b19f9', '2021-08-10 12:45:56', 0, 'is_dirty=false,is_overweight=false,is_broken=false', 'よいです。'),('f2336975-d769-458e-958a-b11c586b19f9', '2021-08-10 12:47:01', 0, 'is_dirty=false,is_overweight=false,is_broken=false', 'よいです。'),('f2336975-d769-458e-958a-b11c586b19f9', '2021-08-10 12:48:06', 0, 'is_dirty=false,is_overweight=false,is_broken=false', 'よいです。'),('f2336975-d769-458e-958a-b11c586b19f9', '2021-08-10 12:49:04', 0, 'is_dirty=false,is_overweight=false,is_broken=false', 'よいです。'),('f2336975-d769-458e-958a-b11c586b19f9', '2021-08-10 12:50:03', 0, 'is_dirty=false,is_overweight=false,is_broken=false', 'よいです。'),('f2336975-d769-458e-958a-b11c586b19f9', '2021-08-10 12:51:05', 0, 'is_dirty=false,is_overweight=false,is_broken=false', 'よいです。')\G
# Query 7: 196.48 QPS, 0.01x concurrency, ID 0x8155B89FFD74A9D523D19AC409FD97AF at byte 4405473
# Scores: V/M = 0.00
# Time range: 2024-07-14 16:39:21 to 16:40:21
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 3 11789
# Exec time 3 893ms 33us 3ms 75us 113us 48us 66us
# Lock time 16 123ms 4us 371us 10us 15us 8us 8us
# Rows sent 0 11.48k 0 1 1.00 0.99 0.06 0.99
# Rows examine 0 11.48k 0 1 1.00 0.99 0.06 0.99
# Rows affecte 0 0 0 0 0 0 0 0
# Bytes sent 1 8.28M 589 789 736.87 755.64 12.89 719.66
# Query size 4 1.41M 125 125 125 125 0 125
# String:
# Databases isucondition
# Hosts 172.27.0.4
# 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` = '42bb21bb-46d7-4f77-9dcd-27a4300523e6' ORDER BY `timestamp` DESC LIMIT 1\G
# Query 8: 240.65 QPS, 0.01x concurrency, ID 0xADCA4F127A769A45A2D1B74705103105 at byte 31127552
# Scores: V/M = 0.00
# Time range: 2024-07-14 16:39:21 to 16:40:21
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 4 14439
# Exec time 1 307ms 8us 587us 21us 31us 12us 18us
# Lock time 0 242us 0 19us 0 0 0 0
# Rows sent 0 14.10k 1 1 1 1 0 1
# Rows examine 0 22 0 1 0.00 0 0.04 0
# Rows affecte 0 0 0 0 0 0 0 0
# Bytes sent 0 1001.14k 71 71 71 71 0 71
# Query size 3 934.49k 58 72 66.27 69.19 4.29 65.89
# Boolean:
# QC hit 99% yes, 0% no
# String:
# Databases isucondition
# Hosts 172.27.0.4
# 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` = 'affectionate_mcnulty'\G
# Query 9: 1.58k QPS, 0.00x concurrency, ID 0x07890000813C4CC7111FD2D3F3B3B4EB at byte 106886882
# Scores: V/M = 0.00
# Time range: 2024-07-14 16:39:16 to 16:40:22
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 30 104189
# Exec time 1 296ms 0 433us 2us 4us 3us 1us
# 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 0 0 0 0 0 0 0
# Query size 11 3.28M 33 33 33 33 0 33
# String:
# Databases isucondition
# Hosts 172.27.0.4
# Users isucon
# Query_time distribution
# 1us ################################################################
# 10us #
# 100us #
# 1ms
# 10ms
# 100ms
# 1s
# 10s+
administrator command: Close stmt\G