Open github-actions[bot] opened 11 months ago
COUNT | 1XX | 2XX | 3XX | 4XX | 5XX | METHOD | URI | MIN | MAX | SUM | AVG | P90 | P95 | P99 | STDDEV | MIN(BODY) | MAX(BODY) | SUM(BODY) | AVG(BODY) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
872 | 0 | 857 | 0 | 15 | 0 | GET | /api/livestream | 0.000 | 7.264 | 232.992 | 0.267 | 0.592 | 0.720 | 0.968 | 0.401 | 55.000 | 50828.000 | 9695101.000 | 11118.235 |
788 | 0 | 779 | 0 | 9 | 0 | POST | /api/livestream | 0.004 | 16.720 | 223.972 | 0.284 | 0.272 | 0.424 | 4.736 | 1.042 | 0.000 | 2691.000 | 1384269.000 | 1756.687 |
3074 | 0 | 3072 | 0 | 2 | 0 | GET | /api/user/[a-zA-Z0-9]+/icon | 0.004 | 0.812 | 168.140 | 0.055 | 0.152 | 0.224 | 0.412 | 0.085 | 0.000 | 164797.000 | 166646787.000 | 54211.707 |
7 | 0 | 2 | 0 | 5 | 0 | GET | /api/user/[a-zA-Z0-9]+/statistics | 2.708 | 20.004 | 103.636 | 14.805 | 20.004 | 20.004 | 20.004 | 7.674 | 0.000 | 140.000 | 273.000 | 39.000 |
271 | 0 | 267 | 0 | 3 | 1 | POST | /api/register | 0.008 | 0.820 | 65.476 | 0.242 | 0.384 | 0.464 | 0.608 | 0.112 | 0.000 | 504.000 | 125355.000 | 462.565 |
102 | 0 | 98 | 0 | 4 | 0 | POST | /api/livestream/reservation | 0.212 | 1.044 | 45.356 | 0.445 | 0.800 | 0.884 | 1.040 | 0.310 | 0.000 | 1456.000 | 110362.000 | 1081.980 |
50 | 0 | 50 | 0 | 0 | 0 | GET | /api/livestream/search | 0.056 | 2.284 | 44.872 | 0.897 | 1.672 | 1.956 | 2.284 | 0.567 | 49542.000 | 126615.000 | 3670188.000 | 73403.760 |
275 | 0 | 273 | 0 | 2 | 0 | POST | /api/login | 0.004 | 0.632 | 17.668 | 0.064 | 0.172 | 0.256 | 0.484 | 0.091 | 0.000 | 64.000 | 128.000 | 0.465 |
1 | 0 | 1 | 0 | 0 | 0 | POST | /api/initialize | 16.848 | 16.848 | 16.848 | 16.848 | 16.848 | 16.848 | 16.848 | 0.000 | 27.000 | 27.000 | 27.000 | 27.000 |
82 | 0 | 82 | 0 | 0 | 0 | GET | /api/tag | 0.004 | 0.468 | 5.248 | 0.064 | 0.152 | 0.204 | 0.468 | 0.086 | 6089.000 | 6095.000 | 499652.000 | 6093.317 |
26 | 0 | 26 | 0 | 0 | 0 | DELETE | /api/livestream | 0.008 | 0.124 | 0.996 | 0.038 | 0.072 | 0.104 | 0.124 | 0.029 | 0.000 | 0.000 | 0.000 | 0.000 |
268 | 0 | 268 | 0 | 0 | 0 | POST | /api/icon | 0.000 | 0.012 | 0.664 | 0.002 | 0.004 | 0.008 | 0.012 | 0.003 | 14.000 | 14.000 | 3752.000 | 14.000 |
6 | 0 | 6 | 0 | 0 | 0 | GET | /api/user/[a-zA-Z0-9]+/theme | 0.008 | 0.280 | 0.416 | 0.069 | 0.280 | 0.280 | 0.280 | 0.098 | 38.000 | 38.000 | 228.000 | 38.000 |
3 | 0 | 3 | 0 | 0 | 0 | GET | /api/user/me | 0.004 | 0.004 | 0.008 | 0.003 | 0.004 | 0.004 | 0.004 | 0.002 | 235.000 | 247.000 | 729.000 | 243.000 |
1 | 0 | 1 | 0 | 0 | 0 | GET | /api/payment | 0.004 | 0.004 | 0.004 | 0.004 | 0.004 | 0.004 | 0.004 | 0.000 | 21.000 | 21.000 | 21.000 | 21.000 |
1 | 0 | 1 | 0 | 0 | 0 | GET | /api/user/[a-zA-Z0-9]+$ | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 235.000 | 235.000 | 235.000 | 235.000 |
Reading from STDIN ...
# 35.1s user time, 170ms system time, 35.93M rss, 42.36M vsz
# Current date: Sat Nov 25 04:37:58 2023
# Hostname: ip-192-168-0-11
# Files: STDIN
# Overall: 568.73k total, 93 unique, 2.71k QPS, 1.83x concurrency ________
# Time range: 2023-11-25T04:31:06 to 2023-11-25T04:34:36
# Attribute total min max avg 95% stddev median
# ============ ======= ======= ======= ======= ======= ======= =======
# Exec time 385s 1us 457ms 676us 2ms 3ms 69us
# Lock time 774ms 0 44ms 1us 1us 119us 0
# Rows sent 232.70k 0 7.32k 0.42 0.99 17.18 0
# Rows examine 92.42M 0 14.02k 170.40 1.09k 667.26 0
# Query size 38.18M 5 1.94M 70.39 313.99 2.74k 31.70
# Profile
# Rank Query ID Response time Calls R/Call V/M
# ==== ================================== ============= ====== ====== ====
# 1 0xDA556F9115773A1A99AA0165670CE848 58.5056 15.2% 170403 0.0003 0.00 ADMIN PREPARE
# 2 0x42EF7D7D98FBCC9723BF896EBFC51D24 43.5692 11.3% 6082 0.0072 0.01 SELECT records
# 3 0x38BC86A45F31C6B1EE324671506C898A 33.3612 8.7% 15017 0.0022 0.00 SELECT themes
# 4 0xF1B8EF06D6CA63B24BFF433E06CCEB22 32.4965 8.4% 3961 0.0082 0.01 SELECT users livestreams livecomments
# 5 0xDB74D52D39A7090F224C4DEEAF3028C9 30.9393 8.0% 3964 0.0078 0.01 SELECT users livestreams reactions
# 6 0x3D83BC87F3B3A00D571FFC8104A6E50C 23.9351 6.2% 4542 0.0053 0.01 SELECT records
# 7 0x4ADE2DC90689F1C4891749AF54FB8D14 19.6775 5.1% 40084 0.0005 0.00 DELETE SELECT livecomments
# 8 0x59F1B6DD8D9FEC059E55B3BFD624E8C3 17.2420 4.5% 836 0.0206 0.01 SELECT reservation_slots
# 9 0x64CC8A4E8E4B390203375597CE4D611F 15.5847 4.1% 356 0.0438 0.01 SELECT ng_words
# 10 0xFFFCA4D67EA0A788813031B8BBC3B329 13.7117 3.6% 2713 0.0051 0.01 COMMIT
# 11 0xFBC5564AE716EAE82F20BFB45F6C37E7 12.7089 3.3% 36433 0.0003 0.00 SELECT tags
# 12 0x22279D81D51006139E0C76405B54C261 8.1672 2.1% 9255 0.0009 0.00 SELECT domains domainmetadata
# 13 0xDFFCC1D78939C4D781C7C58349101F50 6.7383 1.8% 1000 0.0067 0.00 INSERT users
# 14 0xD2A0864774622BA36F6557496405CF75 6.7274 1.7% 1268 0.0053 0.00 INSERT themes
# 15 0x8F7679D452333ED3C7D60D22131CEFD4 5.9119 1.5% 21744 0.0003 0.00 ADMIN RESET STMT
# 16 0xEA1E6309EEEFF9A6831AD2FB940FC23C 5.4774 1.4% 14744 0.0004 0.00 SELECT users
# 17 0xF7144185D9A142A426A36DC55C1D2623 5.0585 1.3% 9124 0.0006 0.00 SELECT livestream_tags
# 18 0x859BBB7E9D760686137A944406874C4D 4.4894 1.2% 268 0.0168 0.01 DELETE records
# 19 0xFD38427AE3D09E3883A680F7BAF95D3A 4.3735 1.1% 14992 0.0003 0.00 SELECT livestreams livecomments
# 20 0xA3401CA3ABCC04C3AB221DB8AD5CBF26 4.1577 1.1% 98 0.0424 0.02 UPDATE reservation_slots
# 21 0xC499D81D570D361DB61FC43A94BB888A 3.8235 1.0% 14992 0.0003 0.00 SELECT livestreams reactions
# 22 0x7F9C0C0BA9473953B723EE16C08655F1 3.6062 0.9% 99 0.0364 0.02 SELECT reservation_slots
# 23 0x9EAD6C0CE525E3693EE27FFC9AAF05A3 3.5762 0.9% 83 0.0431 0.01 SELECT livestreams
# 24 0xD6032FE08E1FE706A928B8B7CBA06B85 3.0711 0.8% 7616 0.0004 0.00 SELECT livestreams
# 25 0x9AC623FA477E73A44D191D296850A025 2.7158 0.7% 536 0.0051 0.00 SELECT records
# 26 0x07890000813C4CC7111FD2D3F3B3B4EB 2.0763 0.5% 170381 0.0000 0.00 ADMIN CLOSE STMT
# 27 0xB08B7B7486D2DFE2F2FE9CE78689FD79 1.3804 0.4% 25 0.0552 0.01 SELECT ng_words
# 28 0xEDE18C1523658A19E07525EAFCBA6BFE 1.3315 0.3% 27 0.0493 0.01 SELECT ng_words
# 29 0x3F155F5E71EFF856F0CF7B8430DE8C23 1.2096 0.3% 3355 0.0004 0.00 SELECT users
# 30 0xFFF66E9B3D962FA319C8068B5C1997CD 1.0537 0.3% 3086 0.0003 0.00 ROLLBACK
# 31 0xB78E63D0D9C72DDDAB7A3E53517FA04C 0.8721 0.2% 308 0.0028 0.00 SELECT livecomments
# 32 0x9E2DA589A20EC24C34E11DDE0FBF5564 0.8333 0.2% 5543 0.0002 0.00 START
# 33 0xAD0C28443E1E5CFAFF1569DBB4F7E63A 0.6978 0.2% 342 0.0020 0.00 SELECT reactions
# 34 0x98F959E03B684A5538FD8402A0EE94AD 0.6388 0.2% 103 0.0062 0.00 INSERT tags
# 35 0x80E10371CE74ED05E09C79C72C73F8E1 0.4995 0.1% 99 0.0050 0.28 INSERT livestreams
# 36 0x02B6A87E51A5A1B7646675DB67C57DE3 0.4573 0.1% 1 0.4573 0.00 INSERT ng_words
# 37 0x0C1FCBB4E25B178AA3A46D4FECBA9BDC 0.4221 0.1% 22 0.0192 0.00 INSERT livestream_tags
# 38 0x77FB9E134D073862D1E78FEEC3436291 0.3980 0.1% 1548 0.0003 0.00 INSERT records
# 39 0x41F805E95754958A974F41AE07BEA625 0.3167 0.1% 35 0.0090 0.00 SELECT livecomments
# 40 0xF3A502CCF34F7DA288CC1B75AD5AFA37 0.2647 0.1% 354 0.0007 0.00 INSERT livecomments
# 41 0xB9AC05A7AE6C4E30B5B45F6F3CE05BE0 0.1833 0.0% 545 0.0003 0.00 SET
# 42 0x64052B1C32B30DF53AB3292208B783B4 0.1702 0.0% 269 0.0006 0.00 INSERT users
# 43 0xDF0AAE38E2AAFC85E6F50569CEF2285D 0.1679 0.0% 1 0.1679 0.00 INSERT reservation_slots
# 44 0x5D469B53C536D19CD15E40763ACC23C7 0.1644 0.0% 412 0.0004 0.01 INSERT livestream_tags
# 45 0x5AEB6E4A781A3854CF642125E293FEE0 0.1473 0.0% 322 0.0005 0.00 INSERT reactions
# 46 0x651E3772B8767A368CB47EE7389EEB33 0.1418 0.0% 15 0.0095 0.01 SELECT livestream_tags
# 47 0x4B6FA79E206C6CED71D433A2FC998D69 0.1203 0.0% 144 0.0008 0.00 SELECT
# 48 0xE64D50F7AFC1AD5F465809A92DF4935E 0.1010 0.0% 33 0.0031 0.00 SELECT reactions
# 49 0x08A6ACD83D579DD8A808134B32AD376B 0.0845 0.0% 1 0.0845 0.00 TRUNCATE TABLE livestream_tags
# 50 0x1FB70DBF74628C9F2E9F0C3478771936 0.0806 0.0% 1 0.0806 0.00 TRUNCATE TABLE ng_words
# 51 0xEE4C51AE2BF74414C4892CBE11E894AA 0.0744 0.0% 34 0.0022 0.00 SELECT livecomments
# 52 0x93A42F50BF286ACA749DF5F342FAC07B 0.0716 0.0% 1 0.0716 0.00 TRUNCATE TABLE livecomment_reports
# 53 0xBB7F4DC4E67BF30E0588D296FFAF009F 0.0639 0.0% 1 0.0639 0.00 TRUNCATE TABLE tags
# 54 0xE623383C5D789800DC0946925F90039F 0.0637 0.0% 269 0.0002 0.00 SELECT domains
# 55 0xDBB1C17D6ABA0156D8ABCE105DDDA1B2 0.0634 0.0% 1 0.0634 0.00 TRUNCATE TABLE users
# 56 0xFB296F703ACC41C3F94A9B7D75044F3C 0.0629 0.0% 1 0.0629 0.00 TRUNCATE TABLE reactions
# 57 0x2AAED5867123C749367FD8E4BBD796D2 0.0553 0.0% 1 0.0553 0.00 TRUNCATE TABLE livecomments
# 58 0x253CA101A906B3D56A95D1B8DCEE28EF 0.0550 0.0% 1 0.0550 0.00 TRUNCATE TABLE icons
# 59 0xD2978B45C67B47B5D73AC532EB40A95E 0.0547 0.0% 1 0.0547 0.00 TRUNCATE TABLE themes
# 60 0xA7C2E59AEF14D03CB65B227F3E3BA469 0.0537 0.0% 1 0.0537 0.00 TRUNCATE TABLE reservation_slots
# 61 0xAFFDC331C1D4BA089978A0B8DD00BFC8 0.0524 0.0% 1 0.0524 0.00 TRUNCATE TABLE livestreams
# 62 0x9C697B3F0446BBF7602663588252F020 0.0517 0.0% 1 0.0517 0.00 TRUNCATE TABLE livestream_viewers_history
# 63 0x81E419F4B58AEB9B280B03DE44DD8B94 0.0487 0.0% 113 0.0004 0.00 SELECT livecomments
# 64 0x07F6C3FF39ADD79FC63923A7EE938953 0.0474 0.0% 1 0.0474 0.00 INSERT livecomments
# 65 0x544239977D2094F805A7B062DE95673A 0.0467 0.0% 82 0.0006 0.00 SELECT tags
# 66 0xDFEFE5BA5D8654534DC8550C6E3DC9C0 0.0450 0.0% 1 0.0450 0.00 DELETE records
# 67 0x24C44C3518CE12293EF12410AEDA2393 0.0419 0.0% 35 0.0012 0.00 SELECT livestreams
# 68 0x19A1F14EFC0F221D30AFCB1E1344BEBD 0.0352 0.0% 7 0.0050 0.00 SELECT users
# 69 0x8D589AFA4DFAEEED85FFF5AA78E5FF6A 0.0332 0.0% 269 0.0001 0.00 BEGIN
# 70 0x74232BDFFB94C567F0340DBE3285E458 0.0303 0.0% 1 0.0303 0.00 INSERT reactions
# 71 0x050F7D44808F43E5D33D0B90BCF57CC9 0.0264 0.0% 2 0.0132 0.00 SELECT livestreams
# 72 0xB962B14EDA3C9149DE2F648A5F0347D5 0.0216 0.0% 1 0.0216 0.00 SELECT domains records
# 73 0x827F41D30F8E37F04D8BDCD46C556FB3 0.0201 0.0% 45 0.0004 0.00 INSERT livecomment_reports
# 74 0x466EE4C87B17CAD4E692DE1D44EAD84D 0.0142 0.0% 34 0.0004 0.00 SELECT livecomment_reports
# 75 0x0C655718656DD9DDA39A0D11554A0C64 0.0108 0.0% 25 0.0004 0.00 INSERT ng_words
# 76 0xA0D956F292B7FEA0DCE68A5DD5F529E1 0.0100 0.0% 26 0.0004 0.00 DELETE livestream_viewers_history
# 77 0xBF3194A2446AC20FC99B6CC7FA476A57 0.0083 0.0% 35 0.0002 0.00 INSERT livestream_viewers_history
# 78 0xB871CC5B0472067402F5739D108B2C1C 0.0074 0.0% 25 0.0003 0.00 SELECT livestreams
# 79 0x2B760561C10B5D133155AA306D0F407C 0.0070 0.0% 18 0.0004 0.00 SELECT livecomments
# 80 0xF985E5835B84E84C7A721801818E98CE 0.0029 0.0% 2 0.0015 0.00 SELECT users livestreams reactions
# 81 0x49F80FBE1AC70F23A3DD076174FF1AA9 0.0023 0.0% 2 0.0011 0.00 SELECT users livestreams reactions
# 82 0x20CD15DC47AF2F861B8F3C25D195ABE9 0.0015 0.0% 15 0.0001 0.00 SELECT tags
# 83 0x8B2044ADAE690405979131C33185F22A 0.0013 0.0% 6 0.0002 0.00 SELECT users
# 84 0x2C17BCA1E1077820CDC2EC6106F4D93E 0.0012 0.0% 18 0.0001 0.00 SELECT livestream_viewers_history
# 85 0xEDBC971AEC392917AA353644DE4C4CB4 0.0009 0.0% 451 0.0000 0.00 ADMIN QUIT
# 86 0x0E7680C04FF2596BE3A3649C5FAC418D 0.0009 0.0% 9 0.0001 0.00 SELECT
# 87 0x8F885091E23CB955C051B1204EE7D91D 0.0006 0.0% 2 0.0003 0.00 SELECT livestreams reactions
# 88 0xEBE4AF9F935DE1D48BB5BB3558C7FCC4 0.0006 0.0% 2 0.0003 0.00 SELECT livestreams livecomments
# 89 0xC4625761E0CFD817F41B4802F152A489 0.0005 0.0% 1 0.0005 0.00 SELECT livecomments
# 90 0xE84E602C0D0858D5661956B70D72A215 0.0003 0.0% 1 0.0003 0.00 SELECT icons
# 91 0xF085F31DC1964EA538732B713E4B4108 0.0002 0.0% 2 0.0001 0.00 SELECT livestreams livestream_viewers_history
# 92 0x394E66DDE2823A903078D4C0F235B948 0.0002 0.0% 2 0.0001 0.00 SELECT livestreams livecomment_reports
# 93 0xE8390778DC20D4CC04FE01C5B31FD305 0.0000 0.0% 1 0.0000 0.00 ADMIN PING
# Query 1: 815.33 QPS, 0.28x concurrency, ID 0xDA556F9115773A1A99AA0165670CE848 at byte 41045121
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: 2023-11-25T04:31:07 to 2023-11-25T04:34:36
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 29 170403
# Exec time 15 59s 21us 212ms 343us 1ms 1ms 84us
# Lock time 0 16us 0 14us 0 0 0 0
# Rows sent 0 0 0 0 0 0 0 0
# Rows examine 0 0 0 0 0 0 0 0
# Query size 12 4.88M 30 30 30 30 0 30
# String:
# Databases isupipe (168781/99%), isudns (1622/0%)
# Hosts localhost
# Users isucon (168781/99%), isudns (1622/0%)
# Query_time distribution
# 1us
# 10us ################################################################
# 100us #############################################
# 1ms #########
# 10ms #
# 100ms #
# 1s
# 10s+
administrator command: Prepare\G
# Query 2: 56.31 QPS, 0.40x concurrency, ID 0x42EF7D7D98FBCC9723BF896EBFC51D24 at byte 113699246
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.01
# Time range: 2023-11-25T04:32:48 to 2023-11-25T04:34:36
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 1 6082
# Exec time 11 44s 714us 64ms 7ms 19ms 6ms 5ms
# Lock time 2 22ms 0 4ms 3us 1us 66us 1us
# Rows sent 0 1.29k 0 1 0.22 0.99 0.41 0
# Rows examine 8 8.22M 1.25k 1.51k 1.38k 1.46k 75.30 1.33k
# Query size 2 838.08k 129 209 141.10 158.58 11.21 136.99
# String:
# Databases isudns
# Hosts localhost
# Users isudns
# Query_time distribution
# 1us
# 10us
# 100us #
# 1ms ################################################################
# 10ms ########################
# 100ms
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `isudns` LIKE 'records'\G
# SHOW CREATE TABLE `isudns`.`records`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT content,ttl,prio,type,domain_id,disabled,name,auth FROM records WHERE disabled=0 and name='pipe.u.isucon.dev' and domain_id=2\G
# Query 3: 165.02 QPS, 0.37x concurrency, ID 0x38BC86A45F31C6B1EE324671506C898A at byte 75960083
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: 2023-11-25T04:33:05 to 2023-11-25T04:34:36
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 2 15017
# Exec time 8 33s 243us 51ms 2ms 7ms 3ms 1ms
# Lock time 4 31ms 0 4ms 2us 1us 37us 1us
# Rows sent 6 14.67k 1 1 1 1 0 1
# Rows examine 17 16.22M 1000 1.24k 1.11k 1.20k 83.56 1.09k
# Query size 1 599.13k 38 41 40.85 40.45 0.66 40.45
# String:
# Databases isupipe
# Hosts localhost
# Users isucon
# Query_time distribution
# 1us
# 10us
# 100us ####################################################
# 1ms ################################################################
# 10ms ##
# 100ms
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `isupipe` LIKE 'themes'\G
# SHOW CREATE TABLE `isupipe`.`themes`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT * FROM themes WHERE user_id = 1001\G
# Query 4: 45.01 QPS, 0.37x concurrency, ID 0xF1B8EF06D6CA63B24BFF433E06CCEB22 at byte 74071105
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.01
# Time range: 2023-11-25T04:33:05 to 2023-11-25T04:34:33
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 3961
# Exec time 8 32s 1ms 77ms 8ms 30ms 10ms 1ms
# Lock time 2 22ms 0 7ms 5us 1us 121us 1us
# Rows sent 1 3.87k 1 1 1 1 0 1
# Rows examine 8 8.02M 1.96k 2.45k 2.07k 2.38k 146.70 1.96k
# Query size 1 637.51k 163 166 164.81 158.58 0 158.58
# String:
# Databases isupipe
# Hosts localhost
# Users isucon
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms ################################################################
# 10ms ############################
# 100ms
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `isupipe` LIKE 'users'\G
# SHOW CREATE TABLE `isupipe`.`users`\G
# SHOW TABLE STATUS FROM `isupipe` LIKE 'livestreams'\G
# SHOW CREATE TABLE `isupipe`.`livestreams`\G
# SHOW TABLE STATUS FROM `isupipe` LIKE 'livecomments'\G
# SHOW CREATE TABLE `isupipe`.`livecomments`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT IFNULL(SUM(l2.tip), 0) FROM users u
INNER JOIN livestreams l ON l.user_id = u.id
INNER JOIN livecomments l2 ON l2.livestream_id = l.id
WHERE u.id = 158\G
# Query 5: 45.05 QPS, 0.35x concurrency, ID 0xDB74D52D39A7090F224C4DEEAF3028C9 at byte 113687663
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.01
# Time range: 2023-11-25T04:33:05 to 2023-11-25T04:34:33
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 0 3964
# Exec time 8 31s 1ms 94ms 8ms 28ms 10ms 1ms
# Lock time 3 23ms 0 5ms 5us 1us 115us 1us
# Rows sent 1 3.87k 1 1 1 1 0 1
# Rows examine 8 8.04M 1.96k 2.42k 2.08k 2.38k 146.78 1.96k
# Query size 1 560.57k 143 146 144.81 143.84 0.86 143.84
# String:
# Databases isupipe
# Hosts localhost
# Users isucon
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms ################################################################
# 10ms ##########################
# 100ms
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `isupipe` LIKE 'users'\G
# SHOW CREATE TABLE `isupipe`.`users`\G
# SHOW TABLE STATUS FROM `isupipe` LIKE 'livestreams'\G
# SHOW CREATE TABLE `isupipe`.`livestreams`\G
# SHOW TABLE STATUS FROM `isupipe` LIKE 'reactions'\G
# SHOW CREATE TABLE `isupipe`.`reactions`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT COUNT(*) FROM users u
INNER JOIN livestreams l ON l.user_id = u.id
INNER JOIN reactions r ON r.livestream_id = l.id
WHERE u.id = 283\G
2023-11-25T04:32:48.317Z info isupipe-benchmarker SSL接続が有効になっています
2023-11-25T04:32:48.317Z info isupipe-benchmarker 静的ファイルチェックを行います
2023-11-25T04:32:48.317Z info isupipe-benchmarker 静的ファイルチェックが完了しました
2023-11-25T04:32:48.317Z info isupipe-benchmarker webappの初期化を行います
2023-11-25T04:33:05.196Z info isupipe-benchmarker ベンチマーク走行前のデータ整合性チェックを行います
2023-11-25T04:33:33.344Z info isupipe-benchmarker 整合性チェックが成功しました
2023-11-25T04:33:33.344Z info isupipe-benchmarker ベンチマーク走行を開始します
2023-11-25T04:34:33.345Z info isupipe-benchmarker ベンチマーク走行を停止します
2023-11-25T04:34:33.346Z warn isupipe-benchmarker ライブコメントを配信に投稿できないため、視聴者が離脱します {"viewer": "naokikato1", "livestream_id": 7556, "error": "Post \"https://endoyui0.u.isucon.dev:443/api/livestream/7556/livecomment\": context canceled: ベンチマーク走行が継続できないエラーが発生しました"}
2023-11-25T04:34:33.347Z warn isupipe-benchmarker ライブコメントを配信に投稿できないため、視聴者が離脱します {"viewer": "yutamiura0", "livestream_id": 7541, "error": "Post \"https://jun890.u.isucon.dev:443/api/livestream/7541/livecomment\": context canceled: ベンチマーク走行が継続できないエラーが発生しました"}
2023-11-25T04:34:33.607Z info isupipe-benchmarker ベンチマーク走行終了
2023-11-25T04:34:33.607Z info isupipe-benchmarker 最終チェックを実施します
2023-11-25T04:34:36.734Z info isupipe-benchmarker 最終チェックが成功しました
2023-11-25T04:34:36.734Z info isupipe-benchmarker 重複排除したログを以下に出力します
2023-11-25T04:34:36.734Z info isupipe-benchmarker 配信を最後まで視聴できた視聴者数 {"viewers": 25}
[一般エラー] POST /api/livestream/7522/livecomment/1013/report へのリクエストに対して、期待されたHTTPステータスコードが確認できませんでした (expected:201, actual:404)
[一般エラー] POST /api/livestream/7529/livecomment/1050/report へのリクエストに対して、期待されたHTTPステータスコードが確認できませんでした (expected:201, actual:404)
[一般エラー] POST /api/livestream/7529/livecomment/1051/report へのリクエストに対して、期待されたHTTPステータスコードが確認できませんでした (expected:201, actual:404)
[リクエストタイムアウト] GET /api/user/satomigoto0/statistics: Get "https://pipe.u.isucon.dev:443/api/user/satomigoto0/statistics": context deadline exceeded (Client.Timeout exceeded while awaiting headers): タイムアウトによりリクエスト失敗
[リクエストタイムアウト] GET /api/user/yosuke580/statistics: Get "https://pipe.u.isucon.dev:443/api/user/yosuke580/statistics": context deadline exceeded (Client.Timeout exceeded while awaiting headers): タイムアウトによりリクエスト失敗
[リクエストタイムアウト] GET /api/user/kanasasaki0/statistics: Get "https://pipe.u.isucon.dev:443/api/user/kanasasaki0/statistics": context deadline exceeded (Client.Timeout exceeded while awaiting headers): タイムアウトによりリクエスト失敗
[リクエストタイムアウト] GET /api/user/fujitajun0/statistics: Get "https://pipe.u.isucon.dev:443/api/user/fujitajun0/statistics": context deadline exceeded (Client.Timeout exceeded while awaiting headers): タイムアウトによりリクエスト失敗
名前解決成功数 2312
売上: 5870