search

niftyisucon / isucon13

0 stars 0 forks source link

Benchmark result on isu2(8703) #23

Open github-actions[bot] opened 10 months ago

github-actions[bot] commented 10 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)
5064 0 5062 0 2 0 GET /api/user/[a-zA-Z0-9]+/icon 0.004 0.704 174.001 0.034 0.088 0.128 0.264 0.052 0.000 171652.000 317550326.000 62707.410
496 0 493 0 3 0 GET /api/livestream/[a-zA-Z0-9]+/livecomment 0.004 0.936 138.532 0.279 0.580 0.680 0.860 0.206 0.000 64028.000 9231394.000 18611.681
529 0 525 0 4 0 GET /api/livestream/[a-zA-Z0-9]+/reaction 0.004 1.060 132.267 0.250 0.556 0.648 0.864 0.209 0.000 60932.000 8270156.000 15633.565
21 0 18 0 3 0 POST /api/livestream/[a-zA-Z0-9]+/moderate 0.032 8.908 94.982 4.523 8.164 8.892 8.908 2.273 0.000 23.000 414.000 19.714
538 0 535 0 3 0 POST /api/livestream/[a-zA-Z0-9]+/livecomment 0.004 0.532 72.298 0.134 0.204 0.264 0.408 0.068 57.000 2687.000 1060396.000 1970.996
85 0 85 0 0 0 GET /api/livestream/[a-zA-Z0-9]+$ 0.004 2.028 69.229 0.814 1.408 1.616 2.028 0.427 1465.000 128052.000 5905160.000 69472.471
290 0 287 0 2 1 POST /api/register 0.004 0.608 60.058 0.207 0.300 0.356 0.576 0.088 0.000 513.000 134581.000 464.072
104 0 100 0 4 0 POST /api/livestream/[a-zA-Z0-9]+$ 0.116 0.932 43.645 0.420 0.760 0.840 0.932 0.293 0.000 1465.000 113216.000 1088.615
460 0 460 0 0 0 POST /api/livestream/[a-zA-Z0-9]+/reaction 0.004 0.284 28.584 0.062 0.116 0.152 0.224 0.043 1552.000 2208.000 849191.000 1846.067
1 0 1 0 0 0 POST /api/initialize 10.752 10.752 10.752 10.752 10.752 10.752 10.752 0.000 27.000 27.000 27.000 27.000
108 0 108 0 0 0 GET /api/livestream$ 0.012 0.232 10.580 0.098 0.164 0.184 0.220 0.048 3.000 22488.000 150174.000 1390.500
295 0 292 0 3 0 POST /api/login 0.004 0.276 9.724 0.033 0.092 0.132 0.244 0.045 0.000 64.000 128.000 0.434
56 0 56 0 0 0 GET /api/livestream/[a-zA-Z0-9]+/ngwords 0.004 0.372 5.760 0.103 0.176 0.260 0.372 0.066 5.000 268.000 1188.000 21.214
93 0 92 0 0 1 GET /api/livestream/[a-zA-Z0-9]+/report 0.004 0.348 5.212 0.056 0.152 0.204 0.348 0.071 3.000 21606.000 85523.000 919.602
87 0 87 0 0 0 GET /api/tag 0.004 0.388 4.308 0.050 0.128 0.184 0.388 0.063 6089.000 6095.000 530091.000 6093.000
11 0 11 0 0 0 GET /api/user/[a-zA-Z0-9]+/statistics 0.024 0.448 3.380 0.307 0.424 0.448 0.448 0.143 133.000 152.000 1552.000 141.091
50 0 50 0 0 0 POST /api/livestream/[a-zA-Z0-9]+/enter 0.004 0.348 3.152 0.063 0.124 0.228 0.348 0.071 0.000 0.000 0.000 0.000
40 0 40 0 0 0 DELETE /api/livestream/[a-zA-Z0-9]+/exit 0.004 0.252 2.044 0.051 0.104 0.220 0.252 0.061 0.000 0.000 0.000 0.000
9 0 9 0 0 0 GET /api/user/[a-zA-Z0-9]+/livestream 0.096 0.204 1.252 0.139 0.204 0.204 0.204 0.035 1237.000 3877.000 22840.000 2537.778
287 0 287 0 0 0 POST /api/icon 0.000 0.016 0.692 0.002 0.004 0.008 0.012 0.003 14.000 14.000 4018.000 14.000
10 0 10 0 0 0 GET /api/user/[a-zA-Z0-9]+/theme 0.004 0.284 0.484 0.048 0.056 0.284 0.284 0.080 38.000 38.000 380.000 38.000
2 0 2 0 0 0 GET /api/livestream/[a-zA-Z0-9]+/statistics 0.016 0.020 0.036 0.018 0.020 0.020 0.020 0.002 100.000 102.000 202.000 101.000
4 0 4 0 0 0 GET /api/user/[a-zA-Z0-9]+$ 0.000 0.004 0.004 0.001 0.004 0.004 0.004 0.002 235.000 247.000 964.000 241.000
1 0 1 0 0 0 GET /api/payment 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 21.000 21.000 21.000 21.000
github-actions[bot] commented 10 months ago 
Reading from STDIN ...

# 36s user time, 100ms system time, 35.97M rss, 42.36M vsz
# Current date: Sat Nov 25 06:19:47 2023
# Hostname: ip-192-168-0-12
# Files: STDIN
# Overall: 613.65k total, 89 unique, 4.26k QPS, 2.18x concurrency ________
# Time range: 2023-11-25T06:15:56 to 2023-11-25T06:18:20
# Attribute          total     min     max     avg     95%  stddev  median
# ============     ======= ======= ======= ======= ======= ======= =======
# Exec time           314s     1us   383ms   511us     2ms     3ms    60us
# Lock time          704ms       0    48ms     1us     1us    82us       0
# Rows sent        279.16k       0   7.32k    0.47    0.99   16.29       0
# Rows examine      36.18M       0  16.60k   61.82    1.96  607.01       0
# Query size        33.39M       5   1.94M   57.05  166.51   2.64k   31.70

# Profile
# Rank Query ID                           Response time Calls  R/Call V/M 
# ==== ================================== ============= ====== ====== ====
#    1 0xDA556F9115773A1A99AA0165670CE848 53.7131 17.1% 184400 0.0003  0.01 ADMIN PREPARE
#    2 0x42EF7D7D98FBCC9723BF896EBFC51D24 49.5255 15.8%   6426 0.0077  0.01 SELECT records
#    3 0x3D83BC87F3B3A00D571FFC8104A6E50C 32.1571 10.2%   5025 0.0064  0.01 SELECT records
#    4 0x64CC8A4E8E4B390203375597CE4D611F 21.7100  6.9%    487 0.0446  0.01 SELECT ng_words
#    5 0xFBC5564AE716EAE82F20BFB45F6C37E7 19.8262  6.3%  64594 0.0003  0.00 SELECT tags
#    6 0x59F1B6DD8D9FEC059E55B3BFD624E8C3 17.9305  5.7%    870 0.0206  0.01 SELECT reservation_slots
#    7 0x38BC86A45F31C6B1EE324671506C898A 14.6793  4.7%  25483 0.0006  0.00 SELECT themes
#    8 0xFFFCA4D67EA0A788813031B8BBC3B329 12.4383  4.0%   3543 0.0035  0.00 COMMIT
#    9 0x4ADE2DC90689F1C4891749AF54FB8D14 11.3428  3.6%  28797 0.0004  0.00 DELETE SELECT livecomments
#   10 0xEA1E6309EEEFF9A6831AD2FB940FC23C  8.1105  2.6%  25185 0.0003  0.00 SELECT users
#   11 0x22279D81D51006139E0C76405B54C261  6.4446  2.1%   7356 0.0009  0.00 SELECT domains domainmetadata
#   12 0xF7144185D9A142A426A36DC55C1D2623  6.1776  2.0%  15320 0.0004  0.00 SELECT livestream_tags
#   13 0x9EAD6C0CE525E3693EE27FFC9AAF05A3  5.9403  1.9%    128 0.0464  0.01 SELECT livestreams
#   14 0x8F7679D452333ED3C7D60D22131CEFD4  5.6942  1.8%  20074 0.0003  0.00 ADMIN RESET STMT
#   15 0x859BBB7E9D760686137A944406874C4D  5.0871  1.6%    287 0.0177  0.01 DELETE records
#   16 0xA3401CA3ABCC04C3AB221DB8AD5CBF26  4.4349  1.4%    101 0.0439  0.03 UPDATE reservation_slots
#   17 0xD2A0864774622BA36F6557496405CF75  4.2182  1.3%   1287 0.0033  0.00 INSERT themes
#   18 0xDFFCC1D78939C4D781C7C58349101F50  4.1935  1.3%   1000 0.0042  0.00 INSERT users
#   19 0xD6032FE08E1FE706A928B8B7CBA06B85  3.7574  1.2%  12403 0.0003  0.00 SELECT livestreams
#   20 0x7F9C0C0BA9473953B723EE16C08655F1  3.7316  1.2%    102 0.0366  0.02 SELECT reservation_slots
#   21 0x9AC623FA477E73A44D191D296850A025  3.5753  1.1%    574 0.0062  0.01 SELECT records
#   22 0xEDE18C1523658A19E07525EAFCBA6BFE  2.7999  0.9%     56 0.0500  0.01 SELECT ng_words
#   23 0x07890000813C4CC7111FD2D3F3B3B4EB  1.9701  0.6% 184381 0.0000  0.00 ADMIN CLOSE STMT
#   24 0x3F155F5E71EFF856F0CF7B8430DE8C23  1.9656  0.6%   5377 0.0004  0.00 SELECT users
#   25 0xFFF66E9B3D962FA319C8068B5C1997CD  1.5108  0.5%   5082 0.0003  0.00 ROLLBACK
#   26 0x611999F76068C4DC4F90E0A389918E63  1.3456  0.4%     11 0.1223  0.03 SELECT users livestreams reactions livestreams livecomments
#   27 0xB78E63D0D9C72DDDAB7A3E53517FA04C  1.3330  0.4%    447 0.0030  0.00 SELECT livecomments
#   28 0xAD0C28443E1E5CFAFF1569DBB4F7E63A  1.1922  0.4%    482 0.0025  0.00 SELECT reactions
#   29 0x9E2DA589A20EC24C34E11DDE0FBF5564  1.1769  0.4%   8347 0.0001  0.00 START
#   30 0xB08B7B7486D2DFE2F2FE9CE78689FD79  0.7452  0.2%     20 0.0373  0.01 SELECT ng_words
#   31 0x77FB9E134D073862D1E78FEEC3436291  0.4218  0.1%   1567 0.0003  0.00 INSERT records
#   32 0x98F959E03B684A5538FD8402A0EE94AD  0.3942  0.1%    103 0.0038  0.00 INSERT tags
#   33 0x02B6A87E51A5A1B7646675DB67C57DE3  0.3465  0.1%      1 0.3465  0.00 INSERT ng_words
#   34 0x80E10371CE74ED05E09C79C72C73F8E1  0.3088  0.1%    101 0.0031  0.21 INSERT livestreams
#   35 0x0C1FCBB4E25B178AA3A46D4FECBA9BDC  0.2917  0.1%     22 0.0133  0.00 INSERT livestream_tags
#   36 0xF3A502CCF34F7DA288CC1B75AD5AFA37  0.2772  0.1%    486 0.0006  0.00 INSERT livecomments
#   37 0x41F805E95754958A974F41AE07BEA625  0.2600  0.1%     24 0.0108  0.01 SELECT livecomments
#   38 0x651E3772B8767A368CB47EE7389EEB33  0.2421  0.1%     18 0.0135  0.01 SELECT livestream_tags
#   39 0xF985E5835B84E84C7A721801818E98CE  0.1847  0.1%     11 0.0168  0.01 SELECT users livestreams reactions
#   40 0xB9AC05A7AE6C4E30B5B45F6F3CE05BE0  0.1805  0.1%    576 0.0003  0.00 SET
#   41 0x64052B1C32B30DF53AB3292208B783B4  0.1675  0.1%    288 0.0006  0.00 INSERT users
#   42 0x5D469B53C536D19CD15E40763ACC23C7  0.1656  0.1%    422 0.0004  0.00 INSERT livestream_tags
#   43 0x5AEB6E4A781A3854CF642125E293FEE0  0.1625  0.1%    460 0.0004  0.00 INSERT reactions
#   44 0x49F80FBE1AC70F23A3DD076174FF1AA9  0.1565  0.0%     11 0.0142  0.01 SELECT users livestreams reactions
#   45 0xE64D50F7AFC1AD5F465809A92DF4935E  0.1343  0.0%     47 0.0029  0.00 SELECT reactions
#   46 0xDF0AAE38E2AAFC85E6F50569CEF2285D  0.1320  0.0%      1 0.1320  0.00 INSERT reservation_slots
#   47 0xEE4C51AE2BF74414C4892CBE11E894AA  0.1229  0.0%     49 0.0025  0.00 SELECT livecomments
#   48 0x2B760561C10B5D133155AA306D0F407C  0.0988  0.0%     36 0.0027  0.01 SELECT livecomments
#   49 0xE623383C5D789800DC0946925F90039F  0.0620  0.0%    288 0.0002  0.00 SELECT domains
#   50 0x544239977D2094F805A7B062DE95673A  0.0517  0.0%     87 0.0006  0.00 SELECT tags
#   51 0x4B6FA79E206C6CED71D433A2FC998D69  0.0466  0.0%    116 0.0004  0.00 SELECT
#   52 0x8D589AFA4DFAEEED85FFF5AA78E5FF6A  0.0438  0.0%    288 0.0002  0.00 BEGIN
#   53 0xAFFDC331C1D4BA089978A0B8DD00BFC8  0.0436  0.0%      1 0.0436  0.00 TRUNCATE TABLE livestreams
#   54 0xDBB1C17D6ABA0156D8ABCE105DDDA1B2  0.0426  0.0%      1 0.0426  0.00 TRUNCATE TABLE users
#   55 0x08A6ACD83D579DD8A808134B32AD376B  0.0407  0.0%      1 0.0407  0.00 TRUNCATE TABLE livestream_tags
#   56 0x466EE4C87B17CAD4E692DE1D44EAD84D  0.0406  0.0%     93 0.0004  0.00 SELECT livecomment_reports
#   57 0x24C44C3518CE12293EF12410AEDA2393  0.0403  0.0%     66 0.0006  0.00 SELECT livestreams
#   58 0xDFEFE5BA5D8654534DC8550C6E3DC9C0  0.0401  0.0%      1 0.0401  0.00 DELETE records
#   59 0x1FB70DBF74628C9F2E9F0C3478771936  0.0393  0.0%      1 0.0393  0.00 TRUNCATE TABLE ng_words
#   60 0x07F6C3FF39ADD79FC63923A7EE938953  0.0383  0.0%      1 0.0383  0.00 INSERT livecomments
#   61 0x81E419F4B58AEB9B280B03DE44DD8B94  0.0382  0.0%    132 0.0003  0.00 SELECT livecomments
#   62 0x2AAED5867123C749367FD8E4BBD796D2  0.0361  0.0%      1 0.0361  0.00 TRUNCATE TABLE livecomments
#   63 0xD2978B45C67B47B5D73AC532EB40A95E  0.0354  0.0%      1 0.0354  0.00 TRUNCATE TABLE themes
#   64 0xBB7F4DC4E67BF30E0588D296FFAF009F  0.0313  0.0%      1 0.0313  0.00 TRUNCATE TABLE tags
#   65 0x253CA101A906B3D56A95D1B8DCEE28EF  0.0310  0.0%      1 0.0310  0.00 TRUNCATE TABLE icons
#   66 0xFB296F703ACC41C3F94A9B7D75044F3C  0.0293  0.0%      1 0.0293  0.00 TRUNCATE TABLE reactions
#   67 0xA7C2E59AEF14D03CB65B227F3E3BA469  0.0284  0.0%      1 0.0284  0.00 TRUNCATE TABLE reservation_slots
#   68 0x93A42F50BF286ACA749DF5F342FAC07B  0.0282  0.0%      1 0.0282  0.00 TRUNCATE TABLE livecomment_reports
#   69 0x9C697B3F0446BBF7602663588252F020  0.0270  0.0%      1 0.0270  0.00 TRUNCATE TABLE livestream_viewers_history
#   70 0xBF3194A2446AC20FC99B6CC7FA476A57  0.0268  0.0%     50 0.0005  0.00 INSERT livestream_viewers_history
#   71 0x74232BDFFB94C567F0340DBE3285E458  0.0221  0.0%      1 0.0221  0.00 INSERT reactions
#   72 0xE4555A2709C09FD9BFF6688D80B0AA49  0.0204  0.0%      2 0.0102  0.00 SELECT livestreams reactions livecomments
#   73 0xA0D956F292B7FEA0DCE68A5DD5F529E1  0.0165  0.0%     40 0.0004  0.00 DELETE livestream_viewers_history
#   74 0x2C17BCA1E1077820CDC2EC6106F4D93E  0.0147  0.0%     36 0.0004  0.00 SELECT livestream_viewers_history
#   75 0x827F41D30F8E37F04D8BDCD46C556FB3  0.0121  0.0%     49 0.0002  0.00 INSERT livecomment_reports
#   76 0x0C655718656DD9DDA39A0D11554A0C64  0.0085  0.0%     20 0.0004  0.00 INSERT ng_words
#   77 0x8B2044ADAE690405979131C33185F22A  0.0072  0.0%     10 0.0007  0.00 SELECT users
#   78 0xB871CC5B0472067402F5739D108B2C1C  0.0033  0.0%     20 0.0002  0.00 SELECT livestreams
#   79 0x20CD15DC47AF2F861B8F3C25D195ABE9  0.0025  0.0%     18 0.0001  0.00 SELECT tags
#   80 0x751417D45B8E80EE5CBA2034458B5BC9  0.0022  0.0%      2 0.0011  0.00 SHOW DATABASES
#   81 0x489B4CEB2F4301A7132628303F99240D  0.0018  0.0%      2 0.0009  0.00 SHOW TABLES
#   82 0xEDBC971AEC392917AA353644DE4C4CB4  0.0009  0.0%    428 0.0000  0.00 ADMIN QUIT
#   83 0x0E7680C04FF2596BE3A3649C5FAC418D  0.0008  0.0%     11 0.0001  0.00 SELECT
#   84 0xEBE4AF9F935DE1D48BB5BB3558C7FCC4  0.0006  0.0%      2 0.0003  0.00 SELECT livestreams livecomments
#   85 0x8F885091E23CB955C051B1204EE7D91D  0.0005  0.0%      2 0.0002  0.00 SELECT livestreams reactions
#   86 0xC4625761E0CFD817F41B4802F152A489  0.0003  0.0%      1 0.0003  0.00 SELECT livecomments
#   87 0xF085F31DC1964EA538732B713E4B4108  0.0002  0.0%      2 0.0001  0.00 SELECT livestreams livestream_viewers_history
#   88 0xE84E602C0D0858D5661956B70D72A215  0.0002  0.0%      1 0.0002  0.00 SELECT icons
#   89 0x394E66DDE2823A903078D4C0F235B948  0.0001  0.0%      2 0.0001  0.00 SELECT livestreams livecomment_reports

# Query 1: 2.36k QPS, 0.69x concurrency, ID 0xDA556F9115773A1A99AA0165670CE848 at byte 14181769
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.01
# Time range: 2023-11-25T06:17:02 to 2023-11-25T06:18:20
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count         30  184400
# Exec time     17     54s    20us   383ms   291us     1ms     1ms    80us
# Lock time      0     4us       0     4us       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    15   5.28M      30      30      30      30       0      30
# String:
# Databases    isupipe (182665/99%), isudns (1735/0%)
# Hosts        localhost
# Users        isucon (182665/99%), isudns (1735/0%)
# Query_time distribution
#   1us
#  10us  ################################################################
# 100us  ########################################
#   1ms  #######
#  10ms  #
# 100ms  #
#    1s
#  10s+
administrator command: Prepare\G

# Query 2: 82.38 QPS, 0.63x concurrency, ID 0x42EF7D7D98FBCC9723BF896EBFC51D24 at byte 29984351
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.01
# Time range: 2023-11-25T06:17:02 to 2023-11-25T06:18:20
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count          1    6426
# Exec time     15     50s   700us    63ms     8ms    21ms     7ms     5ms
# Lock time      2    20ms       0     3ms     3us     1us    51us     1us
# Rows sent      0   2.00k       0       1    0.32    0.99    0.46       0
# Rows examine  24   8.74M   1.25k   1.53k   1.39k   1.46k   79.68   1.39k
# Query size     2 879.03k     129     214  140.08  151.03   10.92  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='4055a33czv80xg2fyl5q16ucyb90.u.isucon.dev' and domain_id=2\G

# Query 3: 64.42 QPS, 0.41x concurrency, ID 0x3D83BC87F3B3A00D571FFC8104A6E50C at byte 52479018
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.01
# Time range: 2023-11-25T06:17:02 to 2023-11-25T06:18:20
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count          0    5025
# Exec time     10     32s   661us    64ms     6ms    18ms     6ms     4ms
# Lock time      3    28ms       0     6ms     5us     1us    98us     1us
# Rows sent      0   2.58k       0       1    0.52    0.99    0.50    0.99
# Rows examine  18   6.83M   1.25k   1.53k   1.39k   1.46k   80.09   1.33k
# Query size     1 655.83k     126     213  133.65  151.03   10.11  124.25
# 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 type='SOA' and name='93l593oaacfr7e0aa9t8ft4r0.u.isucon.dev'\G

# Query 4: 7.27 QPS, 0.32x concurrency, ID 0x64CC8A4E8E4B390203375597CE4D611F at byte 24210463
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.01
# Time range: 2023-11-25T06:17:13 to 2023-11-25T06:18:20
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count          0     487
# Exec time      6     22s     4ms   105ms    45ms    82ms    21ms    42ms
# Lock time      0   978us       0   259us     2us     1us    14us     1us
# Rows sent      0     116       0       2    0.24    0.99    0.47       0
# Rows examine  18   6.66M  14.00k  14.02k  14.01k  13.78k       0  13.78k
# Query size     0  47.08k      97      99   98.99   97.36    0.30   97.36
# 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 'ng_words'\G
#    SHOW CREATE TABLE `isupipe`.`ng_words`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT id, user_id, livestream_id, word FROM ng_words WHERE user_id = 1014 AND livestream_id = 7526\G

# Query 5: 964.09 QPS, 0.30x concurrency, ID 0xFBC5564AE716EAE82F20BFB45F6C37E7 at byte 91606199
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: 2023-11-25T06:17:13 to 2023-11-25T06:18:20
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count         10   64594
# Exec time      6     20s    30us    35ms   306us     1ms   661us    84us
# Lock time     20   142ms       0     8ms     2us     1us    52us     1us
# Rows sent     22  63.08k       1       1       1       1       0       1
# Rows examine   0  63.08k       1       1       1       1       0       1
# Query size     5   1.97M      31      33   31.99   31.70    0.36   31.70
# 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 'tags'\G
#    SHOW CREATE TABLE `isupipe`.`tags`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT * FROM tags WHERE id = 32\G
Penpen7 commented 10 months ago 
2023-11-25T06:17:02.230Z    info    isupipe-benchmarker SSL接続が有効になっています
2023-11-25T06:17:02.230Z    info    isupipe-benchmarker 静的ファイルチェックを行います
2023-11-25T06:17:02.230Z    info    isupipe-benchmarker 静的ファイルチェックが完了しました
2023-11-25T06:17:02.230Z    info    isupipe-benchmarker webappの初期化を行います
2023-11-25T06:17:13.006Z    info    isupipe-benchmarker ベンチマーク走行前のデータ整合性チェックを行います
2023-11-25T06:17:20.891Z    info    isupipe-benchmarker 整合性チェックが成功しました
2023-11-25T06:17:20.891Z    info    isupipe-benchmarker ベンチマーク走行を開始します
2023-11-25T06:18:20.892Z    info    isupipe-benchmarker ベンチマーク走行を停止します
2023-11-25T06:18:20.893Z    warn    isupipe-benchmarker ライブコメントを配信に投稿できないため、視聴者が離脱します   {"viewer": "matsumotoasuka0", "livestream_id": 7524, "error": "Post \"https://endoyui0.u.isucon.dev:443/api/livestream/7524/livecomment\": context canceled: ベンチマーク走行が継続できないエラーが発生しました"}
2023-11-25T06:18:20.893Z    warn    isupipe-benchmarker ライブコメントを配信に投稿できないため、視聴者が離脱します   {"viewer": "xshimizu2", "livestream_id": 7558, "error": "Post \"https://maiokamoto0.u.isucon.dev:443/api/livestream/7558/livecomment\": context canceled: ベンチマーク走行が継続できないエラーが発生しました"}
2023-11-25T06:18:21.787Z    info    isupipe-benchmarker ベンチマーク走行終了
2023-11-25T06:18:21.787Z    info    isupipe-benchmarker 最終チェックを実施します
2023-11-25T06:18:21.787Z    info    isupipe-benchmarker 最終チェックが成功しました
2023-11-25T06:18:21.787Z    info    isupipe-benchmarker 重複排除したログを以下に出力します
2023-11-25T06:18:21.787Z    info    isupipe-benchmarker 配信を最後まで視聴できた視聴者数    {"viewers": 39}

[一般エラー] POST /api/livestream/7528/livecomment/1046/report へのリクエストに対して、期待されたHTTPステータスコードが確認できませんでした (expected:201, actual:404)
[一般エラー] GET /api/livestream/7528/report へのリクエストに対して、期待されたHTTPステータスコードが確認できませんでした (expected:200, actual:500)
[リクエストタイムアウト] POST /api/livestream/7560/enter: Post "https://mtanaka1.u.isucon.dev:443/api/livestream/7560/enter": read udp 10.0.31.160:57287->57.180.198.135:53: i/o timeout: タイムアウトによりリクエスト失敗
名前解決成功数 2292
売上: 8703